labs / tiddlers / content / labs / lab03 / _Labs_03_Part 1_ Building a Relational


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