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