Updating Your SQL Server 2005 Skills to SQL Server 2008
Course Outline
Duration:
3 Day
Introduction: This three-day instructor-led course
provides students with the knowledge and skills to upgrade their SQL Server
2005 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 with 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.
|
Course Content:
Module 1: Introduction to
SQL Server 2008
Lessons
|
•
|
The Evolution of SQL
Server
|
|
•
|
Preparing for SQL Server
2008
|
Module 2: SQL Server 2008
Manageability Enhancements
Lessons
|
•
|
Configuration Servers
|
|
•
|
Policy-Based Management
|
Module 3: SQL Server 2008
Performance Enhancements
Lessons
|
•
|
Managing Workloads with
Resource Governor
|
|
•
|
Monitoring Performance
with the Data Collector
|
|
•
|
Managing Performance
with Plan Freezing
|
Module 4: SQL Server 2008
Security Enhancements
Lessons
|
•
|
Encrypting Databases
|
|
•
|
Auditing All Actions
|
Module 5: SQL Server 2008
Database Development Enhancements
Lessons
|
•
|
Developer Tool
Enhancements
|
|
•
|
Data Type Enhancements
|
|
•
|
Working with Spatial
Data
|
Module 6: SQL Server 2008
Availability Enhancements
Lessons
|
•
|
Always On Technologies
|
|
•
|
Transactional
Peer-to-Peer Replication
|
Module 7: SQL Server 2008
Data Warehousing Enhancements
Lessons
|
•
|
ETL Enhancements
|
|
•
|
Using Partitioned Tables
|
|
•
|
Optimizing Data Storage
|
Module 8: SQL Server 2008
Reporting Services Enhancements
Lessons
|
•
|
Reporting Services
Architecture and Management
|
|
•
|
Authoring Reports
|
|
•
|
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
|
