Database Testing Course Content



DATABASE TESTING CONCEPTS PRIMER
The Database Component: What is a Database Application?
Testing at the Database layer
Why should Test professionals know DB Basics?
The DB component: What is a Data-Based Application?
Back end vs. Front End Testing
Examining the data’s round trip through the app
Common problems in Relational Databases that affect the Database Application
Testing the Application vs. Testing the DBMS
Knowledge Requirements for Database Testing
Test Plan: Organizing your approach
Data must pass Quality Assurance too!
Test Set up
RELATIONAL DATABASE BASICS FOR TESTING
Why should Test professionals know Relational DB basics?
WHAT’S A RELATIONAL DATABASE?
Types of Data Integrity
Lack of data integrity introduces bugs
Identifying Design Defects
Inspecting table structures to reveal design problems
Exploratory Testing: Reading an ERD
Table Relationships: 1-1, 1-many, many-to-many
What to look for when Testing Relational Databases
DATA NORMALIZATION BUGS
What bugs are caused by improperly normalized databases
Understanding Normalization: First, 2nd and 3rd Normal Form
Understanding Denormalization
Identifying poor design; developing Test cases
INTRODUCTION TO SQL
JMeteWhy should Test professionals know Structured Query Language?
SQL essentials
Basic SQL statements for Testing

Enquiry Form                         

CONTACT US

  1. 10521 Shadow Ridge Ln Apt 203,
  2. Louisville KY-40241
  3. Contact No : 606 909 4722
  4. Email : contact@coloursit.com

TESTIMONIALS

  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Kranthi Ch
MD, Siri IT Solutions



  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Sreedhar J
Manager, Siri IT Solutions

Copyright © 2014 Colours IT Consulting | All Rights Reserved.