Download Full Outline
Course
Oracle Database Administration Fundamentals
CompTIA Certified Badge
This intensive boot camp prepares learners to perform entry-level Oracle DBA tasks
ID:TTOR20520
Duration:2 Days
Level:Introductory
Format:

Upcoming Public Course Dates

Class Schedule
Group Training
Special Offers

Connect with Our Team Today!

  • Bring this or any training to your Organization
  • Full-Scale program development
  • Delivered when, where, and how you want
  • Blended learning models
  • Tailored content
  • Expert team coaching
Request a Quote / Connect with Our Team / More Info

25%
OFF

Limited Time Promo!

Boost your productivity and stay ahead of the curve with 25% off MSRP on select AI courses built for business professionals. Learn practical, hands-on skills to work smarter with AI— no coding or prior experience required.

Save All Year With Our Year Round Promos

  • Special Pricing for Government & Military Personnel
  • Team Training Discounts
  • Corporate Discounts
  • Referral Discounts
  • & Much More!

What You'll Learn

Overview
Objectives
Audience
Pre-Reqs
Agenda
Follow On
Related
Expand All

Overview

CompTIA Authorized Partner Badge

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 

Pre-Requisites

  • Basic relational database knowledge
  • Familiarity with SQL and OS commands
Oracle Database Foundations

Agenda

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 

Follow On Courses

Oracle DBA II Mastery: Advanced Administration & Recovery

Related Courses

Oracle PL/SQL Fundamentals

Connect with us

Tailor your learning experience with Trivera Tech. Whether you need a custom course offering or want to schedule a specific date and time for corporate training, we are here to help. Our team works with you to design a solution that fits your organization's unique needs; whether that is enrolling a small team or your entire department. Simply let us know how many participants you'd like to enroll and the skills you want to develop, and we will provide a detailed quote tailored to your request.

Contact Trivera Today to discuss how we can deliver personalized training that equips your team with the critical skills needed to succeed!