Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

SQL Server 7.0 Developing SQL Client/Server Part II

Click here for more information or to take this course 		Serebra Learning Corporation
  home  : Computer  : Analysis and Design  : Client / Server
Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

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

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:5 hours
Training Presented in:English
Related Keywords:  server 

Training Program Details

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 Query

    • 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

    Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada

    About Serebra Learning Corporation - Training Provider

    Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
    More SQL Server 7.0 Developing SQL Client/Server Training from Serebra Learning Corporation
    Click here for more information or to take this course
    Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links
    		Training-Classes.com by Skillbox® 07/18/08
    Copyright 1998-2008 skillbox, inc. All rights reserved    		 Connecting people who want to learn with people who love to teach
     Are you a Sql server 7.0 developing sql client training provider?
    You could be on this page today - for FREE!
    This page was last updated on sb5 - 07/18/08 at 04:19:58 - 04:48:45