How desertdba/learn-sql-in-a-month-of-lunches works
This repository provides chapter-by-chapter SQL learning resources for *Learn SQL in a Month of Lunches*. The documented workflow is to set up the SQLNovel database, then use the chapter SQL scripts as learning exercises; the README specifically warns that later scripts may depend on an updated database. Source excerpts were unavailable, so script contents and most individual database interactions cannot be confirmed.
Main entry points: Create_SQLNovel_database.sql Create SQLNovel · SQL_MOL_Ch07.sql Chapter 07 SQL · SQL_MOL_Ch08.sql Chapter 08 SQL · SQL_MOL_Ch09.sql Chapter 09 SQL
Components 25
Database setup
- Create SQLNovel
Chapter_01/Create_SQLNovel_database.sql - SQLNovel database
Chapter lessons
- Chapter 02 SQL
Chapter_02/SQL_MOL_Chapter_02.sql - Chapter 03 SQL
Chapter_03/SQL_MOL_Chapter_03.sql - Chapter 04 SQL
Chapter_04/SQL_MOL_Chapter_04.sql - Chapter 05 SQL
Chapter_05/SQL_MOL_Ch05.sql - Chapter 06 SQL
Chapter_06/SQL_MOL_Ch06.sql - Chapter 07 SQL
Chapter_07/SQL_MOL_Ch07.sql - Chapter 08 SQL
Chapter_08/SQL_MOL_Ch08.sql - Chapter 09 SQL
Chapter_09/SQL_MOL_Ch09.sql - Chapter 10 SQL
Chapter_10/SQL_MOL_Ch10.sql - Chapter 11 SQL
Chapter_11/SQL_MOL_Ch11.sql - Chapter 12 SQL
Chapter_12/SQL_MOL_Ch12.sql - Chapter 13 SQL
Chapter_13/SQL_MOL_Ch13.sql - Chapter 14 SQL
Chapter_14/SQL_MOL_Ch14.sql - Chapter 15 SQL
Chapter_15/SQL_MOL_Ch15.sql - Chapter 16 SQL
Chapter_16/SQL_MOL_Ch16.sql - Chapter 17 SQL
Chapter_17/SQL_MOL_Ch17.sql - Chapter 18 SQL
Chapter_18/SQL_MOL_Ch18.sql - Chapter 19 SQL
Chapter_19/SQL_MOL_Ch19.sql - Chapter 20 SQL
Chapter_20/SQL_MOL_Ch20.sql - Chapter 21 SQL
Chapter_21/SQL_MOL_Ch21.sql - Chapter 22 SQL
Chapter_22/SQL_MOL_Ch22.sql - Chapter 23 SQL
Chapter_23/SQL_MOL_Ch23.sql
Other components
- SQL learner
Connections 41
- SQL learner → Create SQLNovel: runs setup
- Create SQLNovel → SQLNovel database: creates database
- SQL learner → Chapter 02 SQL: uses lesson
- SQL learner → Chapter 03 SQL: uses lesson
- SQL learner → Chapter 04 SQL: uses lesson
- SQL learner → Chapter 05 SQL: uses lesson
- SQL learner → Chapter 06 SQL: uses lesson
- SQL learner → Chapter 07 SQL: uses lesson
- SQL learner → Chapter 08 SQL: uses lesson
- SQL learner → Chapter 09 SQL: uses lesson
- SQL learner → Chapter 10 SQL: uses lesson
- SQL learner → Chapter 11 SQL: uses lesson
- SQL learner → Chapter 12 SQL: uses lesson
- SQL learner → Chapter 13 SQL: uses lesson
- SQL learner → Chapter 14 SQL: uses lesson
- SQL learner → Chapter 15 SQL: uses lesson
- SQL learner → Chapter 16 SQL: uses lesson
- SQL learner → Chapter 17 SQL: uses lesson
- SQL learner → Chapter 18 SQL: uses lesson
- SQL learner → Chapter 19 SQL: uses lesson
- SQL learner → Chapter 20 SQL: uses lesson
- SQL learner → Chapter 21 SQL: uses lesson
- SQL learner → Chapter 22 SQL: uses lesson
- SQL learner → Chapter 23 SQL: uses lesson
- SQLNovel database → Chapter 07 SQL: prerequisite for
- SQLNovel database → Chapter 08 SQL: prerequisite for
- SQLNovel database → Chapter 09 SQL: prerequisite for
- SQLNovel database → Chapter 10 SQL: prerequisite for
- SQLNovel database → Chapter 11 SQL: prerequisite for
- SQLNovel database → Chapter 12 SQL: prerequisite for
- SQLNovel database → Chapter 13 SQL: prerequisite for
- SQLNovel database → Chapter 14 SQL: prerequisite for
- SQLNovel database → Chapter 15 SQL: prerequisite for
- SQLNovel database → Chapter 16 SQL: prerequisite for
- SQLNovel database → Chapter 17 SQL: prerequisite for
- SQLNovel database → Chapter 18 SQL: prerequisite for
- SQLNovel database → Chapter 19 SQL: prerequisite for
- SQLNovel database → Chapter 20 SQL: prerequisite for
- SQLNovel database → Chapter 21 SQL: prerequisite for
- SQLNovel database → Chapter 22 SQL: prerequisite for
- SQLNovel database → Chapter 23 SQL: prerequisite for