For a referral to Microsoft Certified Partners for Learning Solutions (CPLSs) in your area, see the Microsoft Learning Web site at http://www.microsoft.com/learning/default.mspx. Call your local CPLS for more information and to register for classes.
Course Syllabus
Updating Your Microsoft SQL Server 2005 Skills to SQL
Server 2008
Elements of this syllabus are subject to change.
This three-day instructor-led course provides students with the knowledge and skills to update their skills in the Microsoft SQL Server 2005 data management software to SQL Server 2008.
Audience
This course is intended for developers and database administrators who are experienced with using SQL Server 2005 and want to update their skills to SQL Server 2008.
At Course Completion
After completing this course, students will be able to: Describe the new features of SQL Server 2008. Manage SQL Server 2008.
Optimize SQL Server 2008. Secure a SQL Server 2008 database. Develop databases by using SQL Server 2008.
Create and maintain highly available SQL Server 2008 databases. Create and use a SQL Server 2008 data warehouse.
Use SQL Server 2008 Reporting Services. Use SQL Server 2008 Analysis Services.
Prerequisites
Before attending this course, students must have experience with developing or administering databases in SQL Server 2005.
Key Data
Product #:
Course #: 6158C
Number of Days: 3 Format: Instructor-Led Certification Exams: None This course syllabus should be used to determine whether the course is appropriate for the students, based on their current skills and technical training needs.
Course content, prices, and availability are subject to change without notice.
Module 1: An Introduction to SQL Server 2008
This module describes the background to SQL Server 2008 and the range of business scenarios that the various editions of SQL Server 2008 support. It also describes how to prepare your existing environment for a new installation or upgrade to SQL Server 2008.
Lessons
The Evolution of SQL Server Preparing for SQL Server 2008
Lab: Reviewing the SQL Server Installation Center and SQL Server Books Online
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 their computers and environments for SQL Server 2008.
Module 2: SQL Server 2008 Manageability Enhancements
This module explains how tocreate a Central Management Server to centralize the management of the servers in an organization. It also explains how to create, apply, and test policies to simplify the management of SQL Server instances.Lessons
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 Central Management Servers. Use policy-based management.
Module 3: SQL Server 2008 Performance Enhancements
This module explains how tomanage workloads by using Resource Governor, how to monitor performance by using the Data Collector, and how to manage performance by using plan guides.Lessons
Managing Workloads by Using Resource Governor Monitoring Performance by Using the Data Collector Managing Performance by Using Plan Guides Lab: Optimizing SQL Server 2008
After completing this module, students will be able to: Manage SQL Server 2008 workloads.
Use the Data Collector. Use plan guides.
Module 4: SQL Server 2008 Security Enhancements
This module describes the new features that SQL Server 2008 provides for database encryption and SQL Server Audit.
Lessons
Encrypting Databases SQL Server Audit
Lab: Securing and Auditing a SQL Server 2008 Database Using Transparent Data Encryption
Implementing Auditing by Using Transact-SQL After completing this module, students will be able to: Encrypt databases.
Configure SQL Server Audit.
Module 5: SQL Server 2008 Database Development
Enhancements
This module explains about the new features of SQL Server 2008 that relate to database development.
Lessons
Enhancements to Transact-SQL and SQL Server Management Studio 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:
Use the new features in Transact-SQL and SQL Server Management Studio. Use the new data types.
Module 6: SQL Server 2008 Availability Enhancements
This module describes the availability enhancements that SQL Server 2008 provides, including several of the Always On Technologies and transactional peer-to-peer replication.Lessons
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 key Always On technologies. Implement peer-to-peer replication.
Module 7: SQL Server 2008 Data Warehousing Enhancements
This module explains the key enhancements to extract, load, and transform (ETL) operations that SQL Server 2008 provides. It also explains how to work with partitioned tables and how to optimize data storage in your SQL Server 2008 databases.Lessons
ETL Enhancements Partitioning Enhancements Optimizing 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: Use change data capture and the MERGE statement. Partition databases.
Module 8: SQL Server 2008 Reporting Services Enhancements
This module explains the enhancements that SQL Server 2008 provides to Reporting Services. It describes the changes in the architecture and management; Report Builder, Report Designer, and new report types; and changes to the processing and rendering systems.Lessons
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 architecture and management tools for Reporting Services. Author reports.
Describe the reporting processing and rendering processes.
Module 9: SQL Server 2008 Analysis Services Enhancements
This module describes the new and updated features in SQL Server 2008 for data analysis and data mining.Lessons
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 by Using the Microsoft Decision Trees Algorithm Implementing Data Mining by Using the Microsoft Time Series Algorithm Using the Data Mining Add-ins for Office 2007
After completing this module, students will be able to: Perform multidimensional analysis.
Perform data-mining tasks.
© 2008 Microsoft Corporation. All rights reserved.
