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

 

Pre-Requisites:

Any graduate can pursue a career in Mobile Testing.

For Detailed Course Contents Click here

For Upcoming Batches Please contact us