Week 5: Zen of SQL

This week in class, we’ll be focusing on building PDFs and sending them by email. However, as you’ve seen, SQL is a critical component of every project that we do, so I wanted to take a few minutes to touch on the second half of the do-learn spiral. Please read the following sections from “Learning SQL“:

  • SQL: A Nonprocedural Language (pg 9)
  • Query Clauses – Sorting via Expressions (pg 43 – 58)
    • Don’t worry – a lot of the space on each of these pages is taken up by query results!

We’ll be kicking off this week with a few SQL review questions (intended to take no more than 30 minutes), so this will be a good way to consolidate the knowledge that you’ve acquired through examples thus far.