SQL Server 2000 Database Design

4 days

Overview

This course teaches you how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows 2000 Server environment.

Prerequisites

Windows 2000 Installation and Administration, or equivalent knowledge. You should also know the basics of querying a SQL server by using the SELECT, INSERT, and UPDATE SQL statements.

Overview of SQL Server

Exploring the Components of SQL Server
SQL Server Database Structure
Understanding the SQL Server Architecture
Identifying SQL Server Management Tasks

Exploring Transact-SQL

Working with Transact-SQL
Transact-SQL Statements
Programming in Transact-SQL

Designing and Implementing Databases

Identifying Database Design Issues
Creating Databases
Managing Databases

Creating and Managing Tables

Design and Create Tables
Maintaining Tables

Designing and Implementing Data Integrity

Understanding Data Integrity
Implementing Constraints

Implementing Indexes

Designing Indexing
Implementing Indexes
Maintaining Indexes

Joining Tables

Querying Multiple Tables
Implementing Advanced Table Joins

Designing Advanced Queries

Designing Subqueries
Changing Data Through Queries

Designing Views

Creating and Managing Views

Creating Stored Procedures

Designing Stored Procedures
Creating Stored Procedures
Using Parameters in Stored Procedures
Managing Stored Procedures

Using Functions

Working with Aggregate Functions
Designing and Creating User-defined Functions

Creating Triggers

Understanding Transactions and Locks

Designing and Implementing Transactions
Managing Locks

Implementing Distributed Queries

Creating and Managing Distributed Queries

Optimizing Queries

Exploring the Query Optimizer
Using Indexes to Optimize Queries

Analyzing Queries

Analyzing the Performance of Queries