agenda.md

Hashrocket / Code Platoon SQL Workshop Agenda

This document outlines the plan for our workshop. We'll be breaking for 5 minutes each hour.

9:00 Greetings and Reading Review

We'll get to know eachother and cover the assigned reading about databases.

9:30 SQL at the PosgtreSQL REPL

Maximize your terminal and your font!

Throughout the day, we will create a PostgreSQL database and slowly add to it, covering the basics of SQL. Expect a short introduction to the command, followed by learning how it works via practice. One of our instructors will be walking around to make sure nobody gets stuck.

• create
• select columns and *
• where
• like and ilike
• insert
• null
• update
• delete
• Primary keys
• order
• limit
• and
• or
• in

12:00 Lunch

1:00 Exercises

We will dive deeper into our database, exploring advanced keywords and working through more difficult data challenges.

• offset
• join
• null (advanced)
• Aggregate functions

3:00 Data Modeling Exercises

We will model a familiar domain (timeclock, military unit, hotel) on the whiteboard.

4:00 Q & A

4:30 Homework assigned by instructor