Oracle Database Administration
- Buy now
- Learn more
Course Materials
1. Slides
2. Lab Guide
LESSON 1: Introduction to DBMS and RDBMS
1. Overview of DBMS, RDBMS
LESSON 2: Introduction to Oracle Database Server
LESSON 3: Architecture of Oracle Database Server
Overview of Oracle Database Installation
1. Overview of Oracle Database Installation
Creating Linux VM
Installing Oracle Database
Post Installation Tasks
Data Dictionary
1. About Data Dictionary
2. Lab Practices
Managing Database Startup and Shutdown
Managing Initialization Parameters
1. Managing Initialization Parameters
2. Lab Practice: Managing Initialization...
Managing Diagnostic Data
Managing Tablespaces and Data Files
Managing Temporary Tablespaces
1. Overview of Managing Temporary Tables...
2. Lab Practices: Managing Temporary Tab...
Managing Undo Tablespaces
Managing Control Files
Managing Redo Log
Managing Archive Log
1. Overview of Archive Log Mode
2. Lab Practices: Archive Log
Oracle Managed Files (OMF)
User Administration
Profiles Administration
1. Overview of Profiles
2. Lab Practices: Using Profiles
Privileges and Roles
1. Managing Database Privileges and Roles
Oracle Net Services
Recovery Manager (RMAN)
Flashback Features
Oracle Data Pump
1. Overview of Oracle Data Pump
2. Lab Practices: Using Data Pump
Patching
1. Updating Software using Patches
2. Links to download Patch files
Upgrading
1. Upgrading the Database
Multitenant Container Database Administration
1. Creating Container Database
2. Administering Container Database

Responsibilities of Oracle DBA