When will I receive my 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.

Why can’t I audit this course?

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

Is financial aid 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.

Intermediate Oracle Database Administration

Intermediate Oracle Database Administration

This course is part of Oracle Database Administration from Zero to Hero Specialization

Instructor: Packt - Course Instructors

Included with

Learn more

8 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

8 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Configure and manage Oracle Database memory and storage structures for optimal performance.
Implement advanced user management, including privileges, roles, and profiles.
Master Oracle RMAN for comprehensive backup and recovery strategies.
Enhance database connectivity and security using advanced configurations and best practices.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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 8 modules in this course

Unlock the full potential of Oracle Database with this intermediate-level course. Designed for aspiring database administrators and professionals, this course equips you with the skills to efficiently manage Oracle Database components, storage structures, users, and security. Master advanced memory management, optimize database connectivity, and dive deep into the Fast Recovery Area (FRA) and redo log configurations.

The journey begins with foundational concepts, such as database memory management and tablespaces, complemented by hands-on practice. You'll progress to mastering user privileges, roles, and profiles, ensuring robust database security. Advanced storage techniques, including segment management and table compression, are covered to help you optimize performance and reduce storage costs. In the later modules, you'll gain expertise in backup and recovery strategies using RMAN, implement incremental backups, and understand Point-in-Time Recovery (PITR). Comprehensive practice exercises ensure that you apply these concepts in real-world scenarios, preparing you for operational challenges. Ideal for professionals with basic Oracle database knowledge, this course is essential for those looking to enhance their administration skills. Whether you're a budding DBA or a seasoned IT professional, this course is your step toward mastering Oracle Database management.

In this module, we will explore the fundamental and advanced aspects of managing Oracle database components. Topics include memory management concepts, storage structures, and managing tablespaces, data files, undo data, and resumable space allocation. With a combination of theoretical insights and hands-on practice, you'll gain proficiency in essential administrative tasks for optimizing Oracle database performance and reliability.

What's included

23 videos2 readings1 assignment

23 videos Total 219 minutes

Introducing the Section 1 minute
Database Memory Concepts (Part 1 of 2) 8 minutes
Database Memory Concepts (Part 2 of 2) 11 minutes
Managing Database Memory (Part 1 of 2) 13 minutes
Managing Database Memory (Part 2 of 2) 9 minutes
Practice - Managing Database Memory (Part 1 of 2) 7 minutes
Practice - Managing Database Memory (Part 2 of 2) 5 minutes
Database Storage Structures 9 minutes
Managing Tablespaces (Part 1 of 4) 15 minutes
Managing Tablespaces (Part 2 of 4) 9 minutes
Managing Tablespaces (Part 3 of 4) 13 minutes
Managing Tablespaces (Part 4 of 4) 9 minutes
Practice - Managing Tablespaces (Part 1 of 2) 12 minutes
Practice - Managing Tablespaces (Part 2 of 2) 5 minutes
Managing Data Files 9 minutes
Practice - Managing Data Files 12 minutes
Managing Resumable Space Allocation (Part 1 of 2) 10 minutes
Managing Resumable Space Allocation (Part 2 of 2) 8 minutes
Practice - Managing Resumable Space Allocation 5 minutes
Managing Undo Data (Part 1 of 3) 15 minutes
Managing Undo Data (Part 2 of 3) 10 minutes
Managing Undo Data (Part 3 of 3) 10 minutes
Practice - Managing Undo Data 14 minutes

2 readings Total 20 minutes

Introduction to the Course 'Intermediate 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 into the intricacies of managing database segments, including shrinking segments, deferred segment creation, and table compression techniques. You will learn how to optimize storage and improve database performance, reinforced through hands-on practice scenarios.

What's included

9 videos1 assignment

9 videos Total 61 minutes

Introducing the Section 1 minute
Shrinking Segments (Part 1 of 2) 10 minutes
Shrinking Segments (Part 2 of 2) 10 minutes
Practice - Shrinking Segments 7 minutes
Using Deferred Segment Creation 5 minutes
Practice - Using Deferred Segment Creation 5 minutes
Using Table Compression (Part 1 of 2) 8 minutes
Using Table Compression (Part 2 of 2) 8 minutes
Practice - Using Table Compression 7 minutes

