651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Oracle Database Administration Fundamentals Virtual Classroom Live March 04, 2026

Price: $2,200

This course runs for a duration of 2 Days.

The class will run daily from 10 AM ET to 6 PM ET.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

This intensive boot camp prepares learners to perform entry-level Oracle DBA tasks. The course covers Oracle architecture, instance and storage management, user and privilege administration, undo, data movement, and Oracle networking tools. Labs reinforce skills with real Oracle environments.

Objectives:

  • Explain Oracle database architecture and processes 
  • Start, stop, and monitor Oracle instances 
  • Manage users, roles, privileges, and security profiles 
  • Create and manage tablespaces, datafiles, and undo 
  • Use Oracle diagnostic tools and performance views 
  • Move data with Data Pump and SQL*Loader 
  • Configure Oracle Net and use DBA tools (DBCA, EM, SQL*Plus) 

Audience:

  • Aspiring DBAs 
  • IT professionals supporting Oracle environments 

Course Overview

1) Oracle Architecture and Storage Foundations 

  • Oracle logical and physical structures 
  • Instance vs. database 
  • Memory (SGA, PGA) and background processes 
  • Data blocks, extents, segments, and tablespaces 

Lab 

  • Explore an Oracle instance and identify memory structures 
  • Query data dictionary views to examine storage structures 

2) Instance Management and Diagnostics 

  • Starting and stopping an instance (STARTUP, SHUTDOWN) 
  • Alert log, trace files, and Automatic Diagnostic Repository (ADR) 
  • Data dictionary and dynamic performance views 

Lab 

  • Start and stop the database in different modes 
  • Inspect alert logs and trace files 
  • Use ADRCI for diagnostics 
  • Query V$ views to monitor performance 

3) User, Role, and Privilege Administration 

  • Creating and managing users 
  • Roles and system/object privileges 
  • Resource limits and profiles 
  • Security best practices with least privilege 

Lab 

  • Create new users and assign quotas 
  • Define roles and grant/revoke privileges 
  • Configure profiles with resource limits 

4) Tablespace, Datafile, and Undo Management 

  • Creating and altering tablespaces 
  • Managing datafiles (add, resize, move, rename) 
  • Undo segments and undo retention 
  • Temporary undo 

Lab 

  • Create permanent and temporary tablespaces 
  • Resize and rename datafiles online 
  • Configure undo tablespace and retention policies 

5) Data Movement and Loading 

  • Oracle Data Pump (expdp, impdp) 
  • SQL*Loader for flat file loading 
  • External tables for fast access to external data 

Lab 

  • Export and import schemas with Data Pump 
  • Load data with SQL*Loader control files 
  • Query external tables and compare performance 

6) Oracle Tools and Net Services 

  • Using DBCA to create/manage databases 
  • Enterprise Manager Express/Cloud Control basics 
  • SQL*Plus and SQL Developer 
  • Oracle Net: listener configuration, naming methods, shared vs. dedicated servers 

Lab 

  • Configure and test a listener with Oracle Net Manager 
  • Connect to the database with SQL*Plus and SQL Developer 
  • Create a new database using DBCA 
  • Navigate EM Express to monitor instance activity 

Prerequisites