Programming a Microsoft SQL Server 2000 Database (MOC2073) (Programmeren)

(geplaatst op 10-03-2010)

Omschrijving:
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.

Leeftijd en niveau:
alle leeftijden
beginner
gevorderde

Onderwijsvorm:
1-op-1 privιlessen
groepslessen

Prijsinformatie:
€2345,-

Lestijden:
Lestijden (ook) op aanvraag

Locatie:
Al onze cursussen zijn overal in Nederland te volgen!

Docent:
AKG Opleidingen
088-3962691
http://www.akgopleidingen.nl/

Delen |