motivational thoughts >>>>>

When we change our world changes. We usually wait for the world to
change, sometimes the world at large and sometimes our own little
world. Since it is not in our hands we don't find it changing
according to what we want and we give up trying. We rarely think of
changing ourselves which is possible. When we change, our thoughts and
attitude change too. We are then able to look at the people and our
world around us with a different vision. Thus we find that our world
changes, not so much in the situation as much as in our own
perception.

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