1 assignment Total 15 minutes

Assessment 2 15 minutes

In this module, we will focus on managing database users and securing Oracle databases. You will explore user roles, privileges, profiles, and authentication methods. Hands-on practice will enhance your ability to manage users, roles, and implement best practices for database security.

What's included

21 videos1 assignment

21 videos Total 245 minutes

Introducing the Section 1 minute
Managing Database Users (Part 1 of 2) 11 minutes
Managing Database Users (Part 2 of 2) 14 minutes
Managing User Privileges (Part 1 of 2) 12 minutes
Managing User Privileges (Part 2 of 2) 14 minutes
Managing Roles (Part 1 of 2) 15 minutes
Managing Roles (Part 2 of 2) 12 minutes
Managing User Profiles (Part 1 of 2) 16 minutes
Managing User Profiles (Part 2 of 2) 10 minutes
Practice - Managing Users and User Security (Part 1 of 2) 12 minutes
Practice - Managing Users and User Security (Part 2 of 2) 5 minutes
Managing Local and Common Users 14 minutes
Querying Container Data Objects 13 minutes
Practice - Managing Local and Common Users (Part 1 of 2) 12 minutes
Practice - Managing Local and Common Users (Part 2 of 2) 10 minutes
Applying the Principle of Least Privileges 6 minutes
Administrative Accounts and Privileges 16 minutes
Using OS Authentication (Part 1 of 2) 17 minutes
Using OS Authentication (Part 2 of 2) 8 minutes
Using Password File Authentication 14 minutes
Practice - Using Database Authentication Methods 13 minutes

1 assignment Total 15 minutes

Assessment 3 15 minutes

In this module, we will explore the configuration and management of Oracle database connectivity. You will learn about Oracle Net, naming methods, and database links, gaining practical skills to ensure seamless database communication and troubleshooting.

What's included

12 videos1 assignment

12 videos Total 104 minutes

Introducing the Section 0 minutes
Configuring Oracle Network Environment (Part 1 of 4) 13 minutes
Configuring Oracle Network Environment (Part 2 of 4) 13 minutes
Configuring Oracle Network Environment (Part 3 of 4) 8 minutes
Configuring Oracle Network Environment (Part 4 of 4) 12 minutes
Practice - Configuring Oracle Network Environment (Part 1 of 4) 11 minutes
Practice - Configuring Oracle Network Environment (Part 2 of 4) 8 minutes
Practice - Configuring Oracle Network Environment (Part 3 of 4) 6 minutes
Practice - Configuring Oracle Network Environment (Part 4 of 4) 9 minutes
Using Database Links (Part 1 of 2) 8 minutes
Using Database Links (Part 2 of 2) 9 minutes
Practice - Using Database Links 6 minutes

1 assignment Total 15 minutes

Assessment 4 15 minutes

In this module, we will examine the shared server architecture and learn how to configure it for efficient resource utilization. Hands-on practice will help you configure shared server processes, monitor their performance, and troubleshoot common issues.

What's included

5 videos1 assignment

In this module, we will explore managing the Fast Recovery Area (FRA) and redo logs, crucial components of database recovery. Through theory and practice, you will learn to configure redo logs, manage archived logs, and enable ARCHIVELOG mode to enhance database resilience.

What's included

10 videos1 assignment

10 videos Total 81 minutes

Introducing the Section 1 minute
Managing the Fast Recovery Area 11 minutes
Practice - Managing the Fast Recovery Area 5 minutes
Managing the Redo Log (Part 1 of 4) 10 minutes
Managing the Redo Log (Part 2 of 4) 9 minutes
Managing the Redo Log (Part 3 of 4) 13 minutes
Managing the Redo Log (Part 4 of 4) 5 minutes
Managing the Archived Redo Log Files (Part 1 of 2) 11 minutes
Managing the Archived Redo Log Files (Part 2 of 2) 10 minutes
Practice - Enabling the ARCHIVELOG Mode 6 minutes

1 assignment Total 15 minutes

Assessment 6 15 minutes

In this module, we will cover Oracle database backup strategies using RMAN. You will learn to perform full and incremental backups, configure persistent settings, and automate backup jobs. Hands-on practice will solidify your backup management skills for data protection.

