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
26 weeks · 700 contact hours (Theory · Lab · Clinical)
Big Data & ETL Testing
8 weeks · 120 contact hours
PSW · NACC Exam Prep
6 weeks · 90 contact hours
GED Math Preparation
10 weeks · 60 contact hours
Career Fundamentals
4 weeks · 32 contact hours
CompTIA A+ Certification
10 weeks · 120 contact hours
Data Warehousing
8 weeks · 96 contact hours
ITIL Foundation
5 weeks · 40 contact hours
Linux / Unix Administration
8 weeks · 96 contact hours
Management Essentials
6 weeks · 48 contact hours
Microsoft Office Productivity
5 weeks · 40 contact hours
Programming Foundations
10 weeks · 120 contact hours
SAP Essentials
6 weeks · 60 contact hours
Systems Analysis & Design
8 weeks · 80 contact hours