|
|
|
 |
M2071Querying Microsoft? SQL Server 2000 with Transact SQL
This course acquaints students with the technical skills required for writing base inquiries Transact SQL for Microsoft SQL Server 2000
Program of course:
- Introduction in language Transact-SQL
- Usage of query language Transact-SQL
- the Data retrieval
- Classification and generalization of metrics
- Association of several tables
- Usage of subrequests
- Data modification
- Usage of full-text indexes
- Introduction in programming objects.
Necessary preparation:
Experience of usage of operating systems of the set of Microsoft Windows. Concept of main concepts of relational databases, including logical and physical design of a database; concepts of integrity of databases; creation of links between tables and columns; data storage in tables. Understanding of 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 160
Cource duration (days) - 2
|
|
