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.
Course Content
Weekend 1: Database Testing Foundations & PL/SQL Fundamentals – 12 Clock Hours
-
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)
