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
1. The Evolution of SQL Server
2. Preparing for SQL Server 2008
3. Lab: Exploring SQL Server Books Online
SQL Server 2008 Manageability Enhancements
1. Configuration Servers
2. Policy-Based Management
3. Lab: Managing SQL Server 2008
SQL Server 2008 Performance Enhancements
1. Managing Workloads with Resource Governor
2. Monitoring Performance with the Data Collector
3. Managing Performance with Plan Freezing
4. Lab: Optimizing SQL Server 2008
SQL Server 2008 Security Enhancements
1. Encrypting Databases
2. Auditing All Actions
3. Lab: Securing a SQL Server 2008 Database
SQL Server 2008 Database Development Enhancements
1. Developer Tool Enhancements
2. Data Type Enhancements
3. Working with Spatial Data
4. Lab: Developing Databases with SQL Server 2008
SQL Server 2008 Availability Enhancements
1. Always On Technologies
2. Transactional Peer-to-Peer Replication
3. Lab: Maintaining High Availability
SQL Server 2008 Data Warehousing Enhancements
1. ETL Enhancements
2. Using Partitioned Tables
3. Optimizing Data Storage
4. Lab: Data Warehousing with SQL Server 2008
SQL Server 2008 Reporting Services Enhancements
1. Reporting Services Architecture and Management
2. Authoring Reports
3. Report Processing and Rendering
4. Lab: Using SQL Server 2008 Reporting Services
SQL Server 2008 Analysis Services Enhancements
1. Multidimensional Analysis with SQL Server Analysis Services
2. Data Mining with SQL Server Analysis Services
3. Lab: Using SQL Server 2008 Analysis Services

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

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.

Onsite and Instructor-led Online course technical requirements and setup instructions.
WebEx system requirements for Instructor-led Online delivery option.
Hosted eLearning course system requirements and frequently asked questions.

Quick Links

Courseware

Purchase Courseware

Client Success

Join The Team

Learn how you can become a Webucator Trainer
Career Opportunities

Locations

Where We've Trained
Some of the Cities in which Webucator has Trained:
1. Phoenix, AZ
2. Pittsburgh, PA
3. Portland, OR
4. Providence, RI
5. Raleigh, NC
6. Sacramento, CA
7. St. Louis, MO
8. San Diego, CA
9. San Francisco, CA
10. San Jose, CA
11. Santa Clara, CA
12. Seattle, WA
13. Sunnyvale, CA
14. Tallahassee, FL
15. Tempe, AZ
16. Toronto, ON
17. Tucson, AZ
18. Tulsa, OK
19. Virginia Beach, VA
20. Washington, DC
1. Fort Worth, TX
2. Hampton, VA
3. Hollywood, FL
4. Houston, TX
5. Huntsville, AL
6. Indianapolis, IN
7. Jacksonville, FL
8. Las Vegas, NV
9. Lexington, KY
10. Los Angeles, CA
11. Louisville, KY
12. Madison, WI
13. Memphis, TN
14. Milwaukee, WI
15. Nashville, TN
16. New York, NY
17. Oklahoma City, OK
18. Omaha, NE
19. Ottawa, ON
20. Philadelphia, PA
1. Amarillo, TX
2. Atlanta, GA
3. Aurora, IL
4. Austin, TX
5. Baltimore, MD
6. Beaumont, TX
7. Boston, MA
8. Buffalo, NY
9. Calgary, AB
10. Cary, NC
11. Chandler, AZ
12. Chicago, IL
13. Cincinnati, OH
14. Cleveland, OH
15. Colorado Springs, CO
16. Columbus, OH
17. Dallas, TX
18. Dayton, OH
19. Denver, CO
20. Detroit, MI
We have trainers all over North America.
1. Indianapolis, IN
2. Boston, MA
3. Silver Spring, MD
4. Portland, ME
5. Detroit, MI
6. Minneapolis, MN
7. Kansas City, MO
8. St. Louis, MO
9. Jackson, MS
10. Charlotte, NC
11. Nashua, NH
12. Atlantic City, NJ
13. Newark, NJ
14. Jersey City, NJ,
15. Reno, NV
16. Philadelphia, PA
17. Calgary, Canada
18. Toronto, Canada
1. Phoenix, AZ
2. Los Angeles, CA
3. Oakland, CA
4. San Diego, CA
5. San Francisco, CA
6. San Jose, CA
7. Santa Clara, CA
8. Sacramento, CA
9. Boulder, CO
10. Denver, CO
11. Hartford, CT
12. Fort Lauderdale, FL
13. Fort Myers, FL
14. Orlando, FL
15. Tallahassee, FL
16. Atlanta, GA
17. Boise, ID
18. Chicago, IL

Training Options

Microsoft Partner

Watch 3-minute Demo Video
of Live Online Training:

Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Recent Blog Articles

SQL Server 2008 Certification Training Overview

Posted on Jun 07, 2011 by Bob Clary

We’ve recently developed new resources to help clients achieve their Microsoft certification goals. We now offer a directory of Microsoft certification ...

SQL Server 2008 Reporting Services

Posted on May 04, 2011 by akenien

This SQL Server Reporting Services 2008 webinar is a quick overview of the the new layout and features of SQL Server Reporting Services 2008. SQL Server ...

Data Modeling in MySQL Workbench

Posted on May 04, 2011 by akenien

This MySQL webinar recording includes concepts from our MySQL training classes to teach you how to use MySQL Workbench for data modeling. The webinar will ...

Writing an Oracle PL/SQL Program

Posted on May 04, 2011 by akenien

This recorded webinar includes concepts from our Oracle training classes to help you write your first Oracle PL/SQL program! Writing an Oracle PL/SQL Program ...

Importing Data Using Oracle SQL Developer

Posted on Feb 27, 2011 by Beth Anglo

There are many methods one can use to import data from operating system files into Oracle tables. These methods include using any of the following: the ...

Compare Webucator to leading Competitors

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.