Overview:
Database testing involves checking stored procedures, views, schemas in the database, tables, indexes, keys, triggers, data validations, and data consistency check. … To perform DB testing, a tester needs a thorough knowledge of database concepts − like procedures and functions, views, indexes, keys, and good hands-on SQL.
Audience:
This course is intended for Test Engineers for Testing a Database Application. No prior experience is presumed.
Pre-Requisite:
Knowledge in Manual Testing
Course Curriculum
| Module 1: Database concepts | |||
| What is Database Application? Details | 00:00:00 | ||
| Testing the Application vs. Testing the DMBS Details | 00:00:00 | ||
| Back End vs. Front End Testing Details | 00:00:00 | ||
| QA’ ing Data Details | 00:00:00 | ||
| Who is responsible? Details | 00:00:00 | ||
| What should be test in the Database? Details | 00:00:00 | ||
| Knowledge required for the Database Tester Details | 00:00:00 | ||
| Database Testing Phases Details | 00:00:00 | ||
| Database Testing Methodologies Details | 00:00:00 | ||
| Structural Database Testing Details | 00:00:00 | ||
| Functional Database Testing Details | 00:00:00 | ||
| Module 2: Basic SQL (Structured Query Language) | |||
| SQL Coding Standards Details | 00:00:00 | ||
| What you need to know Details | 00:00:00 | ||
| SQL Basics : Select, Insert, Update and Delete Details | 00:00:00 | ||
| Using the select Statement to Test data Details | 00:00:00 | ||
| Using the insert Statement to generate Test data Details | 00:00:00 | ||
| Testing for application accuracy using the Update and Delete Statements Details | 00:00:00 | ||
| Testing for basic data integrity using Constraints Details | 00:00:00 | ||
| Module 3: Testing with SQL | |||
| Joining Tables Details | 00:00:00 | ||
| Using SQL Queries for Data Verification Details | 00:00:00 | ||
| How Concurrency Issue affect data accuracy Details | 00:00:00 | ||
| Database Objects Details | 00:00:00 | ||
| Views Details | 00:00:00 | ||
| Indexes Details | 00:00:00 | ||
| Stored procedures Details | 00:00:00 | ||
| Triggers Details | 00:00:00 | ||
| User Defined Functions Details | 00:00:00 | ||
| Module 4: Using SQL in Scripting Languages | |||
| Database schema tests Details | 00:00:00 | ||
| Database and devices Details | 00:00:00 | ||
| Tables, Columns types, defaults and rules Details | 00:00:00 | ||
| Keys and indexes Details | 00:00:00 | ||
| Stored Procedure tests Details | 00:00:00 | ||
| Individual Procedure tests Details | 00:00:00 | ||
| Integration tests of procedures Details | 00:00:00 | ||
| Trigger tests Details | 00:00:00 | ||
| Testing Update triggers Details | 00:00:00 | ||
| Testing Insert triggers Details | 00:00:00 | ||
| Testing Delete triggers Details | 00:00:00 | ||
| Integration tests of SQL server Details | 00:00:00 | ||
| Checking data integrity and consistency Details | 00:00:00 | ||
| Test back end via front end Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED