Programming a Microsoft SQL Server 2000 Database

Course Details:

  • Days: 5
  • Course Code: MS2073
  • Booking: Please ring 08450 50 45 05



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


Course 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



Recommended follow on course

For more information or advice please complete the form below.

Name*  
Phone*  
Mobile  
Email*  
Receive info on...   MCSE
MCDBA
MCAD
MCP
MCSA
MCDST
MCSD
Other
Status   Company
Individual
Where did you hear about us?*  
Comments  
Address  

* These fields are required

 
e-Learning           Classroom       Online Demo         Benefits          Contact us          Sitemap
  

Microsoft Training © 2005.

Please Note: We are not Microsoft. We are a training company that provides training materials and classes to gain your Microsoft certification.