SQL

Structured data storage and retrieval; relational databases, querying, sketching and designing databases, and database management systems.

This track contains a record of some past SQL teaching material, but is not very thorough or well structured. It includes basic querying, both in raw SQL and from NodeJS. It does not cover schema design, more advanced querying patterns, or joins other than inner joins. It also has little by way of practical exercises or projects.

  1. prep

    : Setting up PostGreSQL on Mac or Linux

  2. Sprint 1

    : Introduction to databases

  3. Sprint 2

    : SELECTing data

  4. Sprint 3

    : Accessing data from NodeJS

  5. End of Module Review

    : How do we know if we have completed this module?