Oracle
Oracle Database 19c Bootcamp — SQL, PL/SQL, DBA I–III
An intensive five-day bootcamp taking corporate IT staff from SQL fundamentals through PL/SQL to core database administration on Oracle Database 19c.
An intensive five-day bootcamp taking corporate IT staff from SQL fundamentals through PL/SQL to core database administration on Oracle Database 19c.
Every session is hands-on: participants work through guided labs, apply each module to realistic scenarios and leave with materials they can reuse at work.
Curriculum
- 01
Oracle architecture & tooling
Instances, databases, memory and process architecture; SQL*Plus, SQL Developer and the lab environment.
- 02
SQL essentials
Queries, joins, subqueries, set operators, aggregation and analytic functions.
- 03
Data definition & integrity
Tables, constraints, indexes, views, sequences and synonyms.
- 04
PL/SQL programming
Blocks, cursors, exception handling, procedures, functions, packages and triggers.
- 05
DBA I — installation & storage
Installing 19c, creating databases, tablespaces, datafiles and undo management.
- 06
DBA II — security & users
Users, roles, privileges, profiles and auditing.
- 07
DBA III — backup, recovery & tuning
RMAN backups, recovery scenarios, AWR and basic performance diagnostics.
Outcomes
- Write efficient SQL and PL/SQL against Oracle 19c
- Install and configure a 19c database from scratch
- Manage storage, users and security
- Back up and recover a database with RMAN