Compiled Learning Objectives

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