Introduction
This three-day instructor-led course
provides students with the knowledge and skills to upgrade
their SQL Server 2005 skills to SQL Server 2008
Audience
This course is intended for experienced
SQL Server 2005 developers and database administrators who
want to upgrade their skills to SQL Server 2008.
At Course Completion
After completing this course, students
will be able to:
| • |
Describe the new features of SQL
Server 2008.
|
| • |
Manage SQL Server 2008.
|
| • |
Optimize 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 Analysis
Services.
|
Prerequisites
Before attending this course, students
must have experience developing or administering SQL Server
2005 databases.
Course Outline
Module 1: Introduction to SQL Server 2008
Lessons
| • |
The Evolution of SQL Server
|
| • |
Preparing for SQL Server 2008
|
Lab 1: Exploring SQL Server Books Online
| • |
Reviewing the SQL Server Books
Online Tutorials
|
| • |
Reviewing SQL Server Books Online
|
After completing this module, students
will be able to:
| • |
Describe the evolution of SQL
Server.
|
| • |
Prepare for SQL Server 2008.
|
Module 2: SQL Server 2008 Manageability
Enhancements
Lessons
| • |
Configuration Servers
|
| • |
Policy-Based Management
|
Lab 2: Managing SQL Server 2008
| • |
Creating a Configuration Server
|
| • |
Creating and Applying a Policy
|
After completing this module, students
will be able to:
| • |
Create and use a configuration
server.
|
| • |
Create and use policies.
|
Module 3: SQL Server 2008 Performance
Enhancements
Lessons
| • |
Managing Workloads with Resource
Governor
|
| • |
Monitoring Performance with the
Data Collector
|
| • |
Managing Performance with Plan
Freezing
|
Lab 3: Optimizing SQL Server 2008
| • |
Using Resource Governor
|
| • |
Using the Data Collector
|
After completing this module, students
will be able to:
| • |
Manage workloads with Resource
Governor.
|
| • |
Monitor performance with the Data
Collector.
|
| • |
Manage performance with Plan
Freezing.
|
Module 4: SQL Server 2008 Security
Enhancements
Lessons
| • |
Encrypting Databases
|
| • |
Auditing All Actions
|
Lab 4: Securing a SQL Server 2008 Database
| • |
Using Transparent Data Encryption
|
After completing this module, students
will be able to:
| • |
Encrypt databases.
|
| • |
Audit all actions.
|
Module 5: SQL Server 2008 Database
Development Enhancements
Lessons
| • |
Developer Tool Enhancements
|
| • |
Data Type Enhancements
|
| • |
Working with Spatial Data
|
Lab 5: Developing Databases with SQL
Server 2008
| • |
Using Date and Time Data Types
|
| • |
Using Spatial Data
|
After completing this module, students
will be able to:
| • |
Describe the developer tool
enhancements in SQL Server 2008.
|
| • |
Use the data type enhancements in
SQL Server 2008.
|
| • |
Work with spatial data.
|
Module 6: SQL Server 2008 Availability
Enhancements
Lessons
| • |
Always On Technologies
|
| • |
Transactional Peer-to-Peer
Replication
|
Lab 6: Maintaining High Availability
| • |
Configuring Peer-to-Peer
Replication
|
| • |
Adding a Replication Node
|
After completing this module, students
will be able to:
| • |
Describe the SQL Server 2008
always on technologies.
|
| • |
Implement transactional
peer-to-peer replication.
|
Module 7: SQL Server 2008 Data Warehousing
Enhancements
Lessons
| • |
ETL Enhancements
|
| • |
Using Partitioned Tables
|
| • |
Optimizing Data Storage
|
Lab 7: Data Warehousing with SQL Server
2008
| • |
Using Change Data Capture
|
| • |
Using the MERGE Statement
|
| • |
Working with Partitioned Data
|
After completing this module, students
will be able to:
| • |
Describe the ETL enhancements in
SQL Server 2008.
|
| • |
Use partitioned tables.
|
| • |
Optimize data storage.
|
Module 8: SQL Server 2008 Reporting
Services Enhancements
Lessons
| • |
Reporting Services Architecture
and Management
|
| • |
Authoring Reports
|
| • |
Report Processing and Rendering
|
Lab 8: Using SQL Server 2008 Reporting
Services
| • |
Creating a Report with Report
Designer
|
| • |
Managing Reporting Services
|
After completing this module, students
will be able to:
| • |
Describe the Reporting Services
architecture and management.
|
| • |
Author reports.
|
| • |
Understand report processing and
rendering.
|
Module 9: SQL Server 2008 Analysis
Services Enhancements
Lessons
| • |
Multidimensional Analysis with SQL
Server Analysis Services
|
| • |
Data Mining with SQL Server
Analysis Services
|
Lab 9: Using SQL Server 2008 Analysis
Services
| • |
Implementing Multidimensional
Analysis
|
| • |
Implementing Data Mining
|
After completing this module, students
will be able to:
| • |
Implement multidimensional
analysis.
|
| • |
Implement data mining.
|
