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

Access provided by Kalinga Institute of Industrial Technology

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