Relational Database Concepts: The Structured Query Language

This course introduces the Structured Query Language (SQL), which is the most widely used language for the development and manipulation of relational databases. The course focuses on Relational Database Management Systems (RDBMS) query language technology and will identify and explain the details of the Structured Query Language (SQL).

The Structured Query Language training covers such topics as:

SQL History and Concepts
Creation Using SQL
Update and Access Using SQL

The course is designed for database administrators.

Relational Database Concepts: The Structured Query Language
Description
This course introduces the Structured Query Language (SQL), which is the most widely used
language for the development and manipulation of relational databases. The course focuses on
Relational Database Management Systems (RDBMS) query language technology and will identify
and explain the details of the Structured Query Language (SQL).
Audience
The course is designed for database administrators.
Prerequisites
Some knowledge of SQL.
Course Duration
» 5 hours
Topics Include
Unit 1:
SQL History and Concepts
» SQL Overview
» SQL Evolution
» SQL Concepts
Unit 2:
Creation Using SQL
» Database Language Definition
Unit 3:
Update and Access Using SQL
» Data Manipulation Language
» Data Control Language

System Requirements

» 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, or Windows
2000 (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)

Features
• Industry-leading Technology - CCI's Learning Object Framework enables the design and development of flexible, self-contained learning modules for a personalized training experience

• Award-winning Products - eSchool Solutions create anywhere, anytime learning environments that boost productivity with their off-the-shelf courseware or fully customized content.

• Powerful Training Solutions - Highly adaptable and customized e-learning models and instructional design tailored to the diverse needs of the training industry, delivered in a packaged CD or on the Web.

• Satisfied Clients - With a solid reputation for quality products and bottom-line results, CCI's e-learning solutions have been adopted by diverse organizations including Royal Bank, Thomson Publishing, IBM, Paradyne Corporation, InfoCast Corporation, GE, Delta Environmental, HighTech Campus, California Federal Bank, CIBC and many others.