Course overview

Objective

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.

SQL

Introduction to databases

  1. Introduction to databases
  2. Introduction to PostgreSQL
  3. Communicating with the database using SQL

SELECTing data

  1. Using Aggregate Functions
  2. Inserting, Updating and Deleting Rows
  3. Joining Tables
  4. Creating a table
  5. Defining Primary and Foreign Keys
  6. Integration with NodeJS

Accessing data from NodeJS

  1. Communicating with the database using SQL
  2. Being More Selective
  3. CRUD operations with NodeJS and PostgreSQL