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.

Why, what, how, and when you will learn about PostgreSQL

Screencast 7 min

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