Course code: ATPLSQL« Back

PL/SQL for Test Automation

Learn the basics of PL/SQL - a procedural extension of Oracle SQL - and show how it can be used to run tests in a loop, verify the query results against expected outcomes and log the test runs

 DateDurationCourse priceHandbook priceCourse languageLocation 
9/19/2019 2 12 950 CZK - Český jazyk Praha - Tesena
 
11/28/2019 2 12 950 CZK - Český jazyk Praha - Tesena
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 12 950 CZK - 0
Bratislava2 529,00 EUR - 0

What we teach you

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 – and show how it can be used to run tests in a loop, verify the query results against expected outcomes and log the test runs. This will allow the tester to run a script in the evening and check the results in the morning, verifying reported incidents.

We will learn how to modify existing tests so they can be automated, import them into database and create a procedure and several auxiliary functions that will run specified tests one after another until all are completed. The procedure will log the results of each test into a logging table along with timestamps, whether the test passed or not and if it failed, for how many rows it did.

This course is very technical. Most basic and some advanced SQL techniques are required. Knowledge of basic query structure, subselects, and the basic types of joins will be assumed. Knowledge of DML and DDL commands will be useful but not necessary as we will go over the important ones. Previous programming experience is not necessary at all.

Required skills

This course is very technical. Most basic and some advanced SQL techniques are required. Knowledge of basic query structure, subselects, and the basic types of joins will be assumed. Knowledge of DML and DDL commands will be useful but not necessary as we will go over the important ones. Previous programming experience is not necessary at all.

Teaching methods

Professional explanation with practical samples and examples.

Teaching materials

tesena guide book for this course.

Previous courses

no preceding courses

Next courses

no following course
No data.
The prices are without VAT.