Home > Courses > 2073 Programming a Microsoft SQL Server 2000 Database
Upcoming Classes| Start Date | Time | Duration | Location | Cost | Purchase |
|---|
Don't see dates for this class? Please contact us or request that we add it to our schedule. Methods of DeliveryThis course can be delivered via the following learning methods:OverviewThis course provides students with the technical skills required to program a database solution by using Microsoft SQLServer 2000.At Course CompletionAfter 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.Pre-Requisites2274 Managing a Microsoft Windows Server 2003 Environment 2275 Maintaining a Microsoft Windows Server 2003 Environment. 2071A Querying Microsoft SQL Server 2000 with Transact-SQL
Previous Page New Search |