MS6158 - Updating Your SQL Server 2005 Skills to SQL Server 2008
| Categories |
Certification Training, Database Training |
| Duration |
3 days (21 hours) |
| Pre-requisites |
Before attending this course, students must have experience developing or administering SQL Server 2005 databases. |
|
|
|
| Courseware |
MS6158-MS (300 pages) |
| Price |
$1200 |
| Notes |
|
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008
This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008.
Module 1: Introduction to SQL Server 2008
Lessons
The Evolution of SQL Server
Preparing for SQL Server 2008
Lab : Exploring SQL Server Books Online
Reviewing the SQL Server Books Online Tutorials
Reviewing SQL Server Books Online
Module 2: SQL Server 2008 Manageability Enhancements
Lessons
Configuration Servers
Policy-Based Management
Lab : Managing SQL Server 2008
Creating a Configuration Server
Creating and Applying a Policy
Module 3: SQL Server 2008 Performance Enhancements
Lessons
Managing Workloads with Resource Governor
Monitoring Performance with the Data Collector
Managing Performance with Plan Freezing
Lab : Optimizing SQL Server 2008
Using Resource Governor
Using the Data Collector
Module 4: SQL Server 2008 Security Enhancements
Lessons
Encrypting Databases
Auditing All Actions
Lab : Securing a SQL Server 2008 Database
Using Transparent Data Encryption
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
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
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
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 with Report Designer
Managing Reporting Services
Module 9: SQL Server 2008 Analysis Services Enhancements
Lessons
Multidimensional Analysis with SQL Server Analysis Services
Data Mining with SQL Server Analysis Services
Lab : Using SQL Server 2008 Analysis Services
Implementing Multidimensional Analysis
Implementing Data Mining