Oracle SQL Exam Prep

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off

One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.

This course is designed to help you continue learning about Oracle SQL and prepares you to take the Oracle SQL Certification Exam. We'll review methodologies and terminology that we presented in the Oracle Specialization courses, show some demos and give in-depth explanations. You'll also have the opportunity to take a practice certification exam. We recommend that you first complete the Oracle SQL Databases Specialization.

Syllabus

SQL and Table Design

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.

SQL Database Terms

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.

Key Constraints and the USING Clause

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.

Functions, Subqueries, Pseudocolumns, and Views

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.