SQL Server 7.0 Developing SQL Client/Server Part II

This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server structure and to use OLE DB ActiveX ODBCDirect Microsoft English Query Query Analyzer and to create and evaluate queries. In a corporate setting the primary factors in implementing a client/server application are the client/server architecture the client-side means for manipulating data client-side design and optimization techniques and means of accessing the data. The special features that distinguishes SQL Server 7.0 from version 6.5 are highlighted including query improvements such as support for heterogeneous queries and a new query product that allows users to submit queries in English. This course is written to SQL Server 7.0. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 5 hours Training Presented in: English

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:

Topics 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

• SQL Server 7.0 Developing SQL Client/Server Part I