2073 - Programming a Microsoft SQL Server 2000 Database
About this Course
Elements of this syllabus are subject to change.
This five-day course provides students with the technical skills required to program a database by using Microsoft SQL Server 2000.
Audience Profile
This course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.
At Course Completion
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.