1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe Training
◊ PUBLIC SQL SERVER TRAINING
Watch a 3-minute presentation
on our live instructor-led
online classes

How about taking a class directly from your home or office with a live instructor?
When you register for one of our instructor-led online SQL Server classes, we send you a computer headset, the courseware for class, and some other goodies. At the time of class, you simply put your headset on and log in to our web conferencing software. You can hear everything the instructor says, see the complete presentation, and ask questions at any time. Classes are small, generally 2-6 students, full of hands-on exercises, and are never cancelled due to low enrollment.

To have someone contact you about our instructor-led online classes, please fill out the form below. We will also email you a class schedule and pricing.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
* (Required)
(For Federal Government Pricing)

Advanced Microsoft SQL Server 2005 Training (3 days)

Classes for individuals are delivered via the Web by a Webucator instructor over a live web conference. For more information on how these classes are delivered click here or call us toll free at 877-932-8228.

Click here for our private onsite SQL Server classes

Date Range Price Register
April 1-3, 2009
(Start time: 10:00 AM ET)		 $1,295.00
Jun 29, 2009 - Jul 1, 2009
(Start time: 10:00 AM ET)		 $1,295.00
You may also register by calling 1-877-932-8228.

Advanced Microsoft SQL Server 2005 Training Course 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

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Advanced Microsoft SQL Server 2005 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2009 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA