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

Oracle Database Foundations

2 Days

Description

This boot camp covers foundational knowledge of Oracle Database architecture, core components, backup, recovery, security, and basic administration. It’s ideal for new DBAs, IT professionals, or anyone preparing for Oracle’s 1Z0-006 Foundations exam. You will engage in hands-on labs to reinforce learning and apply concepts immediately.

Course Objectives

  • Describe Oracle Database architecture: instance, database, memory, processes
  • Understand storage structures: tablespaces, datafiles, control files, redo logs
  • Perform basic instance operations: startup, shutdown, manage logs
  • Apply security basics: users, privileges, roles, authentication
  • Explain backup, recovery, and basic data protection
  • Use Oracle tools (SQL*Plus, Enterprise Manager) for basic admin tasks

Audience:

  • New DBAs beginning their Oracle career path 
  • IT professionals who need foundational Oracle skills 
  • System administrators or support staff assisting with Oracle systems 

Upcoming Classes

Virtual Classroom Live
March 02, 2026
$2,095.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

1) Oracle Architecture & Components 

  • Difference between instance and database 
  • Memory structures (SGA, PGA) 
  • Background processes 
  • Physical files: datafiles, control files, redo logs 

Lab 

  • Query V$ and dictionary views to identify components 
  • Inspect the file structure of a running database 

2) Storage & Logical Structures 

  • Logical structures: tablespaces, segments, extents, blocks 
  • Types of tablespaces (SYSTEM, UNDO, TEMP, user) 
  • Datafile operations: add, resize, rename 

Lab 

  • Create and manage tablespaces 
  • Add and resize datafiles 
  • Map logical to physical structures 

3) Instance Operations & Logging 

  • Startup modes, shutdown modes 
  • Redo logs, archived redo logs 
  • Rollforward, recovery basics 
  • Alert log and trace files 

Lab 

  • Start and stop instance in various modes 
  • Simulate a log switch, archive logs 
  • Explore the alert log and trace directories 

4) User Security & Privileges 

  • Users, roles, system and object privileges 
  • Authentication methods 
  • Password policies, default roles 

Lab 

  • Create users and roles 
  • Grant and revoke privileges 
  • Configure authentication mode 

5) Backup & Recovery Fundamentals 

  • Recovery concepts: complete, incomplete recovery 
  • Recovery tools overview (RMAN, user-managed) 
  • Data protection modes 

Lab 

  • Simulate basic backup and restore (user-managed) 
  • Recover a database to a point in time 

6) Tools & Administration Interfaces 

  • SQL*Plus, SQL Developer basics 
  • Enterprise Manager basics 
  • Data dictionary and catalog views 

Lab 

  • Use SQL*Plus to query, create objects, run scripts 
  • Use EM to view database status 
  • Explore data dictionary views 

Upcoming Classes

Virtual Classroom Live
March 02, 2026
$2,095.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Basic relational database knowledge
Familiarity with SQL queries recommended
General IT knowledge of operating systems and file management

Upcoming Classes

Virtual Classroom Live
March 02, 2026
$2,095.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

NOTE: This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. 

Upcoming Classes

Virtual Classroom Live
March 02, 2026
$2,095.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date


About us

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more

Find a Course

Corporate Services

Contact us

follow us on social media: