Introduction

Over the next few labs, you will learn how to create and use a database using the SQL language a PostgreSQL database and the DBeaver database management system. Databases form the foundation of most information systems, and they provide a powerful and consistent way to organise and manage large volumes of shared data.

Today’s Learning Outcomes

• Understanding ERDs
• Connecting to PosgreSQL database using DBeaver DBMS
• Create a blank database
• SQL CREATE TABLE statements
• SQL data types
• Default Column Values
• Mandatory columns
• Populate and query tables