What's included

18 videos1 assignment

18 videos Total 150 minutes

Introducing the Section 1 minute
Introducing Backup and Recovery 13 minutes
Introduction to RMAN (Part 1 of 3) 10 minutes
Introduction to RMAN (Part 2 of 3) 8 minutes
Introduction to RMAN (Part 3 of 3) 9 minutes
Practice - Introducing RMAN 9 minutes
Performing RMAN Full Backups - Part I (1 of 2) 10 minutes
Performing RMAN Full Backups - Part I (2 of 2) 10 minutes
Practice - Performing RMAN Full Backups - Part I (1 of 2) 7 minutes
Practice - Performing RMAN Full Backups - Part I (2 of 2) 8 minutes
Performing RMAN Full Backups - Part II (1 of 3) 6 minutes
Performing RMAN Full Backups - Part II (2 of 3) 9 minutes
Performing RMAN Full Backups - Part II (3 of 3) 7 minutes
Practice - Performing RMAN Backups - Part II 9 minutes
Performing Incremental Backups (1 of 3) 8 minutes
Performing Incremental Backups (2 of 3) 9 minutes
Performing Incremental Backups (3 of 3) 6 minutes
Practice - Performing Incremental Backups 13 minutes

1 assignment Total 15 minutes

Assessment 7 15 minutes

In this module, we will focus on database recovery strategies using RMAN. Topics include configuring persistent settings, performing full recovery, and automating recovery processes. Practical exercises will enable you to handle various recovery scenarios with confidence.

What's included

13 videos1 reading2 assignments

13 videos Total 119 minutes

Introducing the Section 0 minutes
Configuring RMAN Persistent Settings (Part 1 of 2) 8 minutes
Configuring RMAN Persistent Settings (Part 2 of 2) 13 minutes
Practice - Configuring RMAN Persistent Settings 6 minutes
Introducing RESTORE and RECOVER Commands 13 minutes
Performing Recovery Part I - Performing Full Recovery 17 minutes
Practice - Performing Recovery Part I 12 minutes
Performing Recovery Part II - Switching Data Files and Performing PITR (1 of 2) 6 minutes
Performing Recovery Part II - Switching Data Files and Performing PITR (2 of 2) 11 minutes
Practice - Performing Recovery Part II 7 minutes
Automating RMAN Backup Jobs 9 minutes
Practice - Automating RMAN Backup Jobs (Part 1 of 2) 11 minutes
Practice - Automating RMAN Backup Jobs (Part 2 of 2) 6 minutes

1 reading Total 10 minutes

Conclusion to the Course 'Intermediate Oracle Database Administration' 10 minutes

2 assignments Total 75 minutes

Assessment 8 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

Packt - Course Instructors

Packt

1,561 Courses 439,293 learners

Offered by

Packt

Explore more from Data Management

Packt
Oracle Database Administration from Zero to Hero
Specialization
Packt
Advanced Oracle Database Administration
Course
Packt
Foundations of Oracle Database Administration
Course
Packt
The Oracle Database RAC Administration Course (12c and 19c)
Specialization

Why people choose Coursera for their career

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."

Jennifer J.

Learner since 2020

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

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."

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."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

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.

Intermediate Oracle Database Administration

Intermediate Oracle Database Administration

What you'll learn

Skills you'll gain

Tools you'll learn

Details to know

See how employees at top companies are mastering in-demand skills

Build your subject-matter expertise

There are 8 modules in this course

Managing Oracle Database Components

What's included

Managing Database Segments

What's included

Managing Database Users and Security

What's included

Managing Database Connectivity

What's included

Configuring Shared Server

What's included

Managing Fast Recovery Area and Redo Log

What's included

Taking Backups in Oracle Databases

What's included

Database Recovery

What's included

Earn a career certificate

Instructor

Offered by

Explore more from Data Management

Oracle Database Administration from Zero to Hero

Advanced Oracle Database Administration

Foundations of Oracle Database Administration

The Oracle Database RAC Administration Course (12c and 19c)

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

Can I preview a course before enrolling?

When will I have access to the lectures and assignments?

What will I get when I enroll?

More questions