MS SQL Server 7.0 Basics

Course Code IP0240

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This course teaches the student the concept of database and tables in SQL Server 7.0.  It also covers the tools used to maintain data integrity.  The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 7-029.

Audience

This course is intended for technical managers and application developers who implement a database solution with Microsoft SQL Server client/server database management system.

Prerequisites

An understanding of Windows NT 4.0 Server and Windows 95/98.

Objective

Upon completion of this course, the student will be able to:

• identify the parts of an SQL Server database
• create an SQL Server database
• load data using the Bulk Copy Program utility
• load data using the BULK INSERT command
• load data using Data Transformation Services
• identify the different datatypes provided by SQL Server
• create tables
• select an appropriate type of index for a column
• create an index
• perform full-text search for specific columns in specific tables
• create indexes to support full-text search
• identify the different datatypes provided by SQL Server
• create tables
• select an appropriate type of index for a column
• create an index
• perform full-text search for specific columns in specific tables
• create indexes to support full-text search
• identify the types of data integrity
• identify the tools used to implement data integrity
• apply normalization rules apply denormalization techniques

Topics Include

Managing Databases

• Working with Databases
• Populating a Database

Managing Tables

• Working with Tables
• Working with Indexes
• Implementing Full Text Search Services

Organizing Data

• Implementing Data Integrity
• Normalizing/Denormalizing Data

Duration

4 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.

Media

Web Based Training