Welcome to Barker Pacific Group's Home Page

  Topic Outline
• SQL Syntax
• Keywords
• Data Types and Value Expressions
• Tables
• Commands
• Views and Joins
• Sub-Queries
• Performance Considerations
• Date Functions
• String Functions
• Security
• Referential Integrity

Structured Query Language (SQL)

2 days

Description

This course prepares the participant to use SQL to create and manipulate relational databases. Lab exercises vary based on the implementation of SQL (ANSI, Oracle, Teradata, MS-SQL server, or DB2).

Audience

Application programmers who need to process relational databases.

Prerequisite

Familiarity with the operating system being used.

Objectives

Students will be able to:

  • code SQL calls
  • use SQL to create, update, and manipulate relational databases

For questions or comments, contact us at sales@bpgtraining.com or (800)235-8129.

© 1996 - 2003 Barker Pacific Group, Technical Training Specialists
Phone 1.800.235.8129, All Rights Reserved.