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

  1. 01

    Oracle architecture & tooling

    Instances, databases, memory and process architecture; SQL*Plus, SQL Developer and the lab environment.

  2. 02

    SQL essentials

    Queries, joins, subqueries, set operators, aggregation and analytic functions.

  3. 03

    Data definition & integrity

    Tables, constraints, indexes, views, sequences and synonyms.

  4. 04

    PL/SQL programming

    Blocks, cursors, exception handling, procedures, functions, packages and triggers.

  5. 05

    DBA I — installation & storage

    Installing 19c, creating databases, tablespaces, datafiles and undo management.

  6. 06

    DBA II — security & users

    Users, roles, privileges, profiles and auditing.

  7. 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