Upon completion of this course, the student will be able to: Identify the use of Embedded SQL, Open Data Services, and DB Library. Illustrate the different interfaces available with SQL Server. Describe how to optimize a query process with query tools. Explain the Query Analyzer and the Microsoft English Query.
Unit 1: Interfaces
- Overview of Interfaces
- SQL-DMO
- DTS
- SQL Namespace
- Other Programming Interfaces
Unit 2: Query Enhancements
- Enhancements to Query Tools and Processes
- Enhancements from Version 6.5
Unit 3: Query Tools
- Query Analyzer
- Microsoft English Query