VOOZH about

URL: https://www.coursera.org/learn/packt-advanced-oracle-database-administration-5d9rn

⇱ Advanced Oracle Database Administration | Coursera

Advanced Oracle Database Administration

Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Gain insight into a topic and learn the fundamentals.
Advanced level

Recommended experience

1 week to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Advanced level

Recommended experience

1 week to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Master RMAN for backup, recovery, and duplication in multitenant databases.

  • Utilize Oracle utilities like Data Pump and SQL Loader for efficient data management.

  • Implement ASM for optimized storage and configure Flashback Database for point-in-time recovery.

  • Upgrade Oracle databases and apply critical patches with confidence.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

10 assignments

Taught in English

Build your subject-matter expertise

This course is part of the Oracle Database Administration from Zero to Hero Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 9 modules in this course

Dive deep into advanced Oracle database administration with this comprehensive course. You'll gain mastery over RMAN operations, database duplication, flashback recovery, and patch management, all critical for ensuring database resilience and efficiency. With hands-on labs, you'll build practical skills in backup, recovery, and automation techniques.

The course begins with an in-depth exploration of RMAN in multitenant environments, guiding you through backup and recovery in CDBs and PDBs. You'll practice RMAN commands, database duplication methods, and recovery scenarios, gaining a robust foundation in advanced backup solutions. Next, you'll delve into utilities like Oracle Data Pump and SQL Loader, enabling efficient data movement and management. Moving further, you'll explore automatic storage management (ASM), scheduler automation, and ADR diagnostic tools, empowering you to streamline storage and troubleshoot effectively. The course also covers applying database patches and performing upgrades, ensuring you're prepared to manage the latest Oracle environments confidently. Designed for experienced DBAs, this course is perfect for those looking to elevate their expertise in Oracle database administration. Prerequisites include a solid understanding of Oracle database fundamentals and experience in basic database management.

In this module, we will explore the advanced usage of RMAN in Oracle Multitenant Databases. This includes backup and recovery strategies tailored for CDBs and PDBs, practical exercises to apply these skills, and techniques for duplicating databases in various scenarios. You’ll gain expertise in recovery operations and automation techniques, enhancing your multitenant database management capabilities.

What's included

10 videos2 readings1 assignment

10 videos•Total 84 minutes
  • Introducing the Section•0 minutes
  • Using RMAN in Oracle Multitenant Databases•13 minutes
  • Practice - Using RMAN in Oracle Multitenant Databases (Part 1 of 2)•8 minutes
  • Practice - Using RMAN in Oracle Multitenant Databases (Part 2 of 2)•9 minutes
  • Duplicating a Database Using RMAN - Part I (1 of 3)•6 minutes
  • Duplicating a Database Using RMAN - Part I (2 of 3)•5 minutes
  • Duplicating a Database Using RMAN - Part I (3 of 3)•10 minutes
  • Duplicating a Database Using RMAN - Part II (1 of 2)•7 minutes
  • Duplicating a Database Using RMAN - Part II (2 of 2)•14 minutes
  • Practice - Duplicating Databases and PDBs Using RMAN•11 minutes
2 readings•Total 20 minutes
  • Introduction to the Course 'Advanced Oracle Database Administration'•10 minutes
  • Full Specialization Resources•10 minutes
1 assignment•Total 15 minutes
  • Assessment 1•15 minutes

In this module, we will delve deeper into RMAN's advanced features, including the Recovery Catalog and the Data Recovery Advisor. You’ll learn to streamline backup and recovery tasks with stored scripts, manage recovery catalogs, and utilize the Data Recovery Advisor for proactive issue resolution. Hands-on exercises will reinforce your understanding of these critical tools for database resilience.

What's included

7 videos1 assignment

7 videos•Total 58 minutes
  • Using RMAN Recovery Catalog (Part 1 of 3)•7 minutes
  • Using RMAN Recovery Catalog (Part 2 of 3)•8 minutes
  • Using RMAN Recovery Catalog (Part 3 of 3)•11 minutes
  • Practice - Using RMAN Recovery Catalog•9 minutes
  • Using Data Recovery Advisor (Part 1 of 2)•7 minutes
  • Using Data Recovery Advisor (Part 2 of 2)•12 minutes
  • Practice - Using Data Recovery Advisor•3 minutes
1 assignment•Total 15 minutes
  • Assessment 2•15 minutes

In this module, we will explore Oracle's Flashback Database feature, which allows you to perform rapid point-in-time recoveries. You will learn how to configure Flashback Database, execute Flashback operations, and manage restore points. Through practical exercises, you’ll gain hands-on experience to confidently use Flashback for minimizing downtime during recovery scenarios.

What's included

3 videos1 assignment

3 videos•Total 26 minutes
  • Introducing the Section•0 minutes
  • Flashback Database•18 minutes
  • Practice - Performing Flashback Database•7 minutes
1 assignment•Total 15 minutes
  • Assessment 3•15 minutes

