Introduction

Preparation

Install PostgreSQL and pgAdmin.

Windows installers are available on the PostgreSQL website: https://www.postgresql.org/download/windows/. The interactive installer by EnterpriseDB includes PostgreSQL and pgAdmin.

For other operating systems, follow the instructions on the relevant download pages:

• PostgreSQL: https://www.postgresql.org/download/
• pgAdmin: https://www.pgadmin.org/download/

Learning Objectives

• Create a relational database using pgAdmin
• Execute an SQL query using pgAdmin

In-class

Complete the PostgreSQL tutorial. This tutorial introduces many topics that we will cover in detail throughout the rest of the course. You are not expected to be able to write the SQL queries by yourself, but trying to work through them will be good practice for upcoming lessons.

Expected duration

1–2 hours

Deadline

None (no submission is required)

Help Policy

Any resource may be used, and no documentation is required