Course Introduction

This course is a super-fast introduction to learning about key concepts of PostgreSQL and setting it up for app development.

What will I learn?

This course will help you understand the different Postgres features, when and how to use them, and is an ideal starting point before diving into advanced topics.

Intro to PostgreSQL
Database Core Concepts
Data Modeling
Setup and Installation
Try out SQL Statements
Create and Alter Statements
Postgres Views
Postgres Triggers
Joins
Advanced

What do I need to take this tutorial?

A browser, Postgres CLI and Docker.

However, be assured that everything you do via the browser in this tutorial can be done via code, can be version controlled and can work with any programming language you choose on the server-side.

We've kept this course light on developer workflows and environment choices so that you can focus on the key concepts and go on to set up your favorite tools and workflows.