SQL Server 7.0 Advanced Features Part I

This course describes the integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods, including server cluster management, warm spares, and redundant hardware. It outlines linked and remote servers, and techniques to manage transactions distributed over these servers. 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.

Advanced Features Part I training covers such topics as:

Managing Fault Tolerance
Managing Distributed Transactions
Advanced Queries

Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential will benefit from this course. 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

Description
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.
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 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 and Part II courses.
Course Duration
» 5 hours
Everything Courseware
SQL Server 7.0 Advanced Features Part I
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

System Requirements CD-Based » Pentium class computer » 200 MHz processor (266 MHz recommended) » 32 MB RAM (64 MB recommended) » CD-ROM drive » Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000 or Windows XP (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM) » SVGA monitor capable of 16-bit color and 800 x 600 screen resolution » Sound card with speakers or headphones (optional)