In this module, we will explore essential Oracle database utilities, including Data Pump, SQL Loader, and External Tables. You’ll gain a comprehensive understanding of these tools to streamline data movement and access external data. Hands-on practice will enable you to master these utilities for real-world data management challenges.

What's included

12 videos1 assignment

12 videos•Total 165 minutes
  • Introducing the Section•0 minutes
  • Using Oracle Data Pump (Part 1 of 3)•14 minutes
  • Using Oracle Data Pump (Part 2 of 3)•18 minutes
  • Using Oracle Data Pump (Part 3 of 3)•20 minutes
  • Practice - Using Oracle Data Pump•17 minutes
  • Using SQL Loader (Part 1 of 4)•12 minutes
  • Using SQL Loader (Part 2 of 4)•12 minutes
  • Using SQL Loader (Part 3 of 4)•12 minutes
  • Using SQL Loader (Part 4 of 4)•15 minutes
  • Practice - Using SQL Loader•19 minutes
  • Using External Tables•12 minutes
  • Practice - Using External Tables•12 minutes
1 assignment•Total 15 minutes
  • Assessment 4•15 minutes

In this module, we will focus on automating database tasks using Oracle Scheduler. You’ll learn to create and manage scheduled jobs, set up custom workflows, and monitor their execution. Practical exercises will enhance your ability to automate and optimize routine database operations effectively.

What's included

2 videos1 assignment

2 videos•Total 33 minutes
  • Automating Tasks with the Scheduler•23 minutes
  • Practice - Automating Tasks with the Scheduler•10 minutes
1 assignment•Total 15 minutes
  • Assessment 5•15 minutes

In this module, we will explore the ADR Command Interpreter (ADRCI) and its role in diagnosing Oracle database issues. You’ll gain hands-on experience in analyzing incidents, packaging diagnostic data, and maintaining the ADR repository to ensure database stability and performance.

What's included

3 videos1 assignment

3 videos•Total 43 minutes
  • Introducing the Section•0 minutes
  • Using ADR Command Interpreter•28 minutes
  • Practice - Using ADR Command Interpreter•14 minutes
1 assignment•Total 15 minutes
  • Assessment 6•15 minutes

In this module, we will cover the process of applying patches to Oracle databases. You’ll learn to identify patch types, understand patching strategies, and perform patch application using OPatch. Practical exercises will guide you in maintaining database security and stability through proper patch management.

What's included

5 videos1 assignment

5 videos•Total 67 minutes
  • Introducing the Section•1 minute
  • Patching Oracle Databases (1 of 3)•13 minutes
  • Patching Oracle Databases (2 of 3)•12 minutes
  • Patching Oracle Databases (3 of 3)•22 minutes
  • Practice - Applying RU Patches on Oracle Databases•20 minutes
1 assignment•Total 15 minutes
  • Assessment 7•15 minutes

In this module, we will explore Automatic Storage Management (ASM), Oracle’s high-performance storage management solution. You’ll learn to configure and manage ASM environments, migrate databases to ASM, and perform essential maintenance tasks. Hands-on practice will prepare you to leverage ASM for efficient and reliable database storage management.

What's included

9 videos1 assignment

9 videos•Total 104 minutes
  • Introducing the Section•1 minute
  • Introducing Automatic Storage Management (Part 1 of 3)•10 minutes
  • Introducing Automatic Storage Management (Part 2 of 3)•17 minutes
  • Introducing Automatic Storage Management (Part 3 of 3)•22 minutes
  • Practice - Creating Oracle Database with ASM (Part 1 of 4)•10 minutes
  • Practice - Creating Oracle Database with ASM (Part 2 of 4)•11 minutes
  • Practice - Creating Oracle Database with ASM (Part 3 of 4)•9 minutes
  • Practice - Creating Oracle Database with ASM (Part 4 of 4)•14 minutes
  • Practice - Applying RU Patches on Oracle Restart•11 minutes
1 assignment•Total 15 minutes
  • Assessment 8•15 minutes

In this module, we will focus on upgrading Oracle databases to newer versions. You’ll explore different upgrade methods, prepare databases for upgrades, and perform hands-on exercises to upgrade both databases and grid infrastructure. This module will equip you with the skills needed for successful Oracle database upgrades.

What's included

5 videos1 reading2 assignments

5 videos•Total 61 minutes
  • Introducing the Section•1 minute
  • Upgrading Oracle Databases (Part 1 of 2)•18 minutes
  • Upgrading Oracle Databases (Part 2 of 2)•15 minutes
  • Practice - Upgrading Oracle Database•19 minutes
  • Practice - Upgrading Oracle Grid Infrastructure•9 minutes
1 reading•Total 10 minutes
  • Conclusion to the Course 'Advanced Oracle Database Administration'•10 minutes
2 assignments•Total 75 minutes
  • Assessment 9•15 minutes
  • Full Course Assessment•60 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Offered by

Explore more from Data Management

Why people choose Coursera for their career

👁 Image

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
👁 Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
👁 Image

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
👁 Image

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

This course is currently available only to learners who have paid or received financial aid, when available.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Financial aid available,