Microsoft SQL Server 2000 Designing and Implementing Databases Curriculum CBT Training CDs

Rating:
Summary: Microsoft SQL Server 2000 Designing and Implementing Databas
Review: Overview

The Microsoft SQL Server 2000 Designing and Implementing Databases Curriculum presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. It will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers, and SQL Server indexes, how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. This curriculum teaches SQL Server 2000 transactions and locks, and how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking.


Consists of five courses:


73480 Microsoft SQL Server 2000 Designing and Implementing Databases - Part 1: Introduction to SQL Server Course
73481 Microsoft SQL Server 2000 Designing and Implementing Databases Part 2: Managing Data Course
73482 Microsoft SQL Server 2000 Designing and Implementing Databases Part 3: Managing Objects Course
73483 Microsoft SQL Server 2000 Designing and Implementing Databases Part 4: Managing Indexes Course
73484 Microsoft SQL Server 2000 Designing and Implementing Databases Part 5: Distributed Data and Locks

Audience

The audience for this curriculum includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system. Students are also expected to understand database concepts and Transact-SQL syntax. Students should be familiar with the role of the database administrator.