SQL Fundamentals

Instructor:   John D. Starr

This course assumes you have taken Microsoft Access Fundamentals, or that you have equivalent knowledge of MS-Access from other classes and/or personal experience.   This course will teach you the basic SQL commands using an MA-Access database for the exercises.   You will learn how to use SQL to create powerful MS-Access queries without relying on the Query By Example (QBE) grid.   You will learn how to use the basic CREATE, DELETE, INSERT, and SELECT commands, along with the sub commands associated with them:   ORDER BY, GROUP BY, UNION, LEFT JOIN, etc.