Database Testing: Advanced Topics (CSTP Elective) or (CTM Elective)

This tutorial covers the Elective area of the Test Management Body of Knowledge (TMBOK) required for the Certified Test Manager (CTM) certification. This tutorial also covers the Elective area of the Certified Software Test Professional requirements.

For cost and cities where this course might be offered, check our Public Training Schedule.To bring this course to your test team at your location, contact our Education and Professionals Services Group.

Concepts

Testers are increasingly being required to have more technical skills. Since most modern applications have a relational database backend, testers need to be proficient in SQL. This course gives the test professional the skills they need to form more complex queries, to test for issues relative to concurrency, and to create, use and test stored procedures.

Participants will learn:

Attendees will be able to

• Use advanced SQL syntax
• Formulate complex queries
• Test issues relative to transactions, concurrency, and locking
• Create and test stored procedures

Outline

• Module 1 – Brief Review
  • Table design
  • Dangling references
  • Group by
  • Set operations
• Module 2 – Intermediate SQL for the tester 
  • Cross Joins
  • Using Subqueries
  • Advanced SQL
  • Complex queries
• Module 3 - Transactions, Concurrency and Locking
  • Transactions in SQL
  • Practical Concurrency Problems
  • Testing Concurrency Issues   
  • Test case for deadlock response 
  • Test Issues for High Performance Databases
• Module 4 - Stored Procedures
  • Typical motivations for stored procedures
  • Writing stored procedures
  • Testing  triggers
• Module 5 - Summary and review