SQL Essentials for the Real World Microcourse

This repository contains a complete SQL course for undergraduate study. It is organized by chapter and includes instructional material, exercises, quizzes, reflections, practical SQL scripts, and a final project.

Course structure

• chapter1/ through chapter16/ — course chapters with module content
• docs/ — course orientation, expectations, and student support
• final_project/ — capstone project files and SQL scripts
• fllc-security-labs/ — optional supplementary labs on SQL security and compliance
• fllc-cheatsheets/ — reference material for SQL and audit concepts

Course topics

1. Chapter 1 — Relational databases and schema design
2. Chapter 2 — MySQL Workbench and database setup
3. Chapter 3 — Retrieving data from a single table
4. Chapter 4 — Joining multiple tables
5. Chapter 5 — Insert, update, and delete operations
6. Chapter 6 — Basic database administration
7. Chapter 7 — Database security and privilege management
8. Chapter 8 — Backup and restore procedures
9. Chapter 9 — Summary queries and aggregation
10. Chapter 10 — Subqueries and correlated queries
11. Chapter 11 — MySQL data types and constraints
12. Chapter 12 — Views and logical presentation of data
13. Chapter 13 — Stored programs and procedures
14. Chapter 14 — Transactions and locking
15. Chapter 15 — Functions and stored procedures
16. Chapter 16 — Triggers and scheduled events

How to use this repository

1. Begin with docs/Welcome.md and docs/Orientation.md.
2. Work through chapters in order.
3. Read each chapter's InstructionalMaterial.md and complete the examples.
4. Use Assignment.md for graded work and Quiz.md for knowledge checks.
5. Finish the final project after chapter 16.

Notes

This course is intended for students who want practical, college-level training in SQL and MySQL. The content is structured to support lab work, problem solving, and applied practice.