Databases and SQL for Testers

Check what an app really saved instead of trusting the screen. Read a shop's schema with its keys and relationships, open the database in DBeaver, filter, count, group and join rows with SQL, verify every row a checkout must leave behind, and find a document in MongoDB. All practice runs on the data of the Shelf practice shop. For learners who test through the UI and can read a JSON response; no SQL or programming needed, a desktop computer is for two lessons. Course 7 of the QA Engineer Path.

Course 7 of 13 in the QA Engineer Path

8 lessons · 110 stepscertificate

What you will learn

Check what the app saved, with SELECT, GROUP BY and JOIN.

Course program

The full outline. Lessons open when the course does.

Where the data lives

Tables, keys and normal forms15 steps

Connecting with DBeaver15 steps

Asking the data questions

SELECT and WHERE12 steps

Aggregates and GROUP BY13 steps

Joining tables12 steps

Checking what the app saved

Verifying checkout in the DB12 steps

MongoDB: documents instead of rows14 steps

Review: the data round17 steps

How this course compares with others

Section: QA Engineer Path

Next on the path: Mobile Testing and Traffic Interception

The author

Artsiom Rusau – QA engineer and course author. He has tested software since 2019 and has taught software testing since 2020.

LinkedIn All courses