Module: Databases (PostgreSQL)

Introduction to building PostgreSQL SQL databases.

Learning Outcomes

You understand basic principles of databases: normal forms, SQL vs. noSQL vs. OO, etc.
You can develop basic databases in PostgreSQL efficiently and effectively.

PostgreSQL Official Documentation

Prisma Official Documentation

Read through the w3schools SQL Tutorial

Install pgAdmin and connect to your PostgreSQL server

Section 4: 17 Oct 11:00 PM Sections 1,2,5: 18 Oct 11:00 PM

Follow the PostgreSQL Getting Started guide

Section 4: 17 Oct 11:00 PM Sections 1,2,5: 18 Oct 11:00 PM

Follow the Prisma Start from scratch relational databases guide

Section 4: 18 Oct 11:00 PM Sections 1,2,5: 19 Oct 11:00 PM