Audience
Students taking this course should be familiar with basic database concepts and have some experience with databases and client/server operations. Experience using SQL-based queries and an object-oriented programming language is helpful in understanding the functionality of SQL Server 7.0.
Prerequisites
Students understand computer system fundamentals and have user knowledge of Windows 95 Microsoft Office Internet browsing and HTML and e-mail systems. Students are expected to have successfully completed SQL Server 7.0: Introduction SQL Server 7.0: Installing and Upgrading SQL Server 7.0: Management Parts I II and III SQL Server 7.0: Database Administration Part I and Part II SQL Server 7.0: Data Warehousing Using SQL Part I and Part II and SQL Server 7.0: Developing SQL Client/Server Part I courses.
Objective
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 QueryTopics Include
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
Duration
5 Hours
Minimum Requirements
IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.
Media
CDROM
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada