Getting Started with PostgreSQL

Getting Started

1. What is PostgreSQL – introduce you to PostgreSQL and its applications in today’s software stack.
2. Introduction to PostgreSQL sample database – to learn the PostgreSQL fast, you need to have a good sample database to practice with. This tutorial introduces you to a PostgreSQL sample database called dvdrental.

PostgreSQL on Windows

If you’re using windows, you can follow these tutorials to install PostgreSQL, connect to it, and load the sample database into the PostgreSQL database server:

1. Install PostgreSQL on Windows – walk you through the steps of how to install PostgreSQL on Windows.
2. Connect to PostgreSQL database server – show you how to connect to the PostgreSQL using psql tool and pgAdmin 4 GUI tool.
3. Load the sample database into the PostgreSQL database server – guide you on how to load the sample database into the PostgreSQL database server for practicing.

PostgreSQL on Linux

1. Install PostgreSQL on Ubuntu – you will learn how to install PostgreSQL on Ubuntu, connect to the PostgreSQL database server using the psql tool, and load the sample database into the PostgreSQL.

PostgreSQL on macOS

1. Install PostgreSQL on macOS – learn how to download PostgreSQL installer for macOS, how to install PostgreSQL on macOS, and how to restore the sample database into the PostgreSQL database server.