Database Testing

Reading Time: 2 minutes

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
  • Session Wrap – Up
  • Summary
  • Final Questions