SQL Data Management

Outline

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

Description

Gives students a practical grasp of SQL commands for manipulating data, and teaches commands to define tables, views, and indexes.

Audience

End users, programmers, database administrators, analysts, designers and managers.

Prerequisites

An understanding of database structure and principles.

Topics Include

Manipulating Data

• UPDATE Command
• INSERT Command
• DELETE Command

Defining Database Tables

• CREATE TABLE Command
• ALTER TABLE Command
• DROP TABLE Command

Views, Synonyms and Indexes

• Defining and Using Views
• Defining and Using Synonyms
• Defining and Using Indexes
• Security Considerations

Duration

3 hrs

Minimum Requirements

VGA Color Monitor; 640K RAM; 3.0MB Hard Disk Space; DOS 3.3; or Higher  

Media

Diskette
CDROM

© Copyright Serebra Learning Corp., 2002