- GS-35F-0556S
- Toll Free 877.932.8228
Very pleased with the attention to details. Webucator made sure the training was exactly what we wan...
More Testimonials »
MOC 6158 - Updating Your SQL Server 2005 Skills to SQL Server 2008
Delivery Options
- Live eLearning (3 days): $1,425.00 (Register)
- Customized Onsite Training (3 days): Request a Proposal
| Class Date and Time |
Price
|
Register |
|---|---|---|
| Mar 24 - 26, 2010 10:00 AM - 6:00 PM ET | $1,425.00 or 3 vouchers | Register |
| Apr 12 - 14, 2010 10:00 AM - 6:00 PM ET | $1,425.00 or 3 vouchers | Register |
| May 17 - 19, 2010 10:00 AM - 6:00 PM ET | $1,425.00 or 3 vouchers | Register |
| Jun 14 - 16, 2010 10:00 AM - 6:00 PM ET | $1,425.00 or 3 vouchers | Register |
Class Description
Class Overview
This SQL Server training class provides experienced SQL Server 2005 developers and database administrators the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
Class Goals
- Learn to describe the new features of SQL Server 2008.
- Learn to manage SQL Server 2008.
- Learn to optimize SQL Server 2008.
- Learn to secure a SQL Server 2008 Database.
- Learn to develop databases with SQL Server 2008.
- Learn to create and maintain highly available SQL Server 2008 databases.
- Learn to create and use a SQL Server 2008 data warehouse.
- Learn to use SQL Server 2008 Reporting Services.
- Learn to use SQL Server 2008 Analysis Services.
Class Outline
- Introduction to SQL Server 2008
- The Evolution of SQL Server
- Preparing for SQL Server 2008
- Lab: Exploring SQL Server Books Online
- SQL Server 2008 Manageability Enhancements
- Configuration Servers
- Policy-Based Management
- Lab: Managing SQL Server 2008
- SQL Server 2008 Performance Enhancements
- Managing Workloads with Resource Governor
- Monitoring Performance with the Data Collector
- Managing Performance with Plan Freezing
- Lab: Optimizing SQL Server 2008
- SQL Server 2008 Security Enhancements
- Encrypting Databases
- Auditing All Actions
- Lab: Securing a SQL Server 2008 Database
- SQL Server 2008 Database Development Enhancements
- Developer Tool Enhancements
- Data Type Enhancements
- Working with Spatial Data
- Lab: Developing Databases with SQL Server 2008
- SQL Server 2008 Availability Enhancements
- Always On Technologies
- Transactional Peer-to-Peer Replication
- Lab: Maintaining High Availability
- SQL Server 2008 Data Warehousing Enhancements
- ETL Enhancements
- Using Partitioned Tables
- Optimizing Data Storage
- Lab: Data Warehousing with SQL Server 2008
- SQL Server 2008 Reporting Services Enhancements
- Reporting Services Architecture and Management
- Authoring Reports
- Report Processing and Rendering
- Lab: Using SQL Server 2008 Reporting Services
- SQL Server 2008 Analysis Services Enhancements
- Multidimensional Analysis with SQL Server Analysis Services
- Data Mining with SQL Server Analysis Services
- Lab: Using SQL Server 2008 Analysis Services
Class Materials
All students receive a course manual or book and all the class examples.
Students in private onsite classes will also receive:
Class Prerequisites
Experience in the following areas is required:
- Developing or administering SQL Server 2005 databases
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
Live eLearning
Like a class you would go to, but you don't have to go anywhere. More...
Customized Onsite Training
The trainer comes to you and delivers a class customized for your team. More...
Self-Paced eLearning
Our least expensive option. You proceed through the course entirely at your own pace. More...
Reference Library
Partner Programs
Courseware
Microsoft Partner
