Database Testing Concepts

Database Testing

Concepts:
1. The Database Component: Database Application
2. Back end vs. Front End Testing
3. Examining the sample data, round trip through the application
4. Common problems in Relational Databases that affect the Database Application
5. Test Plan: Organizing your approach
6. Test set up ? Setting up a database server and creating sample data that might create problem in anticipation
7. Types of Data Integrity
8. Identifying Design Defects
9. Inspecting table structures to unmask design problem
10. Reading an ERD
11. Table Relationships: 1-1, 1-many, many-to-many
12. Knowledge on Data Normalization Bugs
13. Understanding Normalization: First, 2nd and 3rd Normal Form
14. Developing database Test cases
15. SQL essentials
16. Basic SQL statements for Testing:
1. Data validity testing - SQL queries
2. Data Integrity testing - Constraints Check
3. Performance related to database - Idea about table structure, design and Application Architecture - Creating huge data and operating the application.
4. Testing of Procedure, triggers and functions