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 CS3 Training
◊ PRIVATE SQL SERVER TRAINING


Need a private class for your team delivered at your site or a location near you?
For private groups of three or more, Webucator offers completely customizable and cost-effective SQL Server classes delivered at your offices or a location near you.

To have someone contact you about these classes, please fill out the form below.

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

Advanced Microsoft SQL Server 2000 Training (3 days)

This SQL Server class is delivered for private groups onsite at your offices or a location of your choice. It can also be delivered via the Internet for geographically distributed staff.

Click here for our public SQL Server classes

Advanced Microsoft SQL Server 2000 Training Overview

This advanced SQL Server training course teaches students how to use Data Transformation Services, SQL Server Replication, SQL Server's Web publishing and XML features, and SQL Server's Analysis Services .

Advanced Microsoft SQL Server 2000 Training Course Goals

  • Learn to use Data Transformation Services (DTS) to import and export data
  • Learn to support distributed users by implementing SQL Server Replication
  • Learn to publish data to the Web and take advantage of SQL Server 2000's rich support for Extensible Markup Language (XML)
  • Learn to use Analysis Services to create online analytical processing (OLAP) solutions and to mine your data for hidden patterns

Advanced Microsoft SQL Server 2000 Training Course Prerequisites

Experience in the following areas is required:

  • Creating and Maintaining SQL Server Databases
  • Transact-SQL Programming

Advanced Microsoft SQL Server 2000 Training Course Outline

  1. Using System Objects
    1. Exploring System Objects
    2. DBCC
  2. Automating Administration with SQL Agent
    1. Configuring SQL Server Agent
    2. Operators
    3. Jobs
    4. Alerts
    5. Create an Alert
  3. Data Transformation Services (DTS)
    1. Introduction
    2. The DTS Import/Export Wizard
    3. DTS Packages
    4. Controlling DTS Workflow
  4. Replication
    1. Introduction to Replication
    2. Implementing Replication
  5. Publish SQL Server Data to the Web
    1. Publishing Data to the Web
    2. The Web Assistant Wizard
    3. The SQL Server Web Stored Procedures
    4. Scheduling Web Jobs
  6. XML Features
    1. XML Fundamentals
    2. Generating XML from SQL Queries with FOR XML
    3. Using FOR XML Explicit
    4. Setting Up IIS for SQL Server
    5. Accessing SQL Server Using a URL
    6. Creating XML Views with Annotated Schemas
    7. Using Xpath to Retrieve SQL Server Data Directly
    8. Using OpenXML to Work with XML Documents in Transact-SQL
    9. Using Updategrams
  7. Full Text Search
    1. What is Full-Text Search?
    2. Configuring Full-Text Search
    3. Writing Full-Text Querries
    4. Using Full-Text Search with Documented Stored in SQL Server
  8. Analysis Services
    1. Understanding Analysis Services
    2. Building a Simple Cube
    3. Browsing Data from a Cube
    4. Exploring MDX
    5. Data Mining
  9. English Query
    1. Overview of English Query
    2. Before You Start - Preparing Your Database
    3. Creating and English Query Application
    4. Deploying an English Query Application

Advanced Microsoft SQL Server 2000 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 2000 Training Technical Requirements

  1. Microsoft SQL Server 2000
  2. Query Analyzer

Class Files for Advanced Microsoft SQL Server 2000 Training

The class files for this course are included on a DVD that is shipped with the manual.

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 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