Updating Your SQL 2005 Skills to SQL Server 2008
[ Course No. MS6158 - 3 Days ]

• COURSE OVERVIEW

This three-day instructor-led course provides students with the knowledge and skills to update their skills in Microsoft SQL Server 2005 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.

• OBJECTIVES

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.

• COURSE OUTLINE

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 Enhancements

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 a Central Management server.
• Create and use policies.

Module 3: SQL Server 2008 Performance Enhancements

Lessons

• 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 Enhancements

Lessons

• 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 Enhancements

Lessons

• 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 Enhancements

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 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: 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 Enhancements

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