Course objective:

                By the end of this course participants will be able to:

    •    Develop a strategy and plans for testing e-Database
    •    Develop test cases for testing –Database
    •    Identify bugs and ensure that bugs are being resolved appropriately

Intended Audience:

The course is intended for beginners or intermediate testers, leads who need to develop or improve Database Testing skills.

Prerequisite:

    •    Know of Database Concepts
    •    Know of SQL

Course Outline: What is database
    •    Why we require database Testing
    •    Common Defects
    •    Entity Integrity
    •    Domain Integrity
    •    Referential integrity
    •    Security of Database
    •    Select Queries
    •    Update Queries
    •    Delete Queries
    •    Joins
    •    Practice on executing above queries
    •    Types of Database Testing
    •    Database Test Plan
    •    Testing Tables
    •    Testing Procedures
    •    Testing Triggers
    •    Testing Views
    •    Testing Tables Spaces
    •    Testing Indexes
    •    Testing Synonyms
    •    Testing Referential Integrity