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.
|
