Course MS6158B
Updating Your SQL 2005 Skills to SQL
Server 2008
Microsoft Official Learning Material
Duration
3 days
(Instructor-led)
Introduction
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
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.
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.