Software Training Back to Course Listings
Back to Course Categories

Course Name Implementing a Database on Microsoft SQL Server 7.0
Course No. 833
Course Description

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.

Who Should Attend This course is intended for Microsoft SQL Server implementers, system engineers, and developers who are responsible for implementing SQL Server and writing Transact-SQL scripts.
Prerequisites
  • 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
Length 40 hours
Class Size Up to 12
CEU's Awarded 3.5

This course helps you prepare for the Microsoft Certified Professional exams 70-29: Designing and Implementing Databases with Microsoft SQL Server 7.0
Format Hands-on Workshop. One lab station for every participant.
Learning Objectives Participants will learn 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.
Course Customization Call 1-800-777-0753 for a detailed outline or for information about tailoring this course to your specific needs.
For scheduling please call your
Customer Representative at 1-800-777-0753.

 

Home | Information Request | Resource Library | Store | Courses 
College Transfer Credit and CEU's | Client Relationship | Training Methodology

Copyright © 2007 Learn Maintenance, Inc.