Tutorial Database Testing using SQL         
1. INTRODUCTION
 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. NIGHTLY DOWNLOADING AND DISTRIBUTION
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. 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 TEST ISSUES
 6.1 Test tips
 6.2 Test tools
 6.2 Useful queries