Oracle SQL Exam Prep

Instructor: LearnQuest Network

Access provided by Coursera Guided Projects Instructors

2,755 already enrolled

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

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.