Oracle SQL Exam Prep

Instructor: LearnQuest Network

2,762 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

15 reviews

Beginner level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

15 reviews

Beginner level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 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

There are 5 modules in this course

This course is designed to help you continue learning about Oracle SQL and prepares you to take the Oracle SQL Certification Exam.

In this module, we'll introduce you to the course and discuss which topics we'll cover. We'll also explore why SQL is a powerful tool to use and some of it's uses. Then, we'll explore table design and schemas.

What's included

5 videos2 readings1 assignment

In this module, we'll explore some of the key terms you'll need to know when building SQL Databases. We will compare and contrast the ANY and ALL operators, distinguish between COMMIT and ROLLBACK, and explore pseudocolumns. We will also give examples for some of these terms.

What's included

6 videos2 readings1 assignment

6 videos Total 33 minutes

Database Terms (Part 1 of 6) 6 minutes
Database Terms (Part 2 of 6) 3 minutes
Database Terms (Part 3 of 6) 5 minutes
Database Terms (Part 4 of 6) 6 minutes
Database Terms (Part 5 of 6) 6 minutes
Database Terms (Part 6 of 6) 7 minutes

2 readings Total 50 minutes

SQL Database Terms 20 minutes
More Database Terms to Know 30 minutes

1 assignment Total 45 minutes

Module 2 Quiz 45 minutes

In this module, we'll review primary and foreign keys, delving a little more into their constraints. We'll also explore the USING clause and what it is used for.

What's included

4 videos2 readings1 assignment

4 videos Total 19 minutes

Primary Key Constraint (Part 1 of 2) 4 minutes
Primary Key Constraint (Part 2 of 2) 6 minutes
Foreign Key Constraint 5 minutes
Foreign Key Constraint and the Using Clause 5 minutes

2 readings Total 35 minutes

Primary Key Constraints 15 minutes
Foreign Keys and the USING Clause 20 minutes

1 assignment Total 30 minutes

Module 3 Quiz 30 minutes

In this module, we'll take a look at INSTRING and SUBSTRING functions and demonstrate naming a column using an alias. We will also explore subqueries and take another look at pseudocolumns. Lastly, we'll discuss views and compare them with materialized views.

What's included

5 videos2 readings1 assignment

The following ungraded quiz will help you practice what you have learned before taking the Oracle SQL Certification Exam.

What's included

1 assignment

Instructor

LearnQuest Network

LearnQuest

201 Courses 971,793 learners

Offered by

LearnQuest

Explore more from Data Management

LearnQuest
Oracle SQL Basics
Course
LearnQuest
Oracle SQL Practice Course
Course
LearnQuest
Oracle SQL Databases
Specialization
Oracle AI Database
Intro to Oracle SQL
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
86.66%
4 stars
13.33%
3 stars
0%
2 stars
0%
1 star
0%

Showing 3 of 15

Reviewed on Dec 25, 2024

Best for Beginners. The course gives a good overview of Oracle SQL DB, and the articles attached will be helpful for future reference as well.

Reviewed on Mar 4, 2025

Amazing course. I recommend this course to anyone trying to elevate their sql skills.

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 purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, 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.