Updating Your SQL Server® 2005 Skills to SQL Server 2008 (6158C)

Updating Your SQL Server® 2005 Skills to SQL Server 2008 (6158C)

Overview

Duration: 3 days
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.
Module 1: Introduction to SQL Server 2008Lessons
  • The Evolution of SQL Server
  • Preparing for SQL Server 2008
Lab : Exploring 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
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
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
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
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
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
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
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
After completing this module, students will be able to:
  • Implement multidimensional analysis.
  • Implement data mining.
This course is not associated with any Certification.

Before attending this course, students must have experience developing or administering SQL Server 2005 databases.
Course ID:
6158C


Show Schedule for: