Course OutlineModule 1: An Introduction to SQL Server 2008Lessons - 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.
- Implement data mining.
|
| |
