Programming a Microsoft SQL Server 2000 Database

Aims and Objectives
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.

Target Audiences
It is intended for Microsoft SQL Server database administrators, implementers, system engineers and developers.

Prerequisites
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.

Course Content
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: OPTIMISING QUERY PERFORMANCE
Module 14: ANALYSING QUERIES
Module 15: MANAGING TRANSACTIONS AND LOCKS