SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration

Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

Huntsville, Alabama

Montgomery / Birmingham, Alabama

Anchorage, Alaska

Calgary, Alberta

Phoenix, 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

Kingston, Jamaica

Wichita, Kansas

Paducah / Lexington / Louisville, Kentucky

Baton Rouge, Louisiana

Valletta, Malta

Hagerstown & Frederick, Maryland

Greenbelt / Silver Spring / Baltimore, Maryland

Boston / Cambridge, Massachusetts

Hartford, Connecticut / Springfield, Massachusetts

Taunton, Massachusetts / Providence, Rhode Island

Ann Arbor / Farmington Hills / Detroit, Michigan

Grand Rapids, Michigan

Lansing, Michigan

Saginaw / Flint / Bay City / Midland, Michigan

Saint Paul / Minneapolis, Minnesota

Jackson, Mississippi

Gulfport / Biloxi, Mississippi

St. Louis, Missouri

Whiteman Air Force Base / Kansas City, Missouri

Lincoln / Omaha, Nebraska

Reno and Las Vegas, Nevada

Santa Fe / Albuquerque, New Mexico

Newark, New Jersey

Princeton, New Jersey & Philadelphia, Pennsylvania

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

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

Course Number: 650
Duration: 5 days
view class outline

Looking for SQL Server 2005 Administration training?

Microsoft SQL Server 2000 Administration Training Overview

Accelebrate's Introduction to SQL Server 2000 training teaches attendees the skills they need to successfully build, administer, and query Microsoft SQL Server 2000 databases.

Accelebrate also offers an Advanced Microsoft SQL Server 2000 training class.

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.

Microsoft SQL Server 2000 Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

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

Microsoft SQL Server 2000 Training Materials

All students will receive:

More than 600 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)

Microsoft SQL Server 2000 Training Objectives

All attendees will learn to:

Use the programming environment in the Query Analyzer and learn the Transact-SQL language.
Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each.
Design and implement reliable backup and maintenance plans.
Understand the SQL Server security model; and create logins, users and permissions to protect your data.
Configure and tune SQL Server, and monitor database activity

Microsoft SQL Server 2000 Training Outline (happily customized upon request)

SQL Server Tour

SQL Server Editions
Graphical Tools
Exploring the Enterprise Manager
Working with SQL Server Books Online

Installing SQL Server

Multiple Instances
Installing an Instance of SQL Server
Configuring the Server

Designing and Creating a Database

Relational Database Design Principles
Implementing the Design

Basic Querying

Introduction to the Query Analyzer
Retrieving Data
Joining Tables

Action Queries

Modifying Data
Inserting Data
Updating Data
Deleting Data

Using the Query Analyzer

Query Analyzer Features
The File Menu Items
The Edit Menu
Query Menu Items
Tools Menu Items
Window Menu Items
Help Menu Items
Programming With Transact-SQL
Overview of Transact-SQL
Using Built-In Functions

Programming With Transact-SQL

Control of Flow
Error Handling

Transaction Processing

Transactions
Working with Locks
Monitoring Processes and Locks
Transaction Isolation
Blocking and Deadlocks

Creating Views

What is a View?
Creating Views
Updating Views

Backups and Maintenance

Creating a Backup Strategy
Implementing Backups
Restoring from a Backup
The Database Maintenance Plan Wizard

Stored Procedures and Triggers

Building Stored Procedures
Building Triggers
Using INSTEAD OF Triggers
User-Defined Functions
User-Defined Functions in SQL Server 2000
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Functions, Views, and Stored Procedures

Advanced Queries and Linked Servers

Dynamic SQL
Transact-SQL Cursors
Handling Large Data Sets
Distributed Queries

Security

Security Overview
Authentication
Understanding Roles
Assigning Permissions
Application Roles

Monitoring, Tuning, and Configuration

Evaluating Performance
Monitoring with SQL Server Profiler
Tuning Queries
Working with Indexes
Indexed Views
Using the Index Tuning Wizard
Data Caching
The System Monitor

Using System Objects

Exploring System Objects
DBCC

Automating Administration with SQL Agent

Configuring SQL Server Agent
Operators
Jobs
Alerts
Create an Alert

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
Adobe Training

PHP Training

XML Training

Perl Training

“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-2006 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.

Complimentary SQL Server Training Seminar