Relational database management systems (RDBMSs) often persist mission-critical data which is updated by many applications and potentially thousands if not millions of end users. Furthermore, they implement important functionality in the form of database methods (stored procedures, stored functions, and/or triggers) and database objects (e.g. Java or C# instances). The best way to ensure the continuing quality of these assets, at least from a technical point of view, you should have a full regression test suite which you can run on a regular basis.

The course is intended for intermediate programmers, developers and testers, leads who need to work in the expert view .

After completing the course

• Introduction to Database Testing
• Introduction to ETL Testing
• SQL Queries
• Boundary testing
• Smoke testing
• Database unit testing
• Confirming database structure
• A simple test to ensure database connectivity
• Testing the persistence of data
• Database corruption and security testing (they tend to go hand in hand)
• Database performance testing
• Examples: Oracle SQL
• Examples: MS SQL Server
• Examples: MySQL
• Examples: Excel To SQL

Knowledge of basic concepts of computers and software applications

Approximately 50% of the course is devoted to lab exercises. Mercury Interactive provides a Flight Reservation System Web application and Windows Flight application for this training.

• Windows xp Operating System
• QTP 9.2V