UMBC Training Centers logo

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

 

Course Description | Outline | SQL Server Training | IT Training

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.