Part of the Free Full-stack course: https://www.youtube.com/playlist?list=PL6yRaaP0WPkXo7Kl6LQcO69bsYTS7BDxo

Welcome to the Free Full-stack Course

In this course, we will be using Python as the programming language for our backend to deliver REST APIs. The REST APIs will be developed on top of Django which is a backend/website framework that sits on top of Python. And we will also use DRF (Django REST Framework) to actually deliver our APIs on top of Django.

PostgreSQL is the world's most advanced open-source relational database. Later when we get to the backend development part of this course with Django and Django REST Framework (DRF), we will use PostgreSQL as our database system so it's important that we set it up correctly in this chapter. In this chapter we will install PostgreSQL on Windows 11.

Timestamps:
00:00 - Installing PostgreSQL on Windows
00:56 - What is PostgreSQL?
01:24 - Download the installer
01:52 - Let's go through the install process
03:58 - Password for database superuser (postgres)
04:17 - Choose the port to connect to
04:21 - Use the default locale
04:30 - Go through with the installation
05:11 - Open Stack Builder at the end of installation
06:19 - Open pgAdmin
06:34 - Set a master password
06:52 - Explore the servers to the left hand side
07:14 - Add PostgreSQL installation to the path
07:58 - Open up PowerShell
08:11 - Create a new PostgreSQL user
09:38 - Create a DB for your new user
10:40 - Connect to PostgreSQL
11:11 - Get your connection information
11:28 - You've successfully installed PostgreSQL on Windows

If you want to support my work, please consider joining my YouTube channel by pressing the Join button!

Twitter: https://twitter.com/vandadnp
LinkedIn: https://linkedin.com/in/vandadnp

Let's get started!