QA Tester training course is designed for backend Testing. The demand for all round testers in the data warehouse environment to test the system’s functionality through traditional testing methods and being able to show some technical knowledge is growing.
Most of the time it may happen that ETL developer or the DBA or the Data Architect will give the testing team very big queries with select statement to use for testing. To understand the long queries and its relation between the tables, columns is vital to perform a successful testing.
Sometimes you may have to write your own query to verify the test data based on an application requirement. Writing and understanding complex SQL Query is a must knowledge to have for a backend QA tester.
A tester should have the below database and SQL knowledge
- Recognize the different types of databases
- Connect to the database using different SQL connection clients
- Understand the relationship between database tables, keys, and indices
- Write a simple select or SQL statement along with more complex join queries
- Interpret more complex queries
SQL statements frequently use in testing are:
- Data Manipulation Language (DML): Used to retrieve, store, modify, delete, insert, and update data in the database. Examples: SELECT, UPDATE and INSERT statements.
- Data Definition Language (DDL): Used to create and modify the structure of database objects in the database. Examples: CREATE, ALTER and DROP statements.
- Transactional Control Language (TCL): Manages different transactions occurring within the database. Examples: COMMIT, ROLLBACK statements.
- Inner Join, Outer Join, Self Join: Retrieves the matched/unmatched records from both tables.
- Distinct: Retrieves the different values from one or more fields.
- In: This operator is used to find the value is within the list or not.
Between: This operator is used to retrieve the values with in a range.
- Like: This operator is used perform pattern matching using wildcards; it is used in the where clause.
- Order By Clause: Sorts the table records in ascending or descending order. Default order is ascending.
- Group By: Use Group By statements with the aggregate function to group the result set with one or more columns.
- Aggregate Functions: Performs a calculation on a set of values and return a single value. Example: Avg, Min, Max, Sum, count etc.
This course will cover following:
1. INTRODUCTION to Database Testing
1.1 Why back end testing is so important
1.2 Characteristics of backend 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 Oracle
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 backend
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
Database and SQL tool: Oracle, SQL Developer, SQL Plus.