SQL Server 7.0 Management Part II

This course provides tshe skills to database administrators, managers, and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL, how to use the SELECT statement, and how to monitor database performance. It also examines stored procedures and joins.

Management Part II training covers such topics as:

Elements of Transact-SQL
The SELECT Statement
Stored Procedures
Monitoring Database Performance

This course is designed for Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series will 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.

Description
This course provides the skills to database administrators, managers, and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL, how to use the SELECT statement, and how to monitor database performance. It also examines stored procedures and joins. 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, and SQL Server 7.0: Management Part I courses.
Course Duration
» 5 hours
Topics Include
Unit 1: Elements of Transact-SQL
» Transact-SQL
» Data Control Language Statements
» Data Definition Language Statements
» Data Manipulation Language Statements
Everything Courseware
SQL Server 7.0 Management Part II
Unit 2: The SELECT Statement
» WHERE Clause
» Other Uses of the SELECT Statement
Unit 3: Stored Procedures
» Overview of Stored Procedures
» Features of Stored Procedures
» Stored Procedure Syntax
» Viewing Stored Procedures

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)