Oracle Database Foundations

Seize the savings! Get 40% off 3 months of Coursera Plus and full access to thousands of courses.

Oracle Database Foundations

This course is part of Oracle SQL Databases Specialization

Instructor: LearnQuest Network

30,483 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

475 reviews

Beginner level

Recommended experience

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

475 reviews

Beginner level

Recommended experience

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

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

This Specialization is designed to help beginners learn the foundational knowledge invaluable towards their journey to becoming proficient with the Oracle database environment.

Welcome to the Introduction to Oracle SQL Specialization. This course is the first of four and will introduce you to Database Foundations. First, let's take a look at the course overview.

What's included

1 video

In this module, we'll discuss database engines & categories.

What's included

6 videos2 readings2 assignments1 discussion prompt1 plugin

6 videos Total 30 minutes

What You Will Learn in Module 2 4 minutes
What is a Database Engine? 8 minutes
Widely Used Databases 2 minutes
Oracle: The Premier Multi-Model Database Engine 6 minutes
Database Categories (Part 1) 4 minutes
Database Categories (Part 2) 6 minutes

2 readings Total 50 minutes

Introduction To Oracle Database Concepts 30 minutes
Types of Databases 20 minutes

2 assignments Total 60 minutes

Practice Review 30 minutes
Module 2 Review 30 minutes

1 discussion prompt Total 10 minutes

On The Topic of Database Categories 10 minutes

1 plugin Total 15 minutes

Drag & Drop - Database Engine 15 minutes

In this module, we will explore how to build architecturally sound database structures.

What's included

11 videos3 readings2 assignments1 discussion prompt2 plugins

11 videos Total 47 minutes

What You Will Learn in Module 3 4 minutes
Building a Database From Scratch Part 1 4 minutes
Building a Database From Scratch Part 2 4 minutes
Building a Database From Scratch Part 3 9 minutes
Database Design: Initial Conversation 3 minutes
Database Design Goals 2 minutes
Designing Tables Within A Database Part 1 4 minutes
Designing Tables Within A Database Part 2 6 minutes
Next Steps After Completing Database Design Part 1 4 minutes
Next Steps After Completing Database Design Part 2 5 minutes
Next Steps After Completing Database Design Part 3 2 minutes

3 readings Total 50 minutes

Different Types of Database Users 30 minutes
Implementing the Design 10 minutes
A "Little" About Database Administration (DBA) Tasks 10 minutes

2 assignments Total 60 minutes

Practice Review 30 minutes
Module 3 Review 30 minutes

1 discussion prompt Total 10 minutes

Something to think about 10 minutes

2 plugins Total 30 minutes

Primary and Foreign Keys 15 minutes
Activity: Designing Tables Drag and Drop 15 minutes

In this module, we'll introduce relational database management systems and Oracle database storage.

What's included

12 videos6 readings2 assignments1 discussion prompt3 plugins

12 videos Total 44 minutes

What You Will Learn in Module 4 3 minutes
Relational Database Management System (RDBMS) Part 1 4 minutes
Relational Database Management System (RDBMS) Part 2 6 minutes
Database Schema Part 1 3 minutes
Database Schema Part 2 4 minutes
Database Architecture Part 1 5 minutes
Database Architecture Part 2 3 minutes
Oracle Storage Architecture Part 1 2 minutes
Oracle Storage Architecture Part 2 3 minutes
Oracle Storage Architecture Part 3 4 minutes
Database Instance: Overview 2 minutes
Database Instance: Background Processes 5 minutes

6 readings Total 90 minutes

Oracle Database Relational Data Structures 10 minutes
Introduction To Database Schemas 20 minutes
Database Architecture Logical and Physical Structures 10 minutes
Oracle Database Storage Structures 10 minutes
Oracle Background Processes 10 minutes
Technical Architecture: Oracle Database Instance 30 minutes

2 assignments Total 60 minutes

Practice Review 30 minutes
Module 4 Review 30 minutes

1 discussion prompt Total 10 minutes

Where To Store It All? 10 minutes

3 plugins Total 45 minutes

Activity: RDBMS Components 15 minutes
Activity: Database Architecture 15 minutes
Activity: Storage Architecture 15 minutes

In this module, we will discuss designing your ideal database for a specific purpose.

What's included

5 videos2 readings2 assignments1 plugin

5 videos Total 20 minutes

What You Will Learn in Module 5 2 minutes
Schema Design 5 minutes
Transactions Simplified 5 minutes
Transactions: ACID Properties 4 minutes
Transactions: BASE Properties 5 minutes

2 readings Total 40 minutes

Oracle Database Schema 30 minutes
Oracle Database Transactions 10 minutes

2 assignments Total 60 minutes

Practice Review 30 minutes
Module 5 Review 30 minutes

1 plugin Total 15 minutes

Activity: Schemas Drag and Drop 15 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

Instructor ratings

(160 ratings)

LearnQuest Network

LearnQuest

201 Courses 965,397 learners

Offered by

LearnQuest

Explore more from Software Development

Status: Free Trial
Packt
Foundations of Oracle Database Administration
Course
Status: Free Trial
LearnQuest
Oracle Database Platform
Course
Status: Free Trial
Packt
Oracle Database Administration from Zero to Hero
Specialization
Status: Free Trial
LearnQuest
Oracle SQL Basics
Course

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

Learner reviews

5 stars
72.05%
4 stars
21.84%
3 stars
3.78%
2 stars
0.84%
1 star
1.47%

Showing 3 of 475

Reviewed on Oct 17, 2021

i will recommend this course for basic knowledge of database

Reviewed on Oct 10, 2022

More technical examples would greatly aid this course

Reviewed on Sep 3, 2023

A very good fundamental, especially if you're in a banking sector

View more reviews

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

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

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.