Courses

Database Testing Course Details

About Database Testing Training

Collection of files that are connected to each other is referred to as a database, various servers will have databases that are not similar. The four layers of the database system are the User Interface (UI) layer, the business layer, the database, and the data access layer, all the layers are needed to be tested for maintaining a database system. The tester needs to have knowledge on checking tables, writing queries and procedures, SQL or Oracle applications are used in a web application or desktop and database. Database Testing is required in banking, finance, health insurance as the data plays a crucial role in these sectors.

Database Testing Course Curriculum

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

Moule 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