Module 1: Introduction to SQL Server 2008Lessons
-
The Evolution of SQL Server
-
Preparing for SQL Server 2008
Lab : 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 EnhancementsLessons
-
Configuration Servers
-
Policy-Based Management
Lab : 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 EnhancementsLessons
-
Managing Workloads with Resource Governor
-
Monitoring Performance with the Data Collector
-
Managing Performance with Plan Freezing
Lab : 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 EnhancementsLessons
-
Encrypting Databases
-
Auditing All Actions
Lab : 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 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
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 EnhancementsLessons
-
Reporting Services Architecture and Management
-
Authoring Reports
-
Report Processing and Rendering
Lab : 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 EnhancementsLessons
-
Multidimensional Analysis with SQL Server Analysis Services
-
Data Mining with SQL Server 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.
- Implement data mining.
|
