Custom Search
Home > Computer > Databases and SQL > Serebra Learning Corporation > SQL Server 7.0 Advanced Features > SQL Server 7.0 Advanced Features Part II
Provided by: Serebra Learning Corporation

SQL Server 7.0 Advanced Features Part II

MS SQL Server

 Serebra Learning Corporation
Training Provided by Serebra Learning Corporation

This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances Transact-SQL and ODS-based queries methods of managing SQL Server failover support distributed transaction fundamentals Office 2000 integration and Visual Studio integration. The student will learn to create heterogeneous distributed queries and fundamentals of managing the server arrays that require advanced query techniques. The course presents an overview of the Microsoft Visual Studio software and how it is used to create applications for SQL Server 7.0. This course is written to SQL Server 7.0. Related Exam: 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
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Duration:5 hours
Training Presented in:English
SQL Server 7.0 Advanced Features Part II

Audience

SQL Server 7.0 Advanced Features is designed for experienced information systems professionals who want to manage and develop powerful databases as well as developers who will create applications for SQL Server 7.0.

Prerequisites

Students taking this course should be familiar with basic database concepts and have some experience using 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 and its integration with other Microsoft development products. Completion of previous courses in the SQL Server 7.0 series is recommended. Completion of SQL Server 7.0:

Objective

Upon completion of this course the student will be able to:

  • Identify the points of integration between Microsoft Office 2000 and SQL Server 7.0 for database development
  • Configure SQL Mail to work with Outlook 2000
  • Define the methods used by Excel 2000 to access enterprise data stored in SQL Server 7.0 databses
  • Define DSS and OLAP and identify the methods used by Office 2000 to access data warehouses and data marts

    • Topics Include

    Unit 1: Office 2000 Integration

    • Office Server Extensions
    • SQL Mail and Microsoft Outlook 2000
    • Access 2000
    • Excel 2000
    • Decision Support Services

    Unit 2: Visual Studio Integration

    • SQL-DMO
    • DB-Library
    • Developing SQL Server Applications with DAO
    • Developing SQL Server Applications with ODBCDirect
    • Developing Database Applications with RDO
    • Developing Database Applications with ADO
    • Visual Database Tools

    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 The Training Provider: Serebra Learning Corporation
    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...
    Click here for more information or to take this course
    Home > Computer > Databases and SQL > Serebra Learning Corporation > SQL Server 7.0 Advanced Features > SQL Server 7.0 Advanced Features Part II
    Advertise With Us
    Are you a sql server 7.0 advanced features trainer?
    This page was last updated on sb5- 09/08/08 at 18:37:16 - 17:20:54