SQL For Testers

Brief Intro

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: 4 Days
Pricing: $0.00

Course Overview

1. INTRODUCTION to Database Testing

• 1.1 Why back end testing is so important
• 1.2 Characteristics of back end testing
• 1.3 Back end testing phases
• 1.4 Back end test methods

2. STRUCTURAL BACK END TESTS 
2.1 Database schema tests 

• 2.1.1 Databases and devices
• 2.1.2 Tables, columns, column types, defaults, and rules
• 2.1.3 Keys and indexes

2.2 Stored procedure tests 

• 2.2.1 Individual procedure tests
• 2.2.2 Integration tests of procedures

2.3 Trigger tests 

• 2.3.1 Update triggers
• 2.3.2 Insert triggers
• 2.3.3 Delete triggers

2.4 Integration tests of SQL server 
2.5 Server setup scripts 
2.6 Common bugs 
3. FUNCTIONAL BACK END TESTS 

• 3.1 Dividing back end based on functionality
• 3.2 Checking data integrity and consistency
• 3.3 Login and user security
• 3.4 Stress Testing
• 3.5 Test back end via front end
• 3.6 Benchmark testing
• 3.7 Common bugs

4. Testing The Nightly downloading and Distribution jobs 

• 4.1 Batch jobs
• 4.2 Data downloading
• 4.3 Data conversion
• 4.4 Data distribution
• 4.5 Nightly time window
• 4.6 Common bugs

5. Testing the Interfaces to Transaction APIS

• 5.1 APIs' queries to back end
• 5.2 Outputs of back end to APIs
• 5.3 Common bugs

6. Other Database testing Issues

• 6.1 Test tips
• 6.2 Test tools
• 6.2 Useful queries