Oracle

Oracle Database Administration I (1Z0-082)

Exam-aligned Oracle Database Administration I programme, including an advanced edition focused on automating routine DBA work.


Exam-aligned Oracle Database Administration I programme, including an advanced edition focused on automating routine DBA work.

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

    Database architecture

    Instance and database structures, memory and background processes.

  2. 02

    Managing instances

    Startup and shutdown modes, parameter files, alert logs and trace files.

  3. 03

    Networking

    Listener configuration, naming methods and connectivity troubleshooting.

  4. 04

    Users & security

    Accounts, privileges, roles, profiles and quotas.

  5. 05

    Storage structures

    Tablespaces, segments, extents, blocks and space management.

  6. 06

    Data movement

    SQL*Loader, external tables and Data Pump.

  7. 07

    Automation edition

    Scheduling, shell and PL/SQL scripts to automate routine checks and maintenance.

Outcomes

  • Cover every 1Z0-082 exam objective
  • Practise with a 150-question certification-style bank
  • Automate routine administration tasks