SQL (Structured Query Language) Programming

Course Objectives: This course provides students with the ability to use the industry standard Structured Query Language (DDL, DML, & DCL) for data definition, data manipulation and data control. SQL programming will be taught using Visual Basic's Visual Data Manager.

Course Outlines:
Manipulating Tables
Creating Table Statements
SQL Data Types
Column Constraints - Not Null, Check, Primary Key and Unique
KEYS and Referential Integrity
A brief look at Normalization
Referential Integrity and other Constraints
Manipulation Data Base Information
The INSERT INTO Command
Updating and Deleting Rows
Query the Data Base - the SELECT Command
SELECT Command Basics
The ORDER BY Clause
Joining Tables
Cross Join
Self Joins and Aliases
Outer Join
Grouped Tables and Aggregate Functions
The GROUP BY Clause
GROUP BY and HAVING
Views
The CREATE VIEW Syntax
Optimization and Performance Tips
Indexing a Table