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 Modelling
- Setup and Installation
- Try out SQL Statements
- Create and Alter Statements
- Postgres Views
- Postgres Triggers
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.
How long will this tutorial take?
Approximately 2 hours.