Tutorial - SQL for QA - Full Course

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.

- Basic SQL commands for tester

We will learn together to be able to write some basic SQL command

(Select, Insert, Update)

- Use Python Script - Connect to SQL DB to reset test data