|
|
|
 |
M2073Programming a Microsoft? SQL Server 2000 Database
This course allows students to gain the skills required for programming solutions on usage of Microsoft SQL Server 2000
Program of course:
- Browse SQL Server 2000
- the Browse of programming for SQL Server 2000
- Creation of databases and handle of them
- Support of data integrity
- Planning of indexes of tables
- Creation of indexes and handle of them
- Creation of sorts
- Creation of stored procedures
- Creation of own functions
- Creation of triggers
- Programming in the environment from several северов
- Optimization of inquiries
- Analyses of inquiries
- Handle of transactions and lockings
Necessary preparation:
Training on courses M2151, M2152 and M2071 or an equivalent operational experience with the operating system of Windows 2000 and knowledge of bases of syntax Transact SQL. Acquaintance to duties of the manager of databases.
This course will help you to prepare for the next tests:
070-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Given cource inserted in next comlex programs:
SQL2000 The complex program of preparation of DB Microsoft SQL Server 2000 managers
Education coast on cource - USD 400
Cource duration (days) - 5
|
|
