Course Brief:

This comprehensive course provides foundational knowledge in SQL programming, database queries, data manipulation, and database management. Students will learn essential SQL programming skills including queries, functions, joins, DML, DDL, constraints, and database administration. The course is designed for individuals seeking to develop their SQL programming capabilities and prepare for database development roles.

Course Structure:

Introduction
SELECT and WHERE
WHERE, ORDER BY and Intro to Functions
Single Row Functions Part 1
Single Row Functions Part 2
JOINs Part 1
JOINs Part 2
Group Functions Part 1
Group Functions Part 2
Subqueries
Ensuring Quality Queries Part 1
DML
DDL
Constraints
Views
Sequences and Synonyms
Privileges and Regular Expressions
TCL
Final Project and Exam Review
Ensuring Quality Queries Part 2