IT Technical Training Tutor led Programming microssoft SQL Server 2000 Database

By: Pitman Training Preston  17/11/2009
Keywords: microsoft, computer training, pitman training

 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.

Keywords: computer training, microsoft, pitman training