MS2073 Programming a Microsoft SQL Server 2000 Database

This course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.

This five-day course provides students with the technical skills required to program a database by using Microsoft SQL Server 2000.

The student kit includes a comprehensive workbook and other necessary materials for this class.

After completing this course, students will be able to:

• Describe the elements of SQL Server 2000.
 
• Describe the conceptual basis of programming in Transact-SQL.
 
• Create and manage databases and their related components.
 
• Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers.
 
• Plan for the use of indexes.
 
• Create and maintain indexes.
 
• Create, use, and maintain data views.
 
• Design, create, and use stored procedures.
 
• Implement user-defined functions.
 
• Create and implement triggers.
 
• Program across multiple servers by using distributed queries, distributed transactions, and partitioned views.
 
• Optimize query performance.
 
• Analyze queries.
 
• Manage transactions and locks to ensure data concurrency and recoverability.
 

Before attending this course, students must have:

• Experience using the Microsoft Windows Server 2003 operating system to:

.Connect clients running Microsoft Windows-based operating systems to networks and the Internet

.Configure the Windows environment

.Create and manage user accounts

.Manage access to resources by using groups

.Configure and manage disks and partitions, including disk striping and mirroring

.Manage data by using NT file system (NTFS)

.Implement Windows server and client security

.Optimize performance in Windows operating systems

For students who do not meet these prerequisites, the following courses provide the necessary knowledge and skills:

.Course 2274: Managing a Microsoft Windows Server 2003 Environment.

.Course 2275: Maintaining a Microsoft Windows Server 2003 Environment.

• An understanding of basic relational database concepts, including:

.Logical and physical database design

.Data integrity concepts

.Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, many-to-many)

.How data is stored in tables (rows and columns).

• Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements)

For students who do not meet these prerequisites, the following course provides the necessary knowledge and skills:

.Course 2071A, Querying Microsoft SQL Server 2000 with Transact-SQL

• Familiarity with the role of the database administrator

Module 1: Overview of Programming SQL Server

Module 2: Creating and Managing Databases

Module 3: Creating Data Types and Tables

Module 4: Implementing Data Integrity

Module 5: Planning Indexes

Module 6: Creating and Maintaining Indexes

Module 7: Implementing Views

Module 8: Implementing Stored Procedures

Module 9: Implementing User-Defined Functions

Module 10: Implementing Triggers

Module 11: Programming Across Multiple Servers

Module 12: Optimizing Query Performance

Module 13: Performing Advance Query Analysis

Module 14: Managing Transactions and Locks

No Microsoft Certification exams are associated with this course currently.