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

You would..
Share
Related Documents
  1. Tutorial Database testing using SQL (23020)
  2. [Free] DTM Data Comparer : compare 2 database (2845)
  3. AWR Installation and using in Oracle Database for Performance Testing (1817)
  4. testing using sql (1587)
  5. [Ebook] Beginning Database Design: From Novice to Professional (4504)
  6. Sql Introduction for Database Testing (2724)
  7. SQL Server Performance Testing articles (1617)
  8. Database Interview Questions (109 Questions) (3673)
  9. SQL for Database Testing (2656)
  10. Informix Guide to SQL: Tutorial (1322)
  11. Looking for resources for Upgrade Testing of MySQL? (1037)
  12. Organizing testing checklists (1471)
  13. [Video] Testing Mobile Contents by Adobe Device Cantral (849)
  14. Exploratory Testing - Risk-Based Agile Testing (3537)
  15. CICS Mainframe Testing Screens Tutorial (9949)
  16. Automated Web Page Testing with Selenium IDE: A Tutorial (2015)
  17. Understanding TESTING ESTIMATION using Use Case Metrics (1924)
  18. Tips to Improve Productivity Using Software Testing Tools (480)
  19. 2011-04-11, MySQL Conference & Expo @ USA (7343)
  20. Functional Testing : Tutorial Functional Testing (1497)