VOOZH about

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

⇱ Foundations of Oracle Database Administration | Coursera

Foundations of Oracle Database Administration

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

Foundations of Oracle Database Administration

1,871 already enrolled

Included with

Gain insight into a topic and learn the fundamentals.
4.6

10 reviews

Intermediate level

Recommended experience

1 week to complete
at 10 hours a week
Gain insight into a topic and learn the fundamentals.
4.6

10 reviews

Intermediate level

Recommended experience

1 week to complete
at 10 hours a week

What you'll learn

  • Configure virtual machines and set up a practice environment for Oracle database.

  • Install and manage Oracle database software on Linux and Windows platforms.

  • Master database architecture, tablespaces, and multitenant databases.

  • Administer database instances and perform basic multitenant administration tasks.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

7 assignments

Taught in English
Flexible schedule
Learn at your own pace

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

Dive into the essential skills needed to become a proficient Oracle Database Administrator with this comprehensive course. You will learn to install, configure, and manage Oracle databases, setting a strong foundation for a career in database administration. Gain hands-on experience with the practical tools and techniques required to maintain secure, high-performing database environments.

The course begins with an introduction to relational database management systems (RDBMS) and the Oracle database ecosystem. You'll explore core database architecture, learn to set up a practice environment, and understand the role of a DBA. Through step-by-step guides, you'll master installation processes, database creation, and key administration tasks on Linux and Windows platforms. As you progress, you'll delve into advanced topics, including database initialization, data dictionary queries, and multitenant architecture. Hands-on practice will solidify your skills, enabling you to administer both container and pluggable databases effectively. Real-world scenarios and documentation usage will prepare you for professional challenges. Ideal for aspiring and practicing DBAs, this course caters to learners with basic IT knowledge. With its beginner-friendly approach and hands-on labs, you'll gain confidence to advance in the competitive field of database administration.

In this module, we will warmly welcome you to the course and provide a detailed overview of what you can expect. You’ll meet the instructor, understand the course format, and discover how this program can help you elevate your skills in Oracle Database Administration. This session sets the foundation for an enriching learning experience.

What's included

1 video2 readings

1 video•Total 4 minutes
  • Introduction to the Specialization•4 minutes
2 readings•Total 20 minutes
  • Introduction to the Course 'Foundations of Oracle Database Administration'•10 minutes
  • Full Specialization Resources•10 minutes

In this module, we will guide you through the process of preparing the practice environment. You will install necessary software, configure Oracle Linux and Windows virtual machines, and establish connections using tools like Putty. By the end, you’ll have a fully functional setup to practice Oracle database administration tasks.

What's included

2 videos1 assignment

2 videos•Total 32 minutes
  • Practice - Preparing Course Practice Environment (Part 1 of 2)•19 minutes
  • Practice - Preparing Course Practice Environment (Part 2 of 2)•13 minutes
1 assignment•Total 15 minutes
  • Assessment 1•15 minutes

In this module, we will introduce the fundamentals of RDBMS and delve into Oracle-specific technologies. You’ll learn about Oracle’s database releases, cloud services, editions, and licensing, as well as the role and career path of a Database Administrator (DBA). This section builds your foundational knowledge of Oracle databases.

What's included

7 videos1 assignment

7 videos•Total 62 minutes
  • Introducing the Section•1 minute
  • Overview of RDBMS (Part 1 of 2)•8 minutes
  • Overview of RDBMS (Part 2 of 2)•11 minutes
  • Overview on Oracle Database (Part 1 of 2)•10 minutes
  • Overview on Oracle Database (Part 2 of 2)•9 minutes
  • Overview on Oracle Database Technologies•13 minutes
  • About Oracle Database Administrator (DBA)•10 minutes
1 assignment•Total 15 minutes
  • Assessment 2•15 minutes

In this module, we will explore the architecture of Oracle databases, focusing on database instances, files, and storage structures like tablespaces. By understanding these core components, you’ll gain insights into how Oracle databases function and are managed at a structural level.

What's included

4 videos1 assignment

