How to update SQL Server 2005 Skills to SQL Server 2008
eLearning |  6.12 GB

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.

Course Outline:

Module 1: Introduction to SQL Server 2008Lessons

*
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 EnhancementsLessons

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 EnhancementsLessons

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 EnhancementsLessons

*
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 EnhancementsLessons

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 EnhancementsLessons
*
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 EnhancementsLessons
*
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 EnhancementsLessons
*
Reporting Services Architecture and Management
*
*
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 EnhancementsLessons

*
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.


Authoring Reports