SQL Server training     
Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Sweden     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   020 795 420   +1 678 648 3113  
Accelebrate delivers SQL Server, SharePoint, ASP.NET, SQL Server, and Java training courses   Home   Contact Us
SQL Server 2005 Training  SQL Server 2008 Training SSAS Training SSIS Training SSRS Training
T-SQL Training SQL Server 2000 Training  Live Online Training

SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration
SQL Server Training: Introduction to Microsoft SQL Server 2008 for Developers and Query Writers
SQL Server Training: Introduction to Microsoft SQL Server 2005 for Developers and Query Writers
SQL Server Administration Training: Introduction to Microsoft SQL Server 2005 for Administrators
SQL Server 2005: Advanced Topics
SSRS Training: Introduction to SQL Server 2005 Reporting Services
SSAS Training: Introduction to SQL Server 2005 Analysis Services
SSIS Training: Introduction to SQL Server 2005 Integration Services
Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writing
T-SQL Training: T-SQL for SQL Server 2005 for Developers
Live Online Training



Please contact us
for GSA pricing
and CMAS pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T

CMAS Approved Contractor Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
3-09-70-2645A



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Flint, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Trenton, New Jersey
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Stockholm, Sweden
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

SQL Server 2000 Training: Advanced Microsoft SQL Server 2000
Print This Outline
E-mail This Outline
Get A Quote
Course Number: 651
Duration: 3 days
view class outline

Looking for SQL Server 2005 Administration training?

Advanced Microsoft SQL Server 2000 Training Overview

Accelebrate's Advanced SQL Server 2000 class teaches attendees how to automate administration, import/export data using DTS, perform database replication, work with XML, use Analysis Services, configure and use English Query, perform full text searches, and more.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/sql.htm.

Advanced Microsoft SQL Server 2000 Prerequisites

Prior experience with SQL Server 2000 is required. If your group does not have previous experience, we recommend our Introduction to Microsoft SQL Server 2000 Administration class.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

Advanced Microsoft SQL Server 2000 Training Materials

All students will receive:

  • More than 300 pages of fully-illustrated courseware
  • A copy of SQL Server 2000 Unleashed

Software Needed on Each Student PC

  • Windows 2000, XP, or Windows 2003 Server with latest service pack(s) installed
  • SQL Server 2000 SP4 or later SP (full installation)

Advanced Microsoft SQL Server 2000 Training Objectives

All attendees will learn to:

  • Automate administration with the SQL Agent
  • Import and export data using DTS
  • Set up replication
  • Publish SQL Server data to the web
  • Write queries for processing XML
  • Perform full text searches
  • Master the fundamentals of analysis services
  • Discover how to use English Query

Advanced Microsoft SQL Server 2000 Training Outline

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

Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
 
Request Information for Group Training at Your Site   Request Information for Group Training at Your Site
 
Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training  Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK
About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training