How to Setup a Local PostgreSQL Database | Import Data, Create Users, Connect to Tableau + Python

In this video, I walk through setting up a PostgreSQL Database 16.3 locally to enable you to run personal SQL projects. The data we upload here is part of the Summer of SQL challenges week 7.

Check out other challenges from the Summer of SQL here:

00:00 Intro
00:20 Downloading and installing the software
04:26 pgAdmin 4 introduction
06:24 Importing data via the csv wizard
10:50 Creating a database, schema and setting the path
14:56 Importing data via SQL script
17:51 Creating a role / user and setting permissions
24:57 Connecting via DBeaver
27:42 Connecting via Tableau
30:00 Connecting via Python
32:23 Outro