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
Sample Interview Questions
HSFP materials

No comments: