What is RDBMS & Backend Testing?

  • 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
  • Introduction to MySQL
  • How to use Toad in for backend testing
  • Use of MS Excel for data validation

Database 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

 

Database Functions

  • 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

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

Data Definition Language (DDL)

  • 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

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