CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2073 - Programming a MS SQL Server 2000 Database

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This course provides students with the technical skills required to program a database solution using Microsoft SQL Server 2000.

Click here for a printer-friendly version of this page

Prerequisites

Course MS2151, Microsoft Windows 2000 Network and Operating System Essentials and course MS2152, Implementing Microsoft Windows 2000 Professional and Server or equivalent knowledge; Course MS2071, Querying Microsoft SQL Server 2000 with Transact-SQL or equivalent knowledge

Detailed Class Syllabus

SQL Server Overview

What is SQL Server?

SQL Server Integration

SQL Server Databases

SQL Server Security

Working with SQL Server

Overview of Programming SQL Server

Designing Enterprise Application Architecture

SQL Server Programming Tools

The Transact-SQL Programming Language

Elements of Transact-SQL

Additional Language Elements

Ways to Execute Transact-SQL Statement

Creating and Managing Databases

Creating Databases

Creating Filegroups

Managing Databases

Introduction to Data Structures

Creating Data Types and Tables

Creating Data Types

Creating Tables

Generating Column Values

Generating Scripts

Implementing Data Integrity

Types of Data Integrity

Enforcing Data Integrity

Defining Constraints

Types of Constraints

Disabling Constraints

Using Defaults and Rules

Deciding Which Enforcement Method to Use

Planning Indexes

Introduction to Indexes

Index Architecture

How SQL Server Retrieves Stored Data

How SQL Server Maintains Index and Heap Structures

Deciding Which Columns to Index

Creating and Maintaining Indexes

Creating Indexes

Creating Index Options

Maintaining Indexes

Introduction to Statistics

Querying the sysindexes Table

Setting Up Indexes Using the Index Tuning Wizard

Performance Considerations

Implementing Views

Introduction to Views

Advantages of Views

Defining Views

Modifying Data through Views

Optimizing Performance by Using Views

Performance Considerations

Implementing Stored Procedures

Introduction to Stored Procedures

Creating, Executing, Modifying, and Dropping Stored Procedures

Using Parameters in Stored Procedures

Executing Extended Stored Procedures

Handling Error Messages

Performance Considerations

Implementing User-defined Functions

What Is a User-defined Function?

Defining User-defined Functions

Examples of User-defined Functions

Implementing Triggers

Introduction to Triggers

Defining Triggers

How Triggers Work

Examples of Triggers

Perfomance Considerations

Programming Across Multiple Servers

Introduction to Distributed Queries

Executing an Ad Hoc Query on a Remote Data Source

Setting Up a Linked Server Environment

Executing a Query on a Linked Server

Managing Distributed Transactions

Modifying Data on a Linked Server

Using Partioned Views

Optimizing Query Performance

Introduction to the Query Optimizer

Obtaining Execution Plan Information

Using an Index to Cover a Query

Indexing Strategies

Overriding the Query Optimizer

Analyzing Queries

Queries That Use the AND Operator

Queries That Use the OR Operator

Queries That Use Join Operations

Managing Transactions and Locks

Introduction to Transactions and Locks

Managing Transactions

SQL Server Locking

Managing Locks