Liam Jagrowski Spring 2022
This workshop is designed to be paired with "SQL Deep Dive" developed by Pulak Agarwal.
Goal: to introduce basic relational data logic and basic to intermediate SQL queries
In scope: SQL queries and logic; relational data; SQL structure with tables; basics of ER diagrams; constraint logic; keys
Out of scope: advanced queries, stored procedures; creating databases; accessing SQL through other methods (python, php ...), relational algebra / relational calculus
Files:
- info.docx : basic information on SQL - open this first
- create_db.sql : contains code to create database
- sql_workshop.sql : solutions file
- sql_shell.sql : contains only comments to guide code; this will be used the file where we code live in the workshop
Flow of workshop:
- Discuss mySQL, relational data
- Introduce basic queries and describe SQL structure
- Get to more advanced query logic by coming up with situations where there are more constraints or requirements on each query