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

SQL Server 7.0 Advanced Features Part I

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 advanced Transact-SQL OSQL and 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 I

Audience

Database administrators Database analysts and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series is designed to help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. This series is also appropriate for individuals who derive physical database designs develop logical data models create physical databases create data services by using Transact-SQL manage and maintain databases configure and manage security monitor and optimize databases and install and configure Microsoft SQL Server.

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.

Objective

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

  • Identify different redundant data storage methods
  • Identify spare server options for fault tolerance
  • Discuss server cluster configurations
  • Determine the best failover support for your enterprise
  • Create a linked server and setup security for linked databases
  • Describe the functions of the microsoft Distributed Transaction Coordinator
  • Force conflict resolutions

    • Topics Include

    Unit 1: Managing Fault Tolerance

    • Redundant Data Storage
    • Server Clusters and Configurations
    • Warm Spares
    • Determining Failover Support

    Unit 2: Managing Distributed Transactions

    • Linked and Remote Servers
    • Configuring MS DTC
    • Two Phase Commit
    • Forcing Conflict Resolution
    • ACID Properties

    Unit 3: Advanced Queries

    • Distributed Queries
    • Heterogeneous Replication
    • Embedded SQL
    • Open Data Services

    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 I
    Advertise With Us
    Do you teach sql server 7.0 advanced features ?
    This page was last updated on sb5- 09/08/08 at 18:37:17 - 21:37:52