Programming a Microsoft SQL Server 2000 Database (MOC2073)

This course provides students with the technical skills required to program a database by using Microsoft SQL Server 2000. 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.

Voor wie

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

Voorkennis
Before attending this course, students must have: • Experience using the Microsoft Windows Server 2003 operating system, or have attended Course 2274: Managing a Microsoft Windows Server 2003 Environment and Course 2275: Maintaining a Microsoft Windows Server 2003 Environment; • An understanding of basic relational database concepts as offered by Course 2071A, Querying Microsoft SQL Server 2000 with Transact-SQL; • Familiarity with the role of the database administrator.