Intermediate Oracle Database Administration
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Intermediate Oracle Database Administration
This course is part of Oracle Database Administration from Zero to Hero Specialization
Included with
Ask Coursera
Recommended experience
Recommended experience
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
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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
5 videos•Total 53 minutes
- Introducing the Section•0 minutes
- Configuring Databases for Shared Server (Part 1 of 3)•13 minutes
- Configuring Databases for Shared Server (Part 2 of 3)•15 minutes
- Configuring Databases for Shared Server (Part 3 of 3)•9 minutes
- Practice - Configuring Databases for Shared Server•16 minutes
1 assignment•Total 15 minutes
- Assessment 5•15 minutes
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
Explore more from Data Management
- Status: Free Trial
Specialization
- Status: Free Trial
Course
- Status: Free Trial
Course
- Status: Free Trial
Specialization
Why people choose Coursera for their career
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.
More questions
Financial aid available,