Oracle Database Foundations

This course is part of Oracle SQL Databases Specialization

Instructor: LearnQuest Network

Access provided by IT Education Association

30,483 already enrolled

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

Module 2 Review 30 minutes
Practice 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

Module 3 Review 30 minutes
Practice 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

Module 4 Review 30 minutes
Practice 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

Module 5 Review 30 minutes
Practice 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

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 Mar 14, 2024

Nicely Designed & well Explained Course. Must Do for all who want to learn SQL as well as Database from Scratch

Oracle Database Foundations

Oracle Database Foundations

Skills you'll gain

Tools you'll learn

Details to know

See how employees at top companies are mastering in-demand skills

Build your subject-matter expertise

There are 5 modules in this course

Course Introduction

What's included

Introduction to Databases

What's included

Building a Database Structure

What's included

Relational Database Management Systems (RDBMS) & Oracle Database Storage

What's included

Designing A Database For a Specific Purpose

What's included

Earn a career certificate

Instructor

Offered by

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Learner reviews

Explore more from Computer Science

Foundations of Oracle Database Administration

Oracle Database Platform

Oracle Database Administration from Zero to Hero

Oracle SQL Basics