Compiled Learning Objectives

Using Aggregate Functions (Prep)

• Aggregate data over multiple rows and use aggregate values to restrict the results

Inserting, Updating and Deleting Rows (Prep)

• Insert, Update and Delete rows in a pre-existing table using INSERT, UPDATE and DELETE

Joining Tables (Prep)

• Combine tables together using INNER JOIN

Creating a table (Prep)

• Aggregate data over multiple rows and use aggregate values to restrict the results

Defining Primary and Foreign Keys (Prep)

• Aggregate data over multiple rows and use aggregate values to restrict the results

Integration with NodeJS (Prep)

• Connect a PostgreSQL database to a NodeJS application
• Retrieve data from a PostgreSQL database in a NodeJS application