SQL Server 2008 Hands On Seminar
Learn SQL Server 2008 in a two day Hands-On Seminar presented by Joe Homnick and other Microsoft Certified Trainers in SQL Server from Homnick Systems. We will supply you with a Virtual PC image and workbook. You can optionally, BYOL (bring your own laptop) to walk along with the instructor and/or take the materials with you for further lab work after the class.
What is a "Hands-On Seminar? This is a seminar format, pioneered by Homnick Systems in 2004, where the Instructor mostly uses demos to teach the attendee concepts originally presented in slide format. The attendee can approach this learning solution as a pure seminar without a laptop and then work on the courseware demos on their own time. Optionally, the attendee can "walk along" with the instructor on their own systems running a supplied VPC image. This "walk along" can be of varied involvement and should still be supplemented with lab work on their own time. Both approaches work very well in learning the concepts and the seminar attendees are usually evenly split on the approach they select.
Optional hands-on laptop system requirements to walk along with the instructor during demos and labs:
A laptop with a minimum of 2 gig of memory, USB 2.0 port and 10 gig of free disk space.
Who Should Attend: Database Administrators, Developers and managers who are familiar with the SQL 2005 feature set and want to learn about the new features found in SQL 2008. .
Course Outline-SQL Server 2008 New Features
Module 1 – SQL Server 2008 Management Overview
IDE – Features – Performance Studio – Resource Governor – Extended Events - Configuration Servers - Multi-server Script Execution - Policy-based Management
Module 2 – Database Engine
Read Ahead Scan Cache – Parallelism - Partitioning – Filter Indexes – Compression – Query Optimizer – Clustering – Replication - Mirroring
Module 3 – Security
Extensible Key Management - SQL Server Auditing - Integrated Authentication Enhancements - Transparent Data Encryption
Module 4 - TSQL
New Date and Time Data Types - Table-Valued Parameters - T-SQL Assign and Increment Operators - Row Constructors - Grouping Sets - MERGE statement - Dependency Views
Module 5 -Non-relational extensions
Spatial Data - Filestream Data Storage - XML Data and Query - Hierarchies and HierarchyID - Sparse Data Designs - Sparse Columns - Filtered Indexes - Filtered Statistics - Integrated Full Text
Module 6 Client programming
Occasionally Connected System Designs - SQL Server Compact Edition 3.5 - Programming SqlResultSet and DataSet - LINQ and future EDM Support - Server-Directed Synchronization - Sync Services
Module 7 Reporting Services (SSRS) Design
Accelerating Authoring with an Improved Designer - Creating More Flexible Reports with Tablix - Experiencing Improved Rendering - Adding Rich Data Visualization – Report Builder 2.0
Module 8 - SSRS Administration Programmability
Opportunities for Integration Using the Web Service - URL Access Changes in SQL Server 2008 - ReportExecution Web Service Changes - Visual Studio 2008 Report Viewer Control - Benefits of Eliminating IIS from the SSRS Architecture - Reporting Services 2008 Architecture - Migration of IIS Settings - URL Reservations - Authentication
Module 9 - Integration Services (SSIS)
Reviewing Integration Challenges - Integrating Any Data with ADO.NET - Increasing Developer Productivity - Improving Package Performance - Identifying Data Quality Issues - Managing Change in a Data Warehouse
Module 10 - Analysis Services (SSAS)
Accelerating Database Design with Improved Designers - Improving Performance with Aggregation Designs - Personalizing the Analysis Experience