Oracle Database Foundations

Ends soon! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Oracle Database Foundations

This course is part of Oracle SQL Databases Specialization

Instructor: LearnQuest Network

31,570 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

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

479 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

91%

of learners achieved a positive career outcome

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 videosTotal 30 minutes

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

2 readingsTotal 50 minutes

Introduction To Oracle Database Concepts30 minutes
Types of Databases20 minutes

2 assignmentsTotal 60 minutes

Practice Review30 minutes
Module 2 Review30 minutes

1 discussion promptTotal 10 minutes

On The Topic of Database Categories10 minutes

1 pluginTotal 15 minutes

Drag & Drop - Database Engine15 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 videosTotal 47 minutes

What You Will Learn in Module 3 4 minutes
Building a Database From Scratch Part 14 minutes
Building a Database From Scratch Part 24 minutes
Building a Database From Scratch Part 39 minutes
Database Design: Initial Conversation3 minutes
Database Design Goals2 minutes
Designing Tables Within A Database Part 14 minutes
Designing Tables Within A Database Part 26 minutes
Next Steps After Completing Database Design Part 14 minutes
Next Steps After Completing Database Design Part 25 minutes
Next Steps After Completing Database Design Part 32 minutes

3 readingsTotal 50 minutes

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

2 assignmentsTotal 60 minutes

Practice Review30 minutes
Module 3 Review30 minutes

1 discussion promptTotal 10 minutes

Something to think about 10 minutes

2 pluginsTotal 30 minutes

Primary and Foreign Keys15 minutes
Activity: Designing Tables Drag and Drop15 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 videosTotal 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 26 minutes
Database Schema Part 1 3 minutes
Database Schema Part 24 minutes
Database Architecture Part 15 minutes
Database Architecture Part 23 minutes
Oracle Storage Architecture Part 12 minutes
Oracle Storage Architecture Part 23 minutes
Oracle Storage Architecture Part 34 minutes
Database Instance: Overview2 minutes
Database Instance: Background Processes5 minutes

6 readingsTotal 90 minutes

Oracle Database Relational Data Structures10 minutes
Introduction To Database Schemas20 minutes
Database Architecture Logical and Physical Structures10 minutes
Oracle Database Storage Structures10 minutes
Oracle Background Processes10 minutes
Technical Architecture: Oracle Database Instance30 minutes

2 assignmentsTotal 60 minutes

Practice Review30 minutes
Module 4 Review30 minutes

1 discussion promptTotal 10 minutes

Where To Store It All?10 minutes

3 pluginsTotal 45 minutes

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

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

What's included

5 videos2 readings2 assignments1 plugin

5 videosTotal 20 minutes

What You Will Learn in Module 5 2 minutes
Schema Design5 minutes
Transactions Simplified5 minutes
Transactions: ACID Properties4 minutes
Transactions: BASE Properties5 minutes

2 readingsTotal 40 minutes

Oracle Database Schema30 minutes
Oracle Database Transactions10 minutes

2 assignmentsTotal 60 minutes

Practice Review30 minutes
Module 5 Review30 minutes

1 pluginTotal 15 minutes

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

(163 ratings)

LearnQuest Network

LearnQuest

207 Courses991,982 learners

Offered by

LearnQuest

Explore more from Software Development

Packt
Foundations of Oracle Database Administration
Course
LearnQuest
Oracle Database Platform
Course
Packt
Oracle Database Administration from Zero to Hero
Specialization
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
71.87%
4 stars
22.08%
3 stars
3.75%
2 stars
0.83%
1 star
1.45%

Showing 3 of 479

Reviewed on Oct 17, 2021

i will recommend this course for basic knowledge of database

Reviewed on Nov 10, 2021

A great course for absolute beginners to get started with the basic concepts of data storing and databases.However, the course is completely theoretical.

Reviewed on Sep 3, 2023

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

View more reviews

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.