← Back to the catalogueOracle Database
Intermediate to Advanced
Level
Classroom . Online . Hybrid
Mode
Course overview
An Oracle Database course covering SQL, PL/SQL programming and core administration. The course covers Oracle-specific SQL and the PL/SQL language in depth cursors, packages, exceptions, bulk operations — then administration: architecture, storage, users, backup with RMAN and performance tuning.
Learners build a PL/SQL application layer and run backup and recovery exercises.
Who it is for
- Developers on Oracle systems
- Junior database administrators
- ERP and banking application support staff
- Analysts writing Oracle SQL
Prerequisites
Basic SQL knowledge.
How it runs
Learn → Practise → Build → Experience → Demonstrate, ending in a capstone. Delivered by practitioners from the engineering bench, in Madurai, Coimbatore and online.
Final project
Pl/SQL Application with Backup Plan
Programme sheet
The printed sheet carries the full module breakdown, labs, project work and certification path. Fees, dates and formats for the next intake are confirmed by the education team on enquiry.
Learning outcomes
01
Write Oracle SQL including analytic functions.
02
O3 _ Handle cursors, collections and bulk operations.
03
Manage tablespaces, users and privileges.
04
Move data with Data Pump.
05
Develop PL/SQL procedures, functions and packages.
06
Understand Oracle instance and storage architecture.
07
Back up and recover databases with RMAN.
08
Diagnose performance with execution plans and AWR basics.
Module structure
8 modulesData types . Joins . Set operators . Analytic functions . Hierarchical queries . MERGE . Sequences
Module 02
Pl/SQL Fundamentals
Blocks . Variables . Exceptions . Records
Module 03
Packages and Advanced Pl/SQL
Packages . Overloading . Bulk collect and FORALL . Dynamic SQL . Autonomous transactions . Triggers
Instance and database . SGA and PGA . Background processes . Redo and undo . Data dictionary
Module 05
Storage and Users
Tablespaces and datafiles . Users and profiles . Quotas . Segments and extents . Privileges and roles
Module 06
Backup and Recovery
Backup strategies . Full and incremental backups . Flashback features . RMAN configuration . Recovery scenarios
Data Pump export and import . SQL*Loader . External tables . Transportable tablespaces basics
Optimizer basics . Indexes and statistics . AWR and ADDM overview . Execution plans . SQL tuning advisor . Locking
Assessment & certification
Module assignments and labs
25%
Final project and review
40%
Learners who complete all modules, submit the final project and clear the review receive a course completion certificate from Kaizen Infinities Private Limited. Project work is documented for the learner's portfolio, and interview preparation is included in the closing sessions.
Career outcomes . Roles this programme prepares for
Oracle DeveloperPl/SQL DeveloperOracle DBA (junior)ERP Support EngineerDatabase Analyst
