SQL Server 2000 - Programming a Database

Duration: 35 hours

Description: Topics include: Creating and managing databases; creating data types and tables; implementing data integrity; planning, creating and maintaining indexes; implementing views, stored procedures, user-defined functions and triggers; programming across multiple servers; query performance; using graphical SHOWPLAN; managing transactions and locks. Prerequisite: Querying SQL Server 2000 with Transact-SQL or equivalent knowledge.

Objective: Students learn to program and implement a database solution using SQL Server 2000.

Course Content:

SQL Server Overview

Overview of Programming SQL Server

Creating and Managing Databases

Creating Data Types and Tables

Implementing Data Integrity

Planning Indexes

Determining the Indexes of a Table

Creating and Maintaining Indexes

Viewing Index Statistics

Implementing Views

Implementing Stored Procedures

Creating Stored Procedures

Implementing User-defined Functions

Implementing Triggers

Programming Across Multiple Servers

Using Distributed Data

Optimizing Query Performance

Analyzing Queries

AND and OR Operators

Use Different Join Strategies

Managing Transactions and Locks