Time Quantum Software Quality Assurance Training

The demand for "all round" testers, ie. being able to test the system's functionality through traditional testing methods
and being able to show some technical knowledge is growing.

The individual who can test the system via the Graphic User Interface (GUI) plus do back end testing is adding even more value to projects, but unfortunately, often functional testers do not have a programming background and even less database skills.

This course aims to equip the individual with all the necessary skills and knowledge to do backend testing via SQL.
Whilst the theory is thoroughly explained, much of the time is spent on practical examples and is consolidated during a
test project simulation.

Course Duration: 2 Days
Pricing: R3 900 per delegate (Excl. VAT)

Course Overview

Why do we need to do back-end testing?

Databases – overview and background

Database elements

• Entities & relationships
• Tables
• Relationships
• Relationships as keys
• Data integrity
• Referential integrity
• Considerations
• Business rules
• Relational database concepts summary

SQL and relational databases

• Databases
• SQL (structured query language)
• Database management system
• Database terms
• Database personnel /job functions
• Summary

Operators and SQL aggregate functions

• Mathematical operators
• Arithmatic operators
• SQL aggregate functions
• Summary

Data retrieval
Data modification
Data insertion
Data removal