(CZ) 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.

About 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

Key Topics

Automating existing tests

Importing tests into a database

Functions to run specific tests

Requirements

This course is very technical

Required knowledge:

Most basic and some advanced SQL techniques

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

Knowledge of DML and DDL commands will be useful but not necessary

Previous programming experience is not necessary

Course details

Course price: 13.750 CZK / 561 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 events@tesena.com. Prices in EUR are indicative and can vary based on the exchange rate.

Upcoming PL/SQL for Test Automation course dates