Course: MS2073 Programming a Microsoft SQL Server 2000 Database

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

Delegates should have experience using Microsoft Windows 2000, knowledge of Transact-SQL, which can be gained through course 2071, Querying Microsoft SQL Server 2000 with Transact-SQL and an understanding of relational database concepts.

For students who do not meet this prerequisite, the following courses provide students with the necessary knowledge and skills:

Course 2151, Microsoft Windows 2000 Network and Operating System Essentials
Course 2152, Implementing Microsoft Windows 2000 Professional and Server

Delegates will learn how to:

Create and maintain indexes
Create, use, and maintain data views
Implement data integrity by using the IDENTITY column property constraints, defaults, rules, and unique identifiers
Plan for the use of indexes
Design a SQL Server enterprise application architecture
Create and manage databases and their related components
Implement user defined functions
Design, Create and use Stored Procedures
Create and implement Triggers
Use Distributed queries and transactions across multiple servers
Analyse and optimise query performance
Manage transactions and locks

Module 1: SQL Server Overview

Module 2: Overview of Programming SQL Server

Module 3: Creating and Managing Databases

Module 4: Creating Data Types and Tables

Module 5: Implementing Data Integrity

Module 6: Planning Indexes

Module 7: Creating and Maintaining Indexes

Module 8: Implementing Views

Module 9: Implementing Stored Procedures

Module 10: Implementing User-defined Functions

Module 11: Implementing Triggers

Module 12: Programming Across Multiple Servers

Module 13: Optimizing Query Performance

Module 14: Analyzing Queries

Module 15: Managing Transactions and Locks