Newer
Older
labs / tiddlers / content / labs / lab03 / _Labs_03_Part 1_ Building a Relational Database.md
# 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