6158C Updating Your SQL Server 2005 Skills to SQL
Server 2008
|
|
Course MOC |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
3 DAYS |
English |
Yes |
No |
No |
No |
Pré-requisitos:
Before attending this course, students must have experience developing or
administering SQL Server 2005 databases.
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