Upgrading Your SQL Server 2005 Skills to SQL Server 2008

SQL6158 : 4 Day Instructor-Led Workshop

Four days to take your SQL Server 2005 Skills into the 2008 Release

This four-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 database server skills to SQL Server 2008.  The course covers new features for both the database server and the Business Intelligence services (Analysis Services, Integration Services and Reporting Services). 

Modules on upgrading databases to SQL Server 2008, Transact-SQL enhancements and SQL Server Integration Services enhancements have been added to the base Microsoft course offering.

This class incorporates a case study. The case study provides the students with a real world scenario via a set of requirements. The student must design and implement their solution based on the requirements. This gives the students the ability to exercise the skills they learned during the class in a real world situation.

This course will be based on the SQL Server 2008 CTP6.

Prerequisites:
Before attending this course, students must have experience developing or administering SQL Server 2005 databases.

  • Administration and/or development experience with Microsoft SQL Server 2005
  • Knowledge of SQL Server 2005:
    • Database and server architecture
    • Installation and configuration
    • Database security
    • Database recovery (backup and restore)
    • Database and server monitoring
    • Replication
    • Transact SQL
    • Query Engine
    • DDL
    • DML
    • Optimization
    • Schema and Objects
    • Programming Objects
    • UDF
    • Triggers
    • Stored Procedures
    • Optimization
    • Data Warehousing Framework
    • Analysis Services
    • Integration Services
    • Reporting Services

Recommended Prerequisites:

Recommended completion of

  • Course 2780, Maintaining a Microsoft SQL Server 2005 Database
  • Course 2779 Implementing a Microsoft SQL Server 2005 Database
  • Course 2791, Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
  • Course 2792, Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
  • Course 2793, Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

or equivalent experience.


Topics covered:

  •   Overview of SQL Server 2008 Architecture
    • Installing SQL Server 2008
    • Upgrading from SQL Server 2005 to SQL Server 2008
  •   Managing SQL Server 2008
    • Creating a Configuration Server
    • Policy-based Management
    • Database Snapshot
    • Online Maintenance Operations
  •   Optimizing SQL Server 2008
    • Resource Governor
    • Configuring Management Data Warehouse
  •   Securing and Backup of SQL Server 2008
    • Transparent Data Encryption
    • Encrypted and Compressed Backup and Restore
  •   Data Availability in SQL Server 2008
    • Peer-to-Peer Replication
    • Database Mirroring
  •   Transact-SQL Enhancements
    • New Date and Time data types
    • Spatial Data Types
    • Filestream Storage
    • Table-valued Parameters
  •   Data Warehousing with SQL Server 2008
    • Change Data Capture
    • Merge statement
    • Working with Data Partitioning
  •   Enhancements to SQL Server 2008 Analysis Service
    • New Design Wizards
    • AMO Warnings
    • Creating Attribute Relationships
    • New Aggregation Design tools
    • Data Mining Enhancements
    • Separating Testing and Training data
    • Model Case filtering
    • Cross-validation reports
  •   Enhancements to SQL Server 2008 Reporting Services
    • Configuring Reporting Services Service
    • Report Designer Tool
    • Tablix functionality
    • Enhanced Charting Support
  •   Enhancements to SQL Server 2008 Integration Services
    • Data Profiling Task
    • Script support for C# programming language
    • Lookup task enhancements

At course completion:

After completing this course, students will be able to:

  •   Describe the new features of SQL Server 2008.
  •   Manage SQL Server 2008.
  •   Secure a SQL Server 2008 Database.
  •   Develop databases with SQL Server 2008.
  •   Create and maintain highly available SQL Server 2008 databases.
  •   Create and use a SQL Server 2008 data warehouse.
  •   Use SQL Server 2008 Reporting Services.
  •   Use SQL Server 2008 Integration Services.
  •   Use SQL Server 2008 Analysis Services.


Exams:  There are currently no MCP exams associated with this course.