Course Information
Course Overview
A complete, hands-on learning path to become a professional Oracle Database Administrator
Do you want to become a professional Oracle Database Administrator (DBA) but are not sure where to start?
This course is designed to take you from beginner level to professional Oracle DBA, using a clear, structured, and hands-on learning approach. It is based on more than 20 years of real-world Oracle DBA experience and extensive training experience delivering Oracle DBA courses since 2016.
No matter your current level of Oracle database knowledge, this course starts from the fundamentals and gradually builds your skills to a professional level. Concepts are explained in depth and immediately followed by practical exercises that reflect real-world DBA tasks. You will build a local virtual lab environment on your own computer and perform Oracle DBA activities on Linux and Windows platforms.
Each practical exercise is supported by:
Step-by-step downloadable guides
Full video demonstrations
Instructor support to help you overcome implementation challenges
By the end of this course, you will be able to:
Create and manage Oracle databases
Implement backup and recovery strategies
Administer Oracle database storage
Apply patches and perform database upgrades
Manage Oracle Multitenant environments
Troubleshoot common Oracle database issues
Deploy Oracle Restart configurations
Perform fundamental Oracle database performance tuning tasks
The course labs are built using Oracle Database 19c, while also covering key differences across 11g, 12c, 18c, and 19c. You will also practice upgrading an Oracle database from 19c to 21c.
Starting from RDBMS fundamentals and Oracle architecture, this course covers all essential DBA topics, including:
Oracle database installation and creation
Core database administration
User and security management
Database connectivity
Multitenant architecture
Backup and recovery
Patching and upgrades
Oracle Automatic Storage Management (ASM)
This course offers a clear, structured alternative to fragmented tutorials and expensive corporate training, providing a complete learning path to become a confident Oracle DBA.
Enroll now and start your journey toward becoming a skilled Oracle Database Administrator.
Course Content
- 26 section(s)
- 215 lecture(s)
- Section 1 Introduction
- Section 2 Preparing Course Practice Environment
- Section 3 Introduction to RDBMS
- Section 4 Database Architecture
- Section 5 Installing and Creating Oracle Databases
- Section 6 Oracle Database Basic Administration
- Section 7 Fundamentals of Oracle Database Multitenancy
- Section 8 Managing Oracle Database Components
- Section 9 Managing Database Segments
- Section 10 Managing Database Users and Security
- Section 11 Managing Database Connectivity
- Section 12 Configuring Shared Server
- Section 13 Managing Fast Recovery Area and Redo Log
- Section 14 Taking Backups in Oracle Databases
- Section 15 Database Recovery
- Section 16 Using RMAN in Multitenant Databases
- Section 17 More about using RMAN
- Section 18 Flashback Database
- Section 19 Using Oracle Database Utilities
- Section 20 Using the Scheduler
- Section 21 Using ADR Command Interpreter
- Section 22 Applying Patches on Oracle Databases
- Section 23 Automatic Storage Management (ASM)
- Section 24 Upgrading Oracle Databases
- Section 25 Course Material
- Section 26 Bonus Section
What You’ll Learn
- Create Oracle databases on Linux and Windows platforms, Perform fundamental DBA tasks on Oracle databases, Manage Oracle database files, Manage database storage structures, Manage database multitenancy, Implement backup and recovery plans, Apply patches and upgrade databases, Deploy Oracle Restart configuration, Troubleshoot Oracle database issues
Skills covered in this course
Reviews
-
PPreston Orimwesiga
knowledgeable & excellent instructor. very elaborate
-
PPrasad Gaikwad
Good
-
LLuca Xu
Interesting build a good foundation for oracle dba theory and practice
-
GGourav singh
Very useful course with deep knowledge.