PL/SQL for Test Automation

Learn the basics of PL/SQL. Run tests in a loop, verify the query results against expected outcomes and log the test runs.

Why attend the course?

Most database tests can be described in a simple way – verify that a field meets the specified requirements and if it does, the test passes. All such tests have a unified way to state expected results – either the fields are always equal or they’re not. These tests can be automated.

This course aims towards this automation. We will learn the basics of PL/SQL – a procedural extension of Oracle SQL.

You’ll see how it can be used to run tests in a loop, verify the query results against expected outcomes and log the test runs. All this will allow the tester to run a script in the evening and check the results in the morning, verifying reported incidents.

Key Takeaways

Automating existing tests

Importing tests into a database

Procedures that will run specific tests


This course is very technical

Needed knowledge:

Most basic and some advanced SQL techniques

Knowledge of basic query structure, sub selects, and the basic types of joins

Previous programming experience is not necessary at all

Course Details

Course price: 13.750 CZK / 583 EUR

Course duration: 2 days (each day from 09:00 to 17:00)

*All Prices are excluding VAT. Unless agreed otherwise invoices will be in CZK, for an agreement on the currency contact us at or let us know in the customer notes section in the order form.

Michal Dančák will guide you through the course

Michal has been involved in testing since 2016, when he joined Tesena after studying logic at FFUK. Most of his time in Tesena was devoted to databases on banking projects for Česká spořitelna, Erste and KB. In all cases, it was Oracle SQL and its procedural PL/SQL framework, about which he co-created the PL/SQL for Test Automation training in 2018. In his spare time, he is primarily engaged in bouldering and board games.

Upcoming PL/SQL for Test Automation dates

We currently do not have a public date for this course.
Are you interested in the training?
Fill out our form and we will organize an in-house training for you.