Oracle Database Essentials
Oracle Database Essentials — SQL, PL/SQL and Administration Foundations
Foundational fluency in the database that still runs much of Canadian banking, insurance, and government.
A practitioner-led course covering Oracle SQL fundamentals, PL/SQL programming, and the foundations of database administration. Hands-on labs use Oracle XE so students can replicate everything at home. Pairs especially well with our Big Data / ETL Testing program for QA and data engineering pathways.
What makes this programme worth your time.
Real Oracle, Not a Toy
All labs run on Oracle XE — what you learn is portable straight into enterprise environments.
SQL Then PL/SQL
We teach SQL until it is second nature, then layer PL/SQL programming on top.
DBA Foundations
A practical introduction to user management, tablespaces, and backup basics.
A careful progression, in four modules.
Module I · Oracle SQL Foundations
- —SELECT, joins, aggregation
- —Subqueries and set operators
- —Analytics functions
Module II · Advanced SQL
- —Window functions
- —Hierarchical queries
- —Performance basics
Module III · PL/SQL Programming
- —Anonymous blocks
- —Procedures, functions, packages
- —Cursors and exceptions
Module IV · DBA Foundations
- —Users and privileges
- —Tablespaces and storage
- —Backup, restore, and basics of tuning
Other programmes in the catalogue.
Personal Support Worker
700 contact hours (Theory · Lab · Clinical)
Big Data & ETL Testing
35 contact hours
PSW · NACC Exam Prep
35 contact hours
GED Math Preparation
38 contact hours
Career Fundamentals
32 contact hours
CompTIA A+ Certification
38 contact hours
Data Warehousing
35 contact hours
ITIL Foundation
40 contact hours
Linux / Unix Administration
40 contact hours
Management Essentials
40 contact hours
Microsoft Office Productivity
40 contact hours
Programming Foundations
40 contact hours
SAP Essentials
35 contact hours
Systems Analysis & Design
35 contact hours