|
Module 1: An Introduction to SQL Server 2008
Lessons
The Evolution of SQL Server
Preparing for SQL Server 2008
Lab : Exploring New Features in SQL Server 2008
Exploring the SQL Server Installation Center
Reviewing Tutorials in SQL Server Books Online
Reviewing Topics in 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 EnhancementsLessons
Central Management Servers
Policy-Based Management
Lab : Managing SQL Server 2008
Creating a Central Management Server
Creating and Applying a Policy
After completing this module, students will be able to:
Create and use a Central Management server.
Create and use policies.
Module 3: SQL Server 2008 Performance EnhancementsLessons
Managing Workloads by Using Resource Governor
Monitoring Performance by Using Data Collector
Managing Performance by Using Plan Freezing
Lab : Optimizing SQL Server 2008
Using Resource Governor
Using Data Collector
After completing this module, students will be able to:
Manage workloads by using Resource Governor.
Monitor performance by using Data Collector.
Manage performance by using plan freezing.
Module 4: SQL Server 2008 Security EnhancementsLessons
Encrypting Databases
SQL Server Audit
Lab : Securing and Auditing a SQL Server 2008 Database
Using Transparent Data Encryption
Configuring Auditing
After completing this module, students will be able to:
Encrypt databases.
Configure SQL Server Audit.
Module 5: SQL Server 2008 Database Development EnhancementsLessons
Developer Tool Enhancements
Data Type Enhancements
Working with Spatial Data
Lab : 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 EnhancementsLessons
Always-on Technologies
Transactional Peer-to-Peer Replication
Lab : 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 EnhancementsLessons
ETL Enhancements
Using Partitioned Tables
Optimizing Data Storage
Lab : Data Warehousing with SQL Server 2008
Using Change Data Capture
Using the MERGE Statement
Working with Partitioned Data
Compressing Data
After completing this module, students will be able to:
Describe the new extract, load, and transform (ETL) enhancements in SQL Server 2008.
Use partitioned tables.
Optimize data storage.
Module 8: SQL Server 2008 Reporting Services EnhancementsLessons
Reporting Services Architecture and Management
Authoring Reports
Report Processing and Rendering
Lab : Using SQL Server 2008 Reporting Services
Creating a Report
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 EnhancementsLessons
Multidimensional Analysis with SQL Server 2008 Analysis Services
Data Mining with SQL Server 2008 Analysis Services
Lab : Using SQL Server 2008 Analysis Services
Implementing Multidimensional Analysis
Implementing Data Mining
After completing this module, students will be able to:
Implement multidimensional analysis.
|
