This course is intended for programmers, systems analysts, programmer/analysts
and other data processing professionals who require an in depth
knowledge of programming in Structured Query Language (SQL).
Course Description
A discussion of relational databases begins the course, followed
by a presentation of table operations. Next, the Structured Query
Language (SQL) is discussed. The rest of the course is devoted to
accessing SQL interactively using Microsoft Access and embedding
SQL. Five computer case studies are assigned: three interactive
exercises and two programs using SELECT, UPDATE, INSERT, and DELETE
and cursor processing.
Course Topics
Overview of SQL
SQL DDL
DML Statements: SELECT
DML: More on SELECT
Functions
Use of GROUP BY and HAVING
JOINS and SUBSELECTS
Other DML Statements
Application Programming
Preparing a Program for Execution
Cursor Processing
Additional Considerations in Application Programming
