Back to Search Results

Training Course Summary:

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

Pre-Requisites:

Before attending this course, students must have:
• Experience using the Microsoft Windows® 2000 operating system to:
• Connect clients running Windows 2000 to networks and the Internet.
• Configure the Windows 2000 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 the NTFS file system.
• Implement Windows 2000 security.
• Optimize performance in Windows 2000.
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
• 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).
For students who do not meet this prerequisite, the following course provides students with the necessary knowledge and skills:
• Course 1609, Designing Data Services and Data Models
• Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).
For students who do not meet this prerequisite, the following course provides students with the necessary knowledge and skills:
• Course 2071, Querying Microsoft SQL Server 2000 with Transact-SQL
• Familiarity with the role of the database administrator.

Training Course Overview/Content:

At the end of the course, students will be able to describe the elements of SQL Server 2000; design a SQL Server enterprise application architecture; 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; implement user-defined functions; design, create, and use stored procedures; create and implement triggers; program across multiple servers by using distributed queries, distributed transactions, and partitioned views; optimize query performance; analyze queries; and manage transactions and locks to ensure data concurrency and recoverability.

Qualifications:

This course will help the student prepare for the following Microsoft Certified Professional exam:
• Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition