HSFP - Database Testing

Module 1: Database concepts primer

•  What is Database Application?
•  Testing the Application vs. Testing the DMBS
•  Back End vs. Front End Testing
•  QA’ ing Data – Who is responsible?
•  What should be test in the Database?
•  Knowledge required for the Database Tester
•  Database Testing Phases
•  Database Testing Methodologies
•  Structural Database Testing
•  Functional Database Testing

Module 2: Basic SQL (Structured Query Language)

•  SQL Coding Standards – what you need to know
•  SQL Basics : Select, Insert, Update and Delete
•  Using the select Statement to Test data
•  Using the insert Statement to generate Test data
•  Testing for application accuracy using the Update and Delete Statements
•  Testing for basic data integrity using Constraints

Module 3: Testing with SQL

•  Joining Tables
•  Using SQL Queries for Data Verification
•  How Concurrency Issue affect data accuracy

 Database Objects:

•  Views
•  Indexes
•  Stored procedures
•  Triggers
•  User – Defined Functions

Module 4: Using SQL in Scripting Languages
 Structural Database Testing using TOAD Tool

•  Database schema tests
•  Database and devices
•  Tables, Columns types, defaults and rules
•  Keys and indexes

 Stored Procedure tests

•  Individual Procedure tests
•  Integration tests of procedures

 Trigger tests

•  Testing Update triggers
•  Testing Insert triggers
•  Testing Delete triggers

•  Integration tests of SQL server
•  Functional Database Testing Using QTP with VB Script
•  Dividing Back End based on Functionality
•  Checking data integrity and consistency
•  Test back end via front end
•  Login and ser security
•  Stress testing
•  Catching common Database application hacks
•  Test cases protecting against SQL Injection and other common hacks

References:

Books

Sample Interview Questions

HSFP materials

Downloads