Unit 2
Data — Workshop
Guided challenges. Read SQL, write SQL, fix broken queries, and design schemas for real app scenarios.
Challenge: Read the Query
Read the query, predict the rows, pick the matching result
The query
Pick the result this query returns:
Challenge: Write the Query
Click clause tiles in order to assemble the SQL that answers the question
In English
Tiles (click to add)
Your query
Challenge: SQL Bug Hunt
Read the symptom, find the broken line, pick the fix
What's the fix?
Challenge: Model the Data
Read the scenario, decide which table each field belongs to
Unassigned fields
Challenge: Spot the Bad Schema
Read the schema, read the symptom, pick the design problem
What's the design problem?
Challenge: Where Does the FK Go?
Read the relationship, decide where the foreign key column belongs
Where does the FK column live?