PostgreSQL Tutorial: Getting Started with PostgreSQL

This section helps you get started with PostgreSQL by showing you how to install PostgreSQL on Windows, Linux, and macOS. You also learn how to connect to PostgreSQL using the psql tool as well as how to load a sample database into the PostgreSQL for practicing.

Getting Started

• What is PostgreSQL – introduce you to PostgreSQL and its applications in today’s software stack.
• 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 vs MySQL – compare PostgreSQL with MySQL in terms of functionalities.
• PostgreSQL vs. Microsoft SQL Server – compare PostgreSQL with SQL Server in terms of functionalities.
• Cloud based service vs. Traditional deployment – you will learn about differences between cloud based database service and traditional deployed database.
• PostgreSQL cheat sheet – introduce you the common PostgreSQL commands and statements that enable you to work with PostgreSQL quickly and effectively.

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:

• Install PostgreSQL on Windows – walk you through the steps of how to install PostgreSQL on Windows.
• Connect to PostgreSQL database server – show you how to connect to the PostgreSQL using psql tool and pgAdmin 4 GUI tool.
• 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.
• Restart PostgreSQL on Windows – you will learn how to restart PostgreSQL on Windows using Service Manager, command line, and pg_ctl command.

PostgreSQL on Linux

• Install PostgreSQL on Linux using yum – you will learn how to install PostgreSQL on Red Hat, connect to the PostgreSQL database server using the psql tool, and load the sample database into the PostgreSQL.
• Install PostgreSQL on Ubuntu using apt – 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.
• Install PostgreSQL using Docker – walk you through the steps of how to install PostgreSQL on Linux using Docker.
• Deploy pgAdmin 4 in Server Mode on Ubuntu – walk you through the steps of how to deploy pgAdmin on an Ubuntu server, accessing pgAdmin through a web browser, and connecting it to a PostgreSQL database on your server.
• Uninstall PostgreSQL from Ubuntu – you will learn step-by-step how to uninstall PostgreSQL from Ubuntu.
• Restart PostgreSQL on Ubuntu – you will learn how to restart PostgreSQL on Ubuntu using systemctl, service command, and pg_ctl command.

PostgreSQL on macOS

• 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.

Use tools to access PostgreSQL

• Access PostgreSQL with DBeaver – walk you through the steps of how to install DBeaver, and connect to the PostgreSQL database server using DBeaver.
• Setting up JDBC Driver in DBeaver – you will learn how to set up PostgreSQL JDBC driver in DBeaver.
• Access PostgreSQL using Excel – walk you through the steps of how to configure Microsoft Excel, and access data in a PostgreSQL database through an ODBC connector using Excel.