4 videos•Total 33 minutes
  • Introducing the Section•0 minutes
  • Introducing Oracle Database Architecture (Part 1 of 2)•18 minutes
  • Introducing Oracle Database Architecture (Part 2 of 2)•7 minutes
  • Introducing Database Tablespaces and Data Files•8 minutes
1 assignment•Total 15 minutes
  • Assessment 3•15 minutes

In this module, we will cover the end-to-end process of installing and creating Oracle databases. From preparing prerequisites to hands-on practice with tools like SQL*Plus and SQL Developer, you’ll gain practical skills to build and manage Oracle database environments effectively.

What's included

13 videos1 assignment

13 videos•Total 163 minutes
  • Introducing the Section•1 minute
  • Oracle DB Software Installation (Part 1 of 2)•19 minutes
  • Oracle DB Software Installation (Part 2 of 2)•9 minutes
  • Practice - Installing Oracle Database Software in Linux•16 minutes
  • Practice - Installing Oracle Database Software in Windows•8 minutes
  • Creating an Oracle Database (Part 1 of 3)•8 minutes
  • Creating an Oracle Database (Part 2 of 3)•23 minutes
  • Creating an Oracle Database (Part 3 of 3)•11 minutes
  • Practice - Creating Oracle Databases (Part 1 of 2)•17 minutes
  • Practice - Creating Oracle Databases (Part 2 of 2)•11 minutes
  • Oracle Database Management Tools•17 minutes
  • Practice - Using SQLPlus•16 minutes
  • Practice - Using SQL Developer•7 minutes
1 assignment•Total 15 minutes
  • Assessment 4•15 minutes

In this module, we will focus on essential administration tasks such as managing database instances, adjusting initialization parameters, and querying data dictionaries. Through hands-on practice, you’ll acquire the skills to perform these tasks confidently in real-world scenarios.

What's included

10 videos1 assignment

10 videos•Total 99 minutes
  • Introducing the Section•1 minute
  • Starting Up and Shutting Down Database Instances•17 minutes
  • Practice - Starting Up and Shutting Down DB Instances•7 minutes
  • Database Initialization Parameters (Part 1 of 2)•18 minutes
  • Database Initialization Parameters (Part 2 of 2)•8 minutes
  • Practice - Managing Initialization Parameters, SPFILE, and PFILE•10 minutes
  • Introducing Data Dictionary•13 minutes
  • Practice - Querying Data Dictionary•5 minutes
  • Using Oracle Database Documentation (Part 1 of 2)•9 minutes
  • Using Oracle Database Documentation (Part 2 of 2)•12 minutes
1 assignment•Total 15 minutes
  • Assessment 5•15 minutes

In this module, we will dive into Oracle Database Multitenancy, exploring the architecture, creation, and administration of CDBs and PDBs. With hands-on exercises, you’ll develop a strong foundation in managing Multitenant databases and their unique features.

What's included

9 videos1 reading2 assignments

9 videos•Total 94 minutes
  • Introducing the Section•1 minute
  • Oracle Database Multitenant Architecture (part 1 of 2)•13 minutes
  • Oracle Database Multitenant Architecture (Part 2 of 2)•13 minutes
  • Practice - Creating a CDB Database•11 minutes
  • Creating PDBs (Part 1 of 2)•10 minutes
  • Creating PDBs (Part 2 of 2)•9 minutes
  • Practice - Creating PDBs•10 minutes
  • Basic Multitenant Administration Tasks•15 minutes
  • Practice - Performing Basic CDB Admin Tasks•11 minutes
1 reading•Total 10 minutes
  • Conclusion to the Course 'Foundations of Oracle Database Administration'•10 minutes
2 assignments•Total 75 minutes
  • Assessment 6•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."

Learner reviews

  • 5 stars

    70%

  • 4 stars

    20%

  • 3 stars

    10%

  • 2 stars

    0%

  • 1 star

    0%

Showing 3 of 10

BB
·

Reviewed on Oct 23, 2025

Very comprehensive instruction on how to setup the learning environments, thought some of the information there is outdated. The actual coursework is also comprehensive and well described.

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,