Compiled Learning Objectives

At the end of the sprint, you should be able to do the following things. Make sure to check you can do them all, and if not, go back and keep practicing until you can.

Using Aggregate Functions

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

Inserting, Updating and Deleting Rows

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

Joining Tables

• Combine tables together using INNER JOIN

Creating a table

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

Defining Primary and Foreign Keys

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

Integration with NodeJS

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