The knowledge and skills about Database are very necessary for QA/QC when we involve in testing activities.
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
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.
Setup environment to Learn
Here is the video to help you have a SQL server for practice
Basic SQL commands for tester
We will learn together to be able to write some basic SQL command
(Select, Insert, Update)