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





Test Automation
Performance Testing
Mastering Test Design
ISTQB - Advanced Test Analyst