[Tutorial] Setup the simple Postgres SQL database for learning

The knowledge and skills about Database are very necessary for QA/QC when we involve in testing activities. In this page, I will share you how to set up a simple database.

One of common databases that we will work, is SQL. On this tutorial, Testing4Everyone will show you the basic about SQL, the example database, then you can practice and gain the fundamental of SQL.

Note: You can refer to this repo on Github, I collected all assessments in this tutorial.

https://github.com/josdoaitran/postgres-for-qa-qc

The ER - Entity Relationship of Simple Database - Rental database.

- Setup Example Database in your local

In order to practice SQL command, I will support you install and setup a local database in your computer. Then, you can use it to practice the basic SQL command that a tester should know.

Install Docker:

+ On windows: 

 

+ On Mac:

 

You can follow to theses steps in this video: