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.
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 price: 13.750 CZK / 583 EUR
Course duration: 2 days (each day from 09:00 to 17:00)
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.