|
 |
Testing Databases |
 |
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
|
|
|
|
|
|