Database Testing Hybrid – Classroom + Online Training #: [QA204]

Wishlist Share

About Course

About Course

Database Testing [QA204] is a 36-clock-hour, short-term, non-degree training program that prepares students to earn the industry-recognized Oracle Database Program with PL/SQL certification (Exam 1Z0-149). The program combines database testing practices with Oracle PL/SQL programming. Students learn to validate data integrity and back-end logic, write and test PL/SQL blocks, cursors, exception handlers, stored procedures, functions, packages, and triggers, and perform end-to-end back-end testing.

Students learn through instructor-led instruction, demonstrations, hands-on labs in Oracle Database and SQL Developer, an end-to-end database testing project, and practice exams. The program ends with the Oracle 1Z0-149 exam, which is included in tuition.

Learning Objectives
Upon successful completion, students should be able to:

  • Explain structural, functional, and non-functional database testing and data-integrity validation.
  • Write PL/SQL blocks using variables, data types, and control structures.
  • Use SQL within PL/SQL, including DML and transaction control.
  • Work with records, collections, and explicit cursors.
  • Handle predefined and user-defined exceptions.
  • Create and test stored procedures, functions, packages, and triggers.
  • Perform back-end testing, data reconciliation, and verification of views, indexes, and constraints.
  • Demonstrate readiness for, and sit for, the Oracle Database Program with PL/SQL (1Z0-149) exam.

Program Information
Course Code: QA204
Duration: 36 Clock Hours
Delivery Method: Hybrid – Classroom + Online
Credential: Oracle Database Program with PL/SQL certification (Exam 1Z0-149), an industry-recognized certification issued by Oracle
Exam: One Oracle 1Z0-149 exam voucher is included in tuition. The exam is taken as the final component of the program.
Tuition: $1,990 total, including tuition, all course materials, and the Oracle 1Z0-149 exam fee. No additional costs.
Pathway: QA400 SQL (Oracle 1Z0-071) → QA204 Database Testing (Oracle 1Z0-149)
Related occupations: Database Administrators (SOC 15-1242); Software Quality Assurance Analysts and Testers (SOC 15-1253); Database Architects (SOC 15-1243)

Completion Requirements
To complete the program, students must:

  • Attend at least 80% of the 36 clock hours.
  • Complete all labs, the end-to-end database testing project, and the practice exam.
  • Sit for the Oracle 1Z0-149 exam.
  • Share their exam score report with AITE.

Students who meet these requirements receive an AITE Program Completion Record. The Oracle certification is earned only by passing the 1Z0-149 exam and is issued by Oracle.

Program Disclosure
This is a short-term, non-degree training program. Tuition includes one attempt at the Oracle 1Z0-149 exam. The certification is awarded by Oracle to students who pass the exam, and passing is not guaranteed. Retake fees, if needed, are the student’s responsibility. AITE does not guarantee employment, job placement, or salary. Oracle is a trademark of Oracle Corporation; AITE is an independent training provider.

Prerequisites
Completion of QA400 SQL or equivalent working knowledge of SQL (SELECT, joins, subqueries, and DML) is recommended.

Show More

What Will You Learn?

  • Database testing fundamentals: structural, functional, and non-functional testing
  • Data integrity, constraint, and relationship validation
  • SQL review for database testers
  • PL/SQL blocks, variables, data types, and control structures
  • SQL in PL/SQL and transaction control
  • Records, collections, and explicit cursors
  • Exception handling
  • Creating and testing stored procedures and functions
  • Packages and triggers
  • Dynamic SQL, bulk processing, and performance basics
  • Back-end testing and data reconciliation
  • Hands-on banking and healthcare database projects
  • Full-length practice exam and preparation for the Oracle 1Z0-149 exam

Course Content

Weekend 1: Database Testing Foundations & PL/SQL Fundamentals – 12 Clock Hours
Goal: Understand database testing and write PL/SQL blocks that query and validate data.

  • Course Orientation, 1Z0-149 Exam Overview & Oracle Setup (1 hr)
  • Database Testing Fundamentals (2 hrs)
  • SQL Review for Database Testers (2 hrs)
  • PL/SQL Fundamentals: Blocks, Variables & Data Types (2 hrs)
  • Control Structures: IF, CASE & Loops (2 hrs)
  • SQL in PL/SQL & Transaction Control (2 hrs)
  • Hands-On Lab: Data Validation Scripts (1 hr)

Weekend 2: Composite Types, Cursors, Exceptions & Subprograms – 12 Clock Hours
Goal: Build and test PL/SQL subprograms using records, collections, cursors, and exception handling.

Weekend 3: Packages, Triggers, Back-End Testing & Certification Exam – 12 Clock Hours
Goal: Work with packages and triggers, perform back-end testing, and sit for the Oracle 1Z0-149 exam.