Tester 'll Never " Satisfied "

• Module 1 Database Testing Concepts Primer

o The Database Component : What is a Database Application?
o Testing at the Database layer
o Why should Test professionals know DB Basics?
o The DB component:What is a Data-Based Application?
o Back end vs. Front End Testing
o Examining the data’s round trip through the app
o Common problems in Relational Databases that affect the Database Application
o Testing the Application vs. Testing the DBMS
o Knowledge Requirements for Database Testing
o Test Plan: Organizing your approach
o Data must pass Quality Assurance too!
o Test Set up


• Module 2 Relational Database Basics for Testing

o Why should Test professionals know Relational DB basics?
o What’s a relational database?
o Types of Data Integrity
o Lack of data integrity introduces bugs
o Identifying Design Defects
o Inspecting table structures to reveal design problems
o Exploratory Testing: Reading an ERD
o Table Relationships: 1-1, 1-many, many-to-many
o What to look for when Testing Relational Databases


• Module 3: Data Normalization Bugs

o What bugs are caused by improperly normalized databases
o Understanding Normalization:First, 2nd and 3rd Normal Form
o Understanding Denormalization
o Identifying poor design; developing Test cases


• Module 4: Introduction to SQL

o Why should Test professionals know Structured Query Language?
o SQL essentials
o Basic SQL statements for Testing