Database Testing Online Training Course Overview :

Introduction

• What is RDBMS?
• What is a database application?
• Why should we test databases?
• Back end vs. front end testing
• Testing application vs. testing RDBMS
• Writing and setting up database tests
• Using SQL* Plus
• Introduction to Oracle PL/SQL

Oracle Data Access

• SELECT Statements
• Specific Data Retrieval using WHERE Clause
• Row Identifiers and Numbers
• Performing Arithmetic
• DISTINCT Values
• Value Comparison
• SQL Operators: LIKE, IN, BETWEEN
• ORDER BY Clause
• Join Conditions and Join Types

Oracle Functions in Database Testing Tutorial

• Single Row Functions
• Aggregate Functions
• Grouping Rows using GROUP BY and HAVING Clause
• Storing and Processing DATE and TIME
• Using Timestamp and Time Intervals

Subqueries and Advanced Queries

• Single Row Subqueries
• Multiple Row Subqueries
• Correlated Subqueries
• Nested Subqueries
• Using SET Operators
• TRANSALTE() Function
• DECODE() Function
• CASE Expression
• Hierarchical Queries

Oracle Data Manipulation Language (DML)

• Adding Rows using INSERT Statement
• Modifying Rows using UPDATE Statement
• The RETURNING Clause
• Removing Rows using DELETE Statement
• Data Integrity – Primary & Foreign key
• Merging Rows using MERGE
• Database Transactions – COMMIT, ROLLBACK

Oracle Data Definition Language (DDL): Database Testing Tutorial

• Tables – Create, Alter, Rename, Truncate, Drop
• Sequences – Create, Retrieve, Use, Modify, Drop
• Index – Create, Retrieve, Modify, Drop
• Views – Create, Use, Modify, Drop

Users, Privileges, Roles in Database Online Training

• Users – Create, Change Password, Delete
• System Privileges
• Object Privileges
• Roles – Create, Drop
• Data Control Language (DCL) – Grant, Revoke

Introduction to PL/SQL :

• Block Structure
• Variables and Types
• Conditional Logic
• Loops
• Cursors
• Exceptions
• Procedures
• Functions
• Packages
• Triggers