fbpx
Menu

PL/SQL for Test Automation

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

Course goals:

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 also 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 topics:

  • Modifying existing tests so they can be automated
  • Importing tests into a database
  • Creating a procedure and auxiliary functions that will run specified tests
  • Understanding the procedure that logs the test results into a logging table

Requirements:

  • This course is very technical
  • 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 at all

Upcoming Courses

Training Date Language Location
PL/SQL for Test Automation
June 01 – 02 English Prague Request Offer Buy Now

Training for Companies and Groups

For your team or group we can provide tailor-made training courses and conduct training onsite or at a location of your choice, on a date that is convenient for you. Please contact us for more information.

info@tesena.com
Dear user, this website uses cookies to ensure you get the best experience on our website. More about cookies
I give my consent to processing of my personal data. More info