Skip to content

Latest commit

 

History

History
72 lines (52 loc) · 1.95 KB

agenda.md

File metadata and controls

72 lines (52 loc) · 1.95 KB
Raw

SQL Workshop Agenda

This document outlines the plan for our workshop. All times in Central. We'll be taking a short break once per hour.

0900: Greetings and Reading Review

We'll get to know each other! We will introduce ourselves, and then you'll introduce yourself.

Then, we'll cover the assigned reading about databases.

1000: SQL at the PostgreSQL REPL

Throughout the day, we will create a PostgreSQL database and add to it, covering the basic SQL commands. Expect a short introduction to the command, followed by learning how it works via practice.

Some commands and concepts we'll cover:

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

💡 General Advice

  1. #1 debugging tip: read the error message.
  2. Please ask questions anytime! This workshop has been recorded many times and it doesn't change much. What makes it fun and different each time for us are the unique questions and engagement from the class!
  3. Rather than copy-pasting, try typing the commands into psql— that's the fastest way to learn! Tab-complete, CTRL-R (search), CTRL-P and CTRL-N (up and down) are how programmers type quickly and accurately.
  4. Please maximize your terminal window and your font size! Code should always be easy to read.

1200: Lunch

1300: Exercises

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

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

1500: Data Modeling Exercises

We will model one or more of the projects described in data_modeling/exercise.md

1600: Q & A

Question and answer time! We'll answer your questions about SQL, programming, consulting, startups, transitioning from the military into technology, etc.

1630: Homework assigned by instructor