IT Technical Training Tutor led Programming microssoft SQL Server 2000 Database
This course is for Microsoft SQL Server database administrators and provides students with the technical skills required to program a database by using Microsoft SQL Server 2000. Aims and Objectives Create and maintain indexes. Create, use and maintain data views. Implement data integrity by using the IDENTITY column property constraints, defaults, rules and unique identifiers. Plan for the use of indexes. Design a SQL Server enterprise application architecture. Create and manage databases and their related components. Implement user defined functions. Design, create and use Stored Procedures. Create and implement Triggers. Use Distributed queries and transactions across multiple servers. Analyse and optimise query performance. Manage transactions and locks.