Programming a Microsoft SQL Server 2000 Database

Course Code: MS2073
Duration: 5 Days

Bookmark and Share

Overview

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

Prerequisites

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

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

Outline

  • 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

Leads to examination

  • 70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Related Certifications

This course forms part of the following certification track(s):