Home / Courses / Microsoft Technology / 6158C: Updating Your SQL Server 2005 Skills to SQL Server 2008

SQL

6158C: Updating Your SQL Server 2005 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
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
•Configuration Servers
•Policy-Based Management
Lab : Managing SQL Server 2008
•Creating a Configuration Server
•Creating and Applying a Policy
After completing this module, students will be able to:
•Create and use a configuration server.
•Create and use policies.
 

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
After completing this module, students will be able to:
•Manage workloads with Resource Governor.
•Monitor performance with the Data Collector.
•Manage performance with Plan Freezing.
 

Module 4: SQL Server 2008 Security Enhancements
Lessons
•Encrypting Databases
•Auditing All Actions
Lab : Securing a SQL Server 2008 Database
•Using Transparent Data Encryption
After completing this module, students will be able to:
•Encrypt databases.
•Audit all actions.
 

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
After completing this module, students will be able to:
•Describe the 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 with Report Designer
•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 Analysis Services
•Data Mining with SQL Server 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.

Course Registration

 

3 day
$1,495.00

 

Course Outline

 

Request