Oracle Database Administration from Zero to Hero

Preview this course

In this comprehensive course, we will guide you through the world of Oracle Database Administration, starting from the basics and equipping you with the skills to create databases, manage storage, implement backup plans, apply patches, troubleshoot issues, and excel in the role of a professional DBA.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
220 on-demand videos & exercises
Level: Beginner
English
36hrs 1mins
Access on mobile, web and TV

What to know about this course

In this course, we cover a wide range of topics to ensure you have a solid understanding of Oracle database administration. Starting with an introduction to Oracle databases, you will learn how to create databases on both Linux and Windows platforms.

We will guide you through fundamental DBA tasks, including managing database files, storage structures, and users. As you progress, you will delve into more advanced topics such as managing database multitenancy, implementing backup and recovery plans, and applying patches and upgrades. We will also provide in-depth coverage of Oracle’s Automatic Storage Management (ASM) and Oracle Restart configuration, giving you a comprehensive understanding of these critical components. Practical exercises form an integral part of the course, allowing you to apply your knowledge in real-world scenarios.
You will gain hands-on experience with tasks such as creating a tablespace in ASM, installing Oracle database software, and performing database upgrades. Step-by-step instructions and downloadable resources ensure a seamless learning experience.

By the end of this course, you will have the skills to confidently manage Oracle databases, troubleshoot issues, and optimize performance.

Who's this course for?

This course is designed for IT graduates and individuals who aspire to become professional Oracle Database Administrators (DBAs).

Whether you have limited knowledge or no experience in Oracle databases, this course is tailored to guide you from beginner to proficient level.

No prior experience in Oracle database administration is required. We provide step-by-step instructions to help you install and set up Oracle databases on your PC, making it accessible for anyone eager to learn. All you need is a PC with Windows 10 or 11 (64-bit), 16 GB of RAM, and 110 GB of free HDD space.


What you'll learn

  • Create Oracle databases on Linux and Windows platforms
  • Perform fundamental DBA tasks on Oracle databases
  • Manage Oracle database files and database storage structures
  • Implement backup and recovery plans
  • Apply patches and upgrade databases
  • Deploy Oracle Restart configuration

Key Features

  • Practical exercises with step-by-step documentation for easy implementation
  • Emphasis on real-world scenarios and hands-on experience on Linux and Windows platforms
  • Coverage of essential topics including backup and recovery, patching, and multitenancy

Course Curriculum

About the Author

Ahmed Baraka

Ahmed Baraka has 25 years of extensive experience in the computer industry, with a focus on Oracle database administration technologies used in complex and high-availability environments. Baraka’s expertise is designing and maintaining database solutions for complex business needs using a wide selection of technologies, such as Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. He has worked with international firms in Australia and Abu Dhabi. His hobbies are soccer (football) and listening to soft music.