Advanced Microsoft SQL Server 2005 Training (2 days)

Advanced Microsoft SQL Server 2005 Training Overview

This SQL Server 2005 training course teaches advanced uses of Microsoft SQL Server 2005.

Advanced Microsoft SQL Server 2005 Training Course Goals

• Learn to design and implement reliable backup and maintenance plans.
• Learn the fundamentals of Reporting Services, Notification Services, and the Service Broker.
• Learn to configure and tune SQL Server 2005, and monitor database activity.

Advanced Microsoft SQL Server 2005 Training Course Outline

1. Replication
   1. Replication Models
   2. Setting up Replication
   3. Snapshot publishing
   4. Transaction publishing
   5. Merge publications
   6. Monitoring replication
   7. Heterogeneous replication
2. .NET inside of SQL Server
   1. Understanding .NET and the CLR
   2. Using CLR objects in SQL Server
   3. Using the Sql namespace
3. SMO and RMO Programming
   1. What is SMO?
   2. The SMO Object Model
   3. Sample SMO tasks
   4. Sample RMO tasks
4. Analysis Services
   1. Understanding Analysis Services
   2. Introducing BIDS
   3. Creating a Data Cube
   4. Exploring a Data Cube
5. SQL Server Integration Services
   1. SSIS Architecture
   2. SSIS Tasks
   3. SSIS in action
6. Notification Services
   1. The Notification Services Architecture
   2. Using Notification Services
7. Reporting Services
   1. The Reporting Services Architecture
   2. Building Reports
   3. Managing Reporting Services
8. Service Broker
   1. The Service Broker Architecture
   2. Using Service Broker

Advanced Microsoft SQL Server 2005 Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Advanced Microsoft SQL Server 2005 Training Technical Requirements

1. Microsoft SQL Server 2005 with SP2
   • Download - Full installation (including all services) required of developer or enterprise edition.
2. Microsoft SQL Server Sample Databases
   • Download - Once the sample database scripts have been extracted, double-click each of the two .sql files to open it in Microsoft SQL Server Management Studio Express and execute it using the toolbar button. This will install the sample database.
3. Visual C# 2005 Express Edition
   • Download - - Be sure to choose Visual C# 2005 Express Edition.

Class Files for Advanced Microsoft SQL Server 2005 Training

1. Download the class files.
2. After downloading the files, click here for further instructions.