Training Course: Implementing a Database Design on MS SQL Server 7.0 (833, MOC 833)

Training Course Summary:

This course provides students with the technical skills required to implement a database solution with Microsoft SQL Server™ client/server database management system version 7.0.

Pre-Requisites:

Experience using the Microsoft Windows NT® Server network operating system
One year of experience with relational databases
Three to six months of SQL Server experience
Understanding of basic ANSI SQL statements

Training Course Overview/Content:

At the end of the course, students will be able to:

Describe the elements of Microsoft SQL Server 7.0 and the environments in which it can operate.
Describe the elements of the Transact-SQL language.
Describe and configure the data storage architecture of SQL Server.
Create and manage files, file groups, databases, tables, and transaction logs.
Enforce data integrity using constraints, defaults, and rules.
Plan for appropriate use.
Create and maintain indexes.
Write queries that retrieve and modify data using joins and subqueries.
Write queries that summarize data.
Manage locking options and transactions to ensure data concurrency and recoverability.
Create views of data.
Design and create stored procedures.
Design and create triggers.
Work with distributed data.

Qualifications:

Exam 70-29