Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Complete Oracle SQL Bootcamp (2026)

Name: The Complete Oracle SQL Bootcamp (2026)
Rating: 4.6 (25710 reviews)

Become an In-demand SQL Professional! Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!

Bestseller

Role Play

Created byDatabase Masters | 300,000+ Successful Students Worldwide, Code Star Academy

Last updated 2/2026

English

What you'll learn

Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!
Be Able to Answer any SQL Interview Questions Confidently!
Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
Learn Oracle SQL by Professionally Designed Content Step by Step!
Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!
Solve any SQL-related Problems by Yourself Creating Analytical Solutions!
Test Your SQL Skills with Hundreds of Hands-on Examples, Quizzes, Challenges!
Lifetime Support from the Instructors. Get a Well-Organized Recap Document!

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

26 sections • 399 lectures • 37h 57m total length

What is a Database?7:44
In this SQL tutorial, the Complete Oracle SQL Bootcamp course participants will learn about what a database is and why we need to use databases with real-world examples.
Why Oracle Database?7:00
What is a Table?3:40
In this lecture, our students going to learn what a table is and why we need to use the tables.
UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)5:01
This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.
The Working Document (Course Slide for Course Participants)0:21
In this lecture, this course participants will be able to claim & download their special quick recap document for The Complete Oracle SQL Bootcamp course.
Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples)0:35
What is a Relational Database (RDBMS)?7:52
Entity Relationship Logic in Databases3:46
What is Pluggable Database?3:13
In this lecture, you're going to learn what the pluggable database (multitenant architecture) is in Oracle Database.
Introduction to Database Objects13:26
The Sample (HR) Schema Used in This Course7:23
What is SQL?5:02
Quiz (Database Concepts)

About the Database Installation3:02
The Ways to Get a Database14:49
In this SQL tutorial, the participants will learn how to get a database to proceed with the Complete Oracle SQL Bootcamp 2022 course.
Option 1: Downloading Oracle Database 23ai The Virtual Machine Image (.ova) File2:17
In this SQL tutorial, the Complete Oracle SQL Bootcamp course participants will learn how to download the Oracle Database 23ai Virtual Machine Image (OVA) file, set up a fully functional database ready for use.
Option 1: Downloading and Installing VirtualBox3:14
In this SQL tutorial, the Complete Oracle SQL Bootcamp course participants will learn how to download and install the VirtualBox virtualization software, enabling them to use the image we downloaded in the previous lesson. This software will provide access to a pre-configured Linux operating system with an installed database, ready for use.
Option 1: Getting Started with VirtualBox: Setup and Configuration5:15
In this SQL tutorial, the Complete Oracle SQL Bootcamp participants will learn how to import the VirtualBox image we downloaded in the previous lesson into the VirtualBox software, ensuring a seamless setup and smooth operation.
Option 1: Configuring SQL Developer for the Virtual Machine11:46
In this SQL bootcamp tutorial, the Complete Oracle SQL Bootcamp participants will learn how to download and install the SQL Developer tool on their Windows machine, and connect it to a database running on a Linux server that we set up in previous lessons. The advantage of this setup is that we’ll use the pre-configured Linux image solely as the database server, while SQL Developer, installed on Windows, will handle the queries. This configuration enhances both performance and stability, allowing SQL Developer to run faster and more smoothly.
Option 1: Using SQL Developer with Virtual Machines4:19
In this SQL tutorial, the Complete Oracle SQL Bootcamp participants will learn how to use the SQL Developer tool to run queries and follow along with the course content.
Option 1: How to Install the Virtual Box on Mac OS X?1:52
Important Note0:44
For the students who could succeed to complete the Option-1
Option 2: Downloading And Installing Oracle Database18:00
In this SQL tutorial, the complete SQL Bootcamp course participants will learn about the Oracle Database 19c installation.
Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".
Option 2: Unlocking the HR Schema7:34
In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.
Option 2: Configuring and Using the SQL Developer22:14
This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.
Option 2: Installing Sample Schemas in Oracle Database7:44
In this SQL tutorial, the course participants will learn about the easiest way how to install Oracle Sample Schemas to be able to work with many database sample schemas provided by Oracle.
Option 2: HR Schema Create Code (if you could not get the HR user in other ways)32:35
This code includes the SQL script to generate the HR schema with all its data.
Note 1: You can use this script if you could not have the HR schema properly.
Note 2: Just select all the script and execute in one step when connected as the SYS or SYSTEM user.
Option 3 : Using Oracle Live SQL7:40
Option 3: Oracle Live SQL Limitations0:39
SQL Statements Used in This Course5:29
Introduces which SQL statements we are going to use in this course. (Oracle's specific SQL details are in next lessons.)
Don't Forget to Leave a Rating!0:14
This lecture introduces shows how much we appriciate your thoughts.

Oracle Data Types6:54
In this lesson, we're going to talk about Oracle Data Types which are;

CHAR

VARCHAR2

NUMBER

DATE

LONG

RAW

LONG RAW

BLOB

CLOB

BFILE

ROWID.
What is a NULL Value?5:10
In this lecture, students are going to learn one of the most important concepts of the database terminology which is called "Null". We've explained what a NULL value is in this lecture in details.
DESCRIBE Command4:25
This lesson includes Oracle DESC or DESCRIBE Command.
INFORMATION Command8:13
This lesson teaches how to see a better description and some statistics of a table using the INFO[RMATION] and INFO[RMATION]+ Commands.
INFORMATION Command (Code Samples)0:06
Includes the code samples used in the INFORMATION Command lecture
SQL Statement Basics13:55
This lesson covers Oracle SQL Statement Basics.
SQL Statement Basics (Code Samples)0:06
This lecture includes the code samples we used within the previous lecture
Oracle Error Messages6:51
This lecture explains how to read the Oracle (ORA) error messages and how to take an action to solve your code problems
Oracle Error Messages (Code Samples)0:10
This lecture includes the code samples we used within the previous lecture
Using SELECT Statements6:00
This lesson covers Oracle SELECT Statements.
Using SELECT Statements (Code Samples)0:10
This lecture includes the code samples we used within the previous lecture
Using Column Aliases7:26
This lesson covers Oracle Column Aliases.
CODE: Using Column Aliases0:15
This lecture includes the code samples we used within the previous lecture
Quote (Q) Operator8:53
This lesson covers Oracle Quote (q) Operator.
Quote (Q) Operator (Code Samples)0:20
This lecture includes the code samples we used within the previous lecture
DISTINCT and UNIQUE Operator7:42
This lesson covers the Oracle Distinct (DISTINCT) and UNIQUE operators.
DISTINCT and UNIQUE Operators (Code Samples)0:16
This lecture includes the code samples we used within the previous lecture
Write a SQL Query that Returns All the Possible Product Status Values
Coding Exercise 1 Solution0:19
This tutorial explains the solution to the related SQL coding exercise.
Concatenation Operators7:46
In this SQL tutorial, we cover the Concatenation ( || ) Operator in Oracle SQL with various examples.
Concatenation Operators (Code Samples)0:17
This lecture includes the code samples we used within the previous lecture
Arithmetic Expressions and NULL Values10:05
This lesson covers Oracle SQL Arithmetic Operations like;

Add

Substract

Multiply

Divide

and covers NULL values.
Arithmetic Expressions and NULL Values (Code Samples)0:17
This lecture includes the code samples we used within the previous lecture
Write a SQL Query to Calculate New Salaries
Quiz (Retrieving Data)
Coding Exercise 2 Solution0:30
This tutorial explains the solution to the related SQL coding exercise.
Mastering Oracle SQL Basics for Aspiring Developers

Using WHERE Clause4:41
In this lesson, students are going to learn the WHERE clause and how to use the WHERE clause in SQL statements and the Oracle Database with its various examples.
Using WHERE Clause (Code Samples)0:08
This lecture includes the code samples we used within the previous lecture
Write a SQL Query to Fetch the Employees Working as Sales Managers
Comparison Operators6:33
In this SQL tutorial, the Complete SQL Bootcamp course participants will learn about Comparison Operators ( <, >, < = , >=, <>) in Oracle SQL with hands-on examples.
Comparison Operators (Code Samples)0:12
This lecture includes the code samples we used within the previous lecture
BETWEEN … AND Operator5:48
In this lesson we're going to learn BETWEEN ... AND Operator in Oracle Database.
BETWEEN...AND Operator (Code Samples)0:11
This lecture includes the code samples we used within the previous lecture
IN Operator9:53
In this lesson we're going to learn IN Operator in Oracle Database.
IN Operator (Code Samples)0:16
This lecture includes the code samples we used within the previous lecture
Type a SQL Query which Returns the Employees who Work as Sales People
LIKE Operator11:21
In this lesson we're going to learn LIKE Operator in Oracle Database.
LIKE Operator (Code Samples)0:19
This lecture includes the code samples we used within the previous lecture
Return all the managers based on their job titles
IS NULL Operator5:21
In this SQL tutorial, the Complete Oracle SQL course participants will learn about what the IS NULL Operator is and how to use the IS NULL operator in Oracle SQL.
IS NULL Operator (Code Samples)0:10
This lecture includes the code samples we used within the previous lecture
Logical Operators (AND, OR, NOT)14:23
In this lesson, students are going to learn Oracle Logical Operators which are;
AND Logical Operator
OR Logical Operator
NOT Logical Operator
Logical Operators (Code Samples)0:12
This lecture includes the SQL code samples we used within the previous lecture
Return Managers Who Earn Less Than $10,000
Rules of Precedence10:41
In this lesson, we're going to learn Rules of Precedence in Oracle Database.

Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.

Operator, Operation

+, - identity, negation

*, / multiplication, division

+, -, || addition, subtraction, concatenation

=, !=, <, >, <=, >=, IS NULL, LIKE, BETWEEN, IN comparison

NOT exponentiation, logical negation

AND conjunction

OR disjunction
Rules of Precedence (Code Samples)0:24
This lecture includes the SQL code samples we used within the previous lecture
A Challenging Exercise on the Rules of Precedence
Quiz12:00
Oracle SQL Quiz about Section 2 : Retrieving Data with using SQL.
Quiz (Restricting Data)

ORDER BY Clause15:12
In this lesson, students are going to learn the ORDER BY Clause in SQL and how to use the ORDER BY Clause in the Oracle Database by its various examples.
ORDER BY Clause (Code Samples)0:26
This lecture includes the SQL code samples we used within the previous lecture
ASC and DESC Operators9:55
This lesson covers the ASC (Ascending) and DESC (Descending) operators in SQL and how to use them in the Oracle Database.
ASC and DESC Operators (Code Samples)0:31
This lecture includes the SQL code samples we used within the previous lecture
It's Time Order the Rows
NULLS FIRST and NULLS LAST Operators4:24
In this lesson, students are going to learn the NULLS FIRST and NULLS LAST Operators in the Oracle Database.
NULLS FIRST and NULLS LAST Operators (Code Samples)0:19
This lecture includes the SQL code samples we used within the previous lecture
ROWNUM & ROWID in SQL12:45
In this lecture, students are going to learn what is ROWID and ROWNUM in SQL, what the ROWID vs ROWNUM differences are.
Lecture keywords: #oracle #sql #rownum #rowid
ROWNUM & ROWID in SQL (Code Samples)0:18
This lecture includes the SQL code samples we used within the previous lecture
Oracle FETCH Clause13:02
This lesson introduces students to the FETCH clause in Oracle SQL, which is also known as the row limiting clause, that is used to limit rows returned by a query.
Oracle FETCH Clause (Code Samples)0:34
This lecture includes the SQL code samples we used within the previous lecture
Bring the Second Top 10 Orders
Quiz (Sorting Data)

What is a Substitution Variable?15:50
In this SQL tutorial, students are going to learn a brand new section called "Substitution Variables".
This lecture covers "What a Substitution Variable is" in Oracle and how to use Substitution Variables in SQL Queries with various examples.
What is a Substitution Variable (Code Samples)0:18
This lecture includes the SQL code samples we used within the previous lecture
Double Ampersand (&&) and DEFINE & UNDEFINE Commands18:52
In this SQL tutorial, participants are going to learn how to use double ampersand (&&) characters as substitution variables in SQL. And also they will learn the DEFINE and UNDEFINE commands to define and undefine substitution variables explicitly.
Double Ampersand (&&) and DEFINE & UNDEFINE Commands (Code Samples)0:23
This lecture includes the SQL code samples we used within the previous lecture
ACCEPT and PROMPT Commands8:17
In this SQL tutorial, students are going to learn how to use ACCEPT and PROMPT commands with substitution variables in SQL.
ACCEPT and PROMPT Commands (Code Samples)0:18
This lecture includes the SQL code samples we used within the previous lecture
SET VERIFY ON / SET VERIFY OFF Commands8:07
In this SQL tutorial, our expert SQL instructors are going to demonstrate how to use SET VERIFY ON and SET VERIFY OFF commands to turn off or turn on substitution operations while performing special operations like the data warehouse operations, data migration, etc.
SET VERIFY ON-OFF Commands(Code Samples)0:12
This lecture includes the SQL code samples we used within the previous lecture

Single Row Functions12:33
In this lesson, students are going to learn what the function is in the programming context and in Oracle Database.
They will also learn function types in Oracle which are Single-Row Functions and Multiple-Row functions (also called Group Functions).
This lecture is just an overview of Single-row functions in Oracle Database.
In the upcoming lectures, students will see all the subtypes of single-row function in Oracle one by one in detail.
Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functions15:12
In this SQL tutorial, students are going to learn Case Conversion Functions which are the subtype of the Character Functions in Oracle Database.
And we will cover Case conversion functions below;
LOWER function
UPPER function
INITCAP function
Case Conversion (LOWER, UPPER, INITCAP) Functions (Code Samples)0:21
This lecture includes the SQL code samples we used within the previous lecture
Character Functions - Character Manipulation Functions (Part 1)14:27
In this SQL tutorial, students are going to learn the Oracle Character Manipulation Functions which are the subtype of Oracle String Functions.
Character Manipulation Function in Oracle has 8 functions which are;
SUBSTR function
LENGTH function
CONCAT function
INSTR function
TRIM function
REPLACE function
LPAD function
RPAD function.
In this SQL lesson, students are going to learn;
How to use the Oracle SUBSTR() function to extract a substring from a string,
How to use the Oracle LENGTH() function that returns the number of characters of a specified string,
And lastly, they will also see the Oracle CONCAT function that concatenates two strings and returns the combined string.
Character Manipulation Functions (Part 1) (Code Samples)1:53
This lecture includes the SQL code samples we used within the previous lecture
Character Functions - Character Manipulation Functions Part 2 (INSTR Function)11:06
In this SQL tutorial, students are going to learn the Oracle INSTR() function that searches for a substring in a string and returns the position of the substring in a string.
Character Manipulation Functions Part 2 (INSTR Function) (Code Samples)0:29
This lecture includes the SQL code samples we used within the previous lecture
Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)20:15
In this SQL Character Functions lecture series, we are going to continue to learn Character Manipulation Functions in SQL.
This SQL tutorial covers;
TRIM function
LTRIM function
RTRIM function and their example usages.
Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions) (Code Samples)1:04
This lecture includes the SQL code samples we used within the previous lecture
Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)11:37
In this SQL Character Functions lecture series, we are going to continue to learn the last part of the Character Manipulation Functions in SQL.
This SQL tutorial covers;
REPLACE function
LPAD function
RPAD function and their example usages.
Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions) (Code Samples)0:24
This lecture includes the SQL code samples we used within the previous lecture
Numeric Functions16:32
In this SQL tutorial, students are going to learn SQL Numeric Functions in other words, SQL Number Functions in the Oracle Database.
The numeric functions we covered in this lecture are;
Round Function
Trunc Function
Ceil Function
Floor Function
Mod Function
Also, the participants will learn how to use other numeric functions in their SQL statements.
Numeric Functions (Code Samples)0:18
This lecture includes the SQL code samples we used within the previous lecture
Nested Functions15:24
In this SQL tutorial, the participants will learn Nested Functions which can be placed within other Oracle functions, extending their capability in the Oracle Database.

Lecture keywords: oracle nested functions, nesting functions in Oracle SQL, nested functions in SQL.
Nested Functions (Code Samples)0:15
This lecture includes the SQL code samples we used within the previous lecture
Date Values & Date Formats in Oracle22:33
In SQL tutorial, we are going to introduce Oracle Date Data Types which are;
Date Data Type,
Timestamp Data Type
Timestamp with Time Zone Data Type
Timestamp with Local Time Zone data types.
And you will also see the Oracle Date Format Models in SQL.
Date Functions & Arithmetic Operations on Dates16:43
In this SQL tutorial, students are going to learn the most commonly used Oracle SQL Date Functions such as sysdate, current_date, systimestamp, current_timestamp, etc. in the Oracle Database.
And they will also learn how to make arithmetic operations on date values.
Date Functions & Arithmetic Operations on Dates (Code Samples)0:24
This lecture includes the SQL code samples we used within the previous lecture
Date Manipulation Functions in SQL19:20
In this SQL tutorial, we will introduce you how to manipulate Oracle date values via Oracle Date manipulation functions such as
Oracle Add_months function
Oracle Months_between function
Oracle Trunc function
Oracle Next_Day function
Oracle Round function
Oracle Last_day function
Oracle Extract function
Date Manipulation Functions in SQL (Code Samples)0:26
This lecture includes the SQL code samples we used within the previous lecture
Quiz (Single-Row Functions)

Conversion Functions10:23
In this lesson we're going to learn Conversion Functions in Oracle Database.

It contains;

Implicit Data Type Conversion

Explicit Data Type Conversion

TO_CHAR Function

TO_DATE Function

TO_NUMBER Funtion
Conversion Functions (Code Samples)0:20
This lecture includes the SQL code samples we used within the previous lecture
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)17:28
In this lesson we're going to learn

TO_CHAR Function in Oracle

TO_DATE Function in Oracle

TO_NUMBER Function in Oracle.
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1) (Code Samples)1:07
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)16:17
In this lesson we're going to learn

TO_CHAR Function in Oracle

TO_DATE Function in Oracle

TO_NUMBER Function in Oracle.
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2) (Code Samples)0:24
This lecture includes the SQL code samples we used within the previous lecture
Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions19:46
In this lesson we're going to learn

NVL Function in Oracle

NVL2 Function in Oracle

NULLIF Function in Oracle

COALESCE Function in Oracle.
Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions (Code Samples)0:19
This lecture includes the SQL code samples we used within the previous lecture
Quiz (Conversion Functions)

Oracle Conditional Expressions: CASE Expressions22:23
This SQL tutorial explains how to use the Oracle CASE expression with syntax and examples to perform if-then-else check in SQL programming.
Oracle Conditional Expressions: CASE Expressions (Code Samples)1:01
This lecture includes the SQL code samples we used within the previous lecture
Oracle Conditional Expressions: DECODE Function9:21
This SQL tutorial explains how to use the Oracle SQL DECODE function with syntax and examples.
Oracle Conditional Expressions: DECODE Function (Code Samples)0:21
This lecture includes the SQL code samples we used within the previous lecture
Quiz (Conditional Expressions)

Group Functions7:41
In this SQL tutorial, students are going to learn Oracle Group Functions, in other words, Oracle aggregate functions work and how to apply them to calculate aggregates.
AVG Function9:31
In this SQL tutorial, participants will learn how to use the Oracle AVG() function and we will show you how to apply it to calculate the average of values in various contexts.
AVG Function (Code Samples)0:14
This lecture includes the SQL code samples we used within the previous lecture
COUNT Function6:06
In this SQL tutorial, students will learn how to count the returning rows of your queries in different ways using the Oracle Count function.
COUNT Function (Code Samples)0:07
This lecture includes the SQL code samples we used within the previous lecture
Write a SQL query returning the number of married male customers
MAX Function4:35
This SQL tutorial explains how to use the Oracle MAX function with its syntax and examples.
MAX Function (Code Samples)0:07
This lecture includes the SQL code samples we used within the previous lecture
MIN Function4:16
This SQL tutorial explains how to use the Oracle MIN function with its syntax and examples.
MIN Function (Code Samples)0:07
This lecture includes the SQL code samples we used within the previous lecture
SUM Function3:40
This SQL tutorial explains how to use the Oracle SUM function with its syntax and examples.
SUM Function (Code Samples)0:08
This lecture includes the SQL code samples we used within the previous lecture
LISTAGG Function9:56
In this SQL tutorial, students will learn how to use the Oracle LISTAGG() function to transform data from multiple rows into a single list of values separated by a specified delimiter with various examples.
LISTAGG Function (Code Samples)0:49
This lecture includes the SQL code samples we used within the previous lecture
Overview Of Group Functions3:48
In this SQL tutorial, students will learn the overview of Oracle Group Functions.
Overview Of Group Functions (Code Samples)0:09
This lecture includes the SQL code samples we used within the previous lecture
Quiz (Group Functions)

Requirements

Nothing more than a working computer; all PC, Mac or Linux, etc. users are all welcome.
No previous programming experience is required!
No paid tools are required!

Description

Welcome to the MOST COMPREHENSIVE Oracle SQL Bootcamp Course on the planet!

Latest Course Updates:

(Dec 2025) : Installing Oracle Database 23 AI section was added! (Brand New)
(Nov 2025) : Brand New Content (Managing Oracle Privileges and Roles) was added!
(Sep 2025) : Brand New Content (Using Oracle FLASHBACK Technologies) was updated!
(Feb 2025) : 3-Real SQL(Over 225+ High-Quality Questions) Certification Exam Samples are added!
(Dec 2024) : More Quiz Questions were added!

Important Notice: This course will be continuously getting updated with more lectures, quizzes, and assessments to enhance your knowledge of Oracle SQL.

Are you a student ready to learn SQL for your lessons?

Do you want to get a better job?

Are you bored with watching a lot of stuff, but could not learn anything?

Do you think you know SQL, but you cannot write SQL codes?

Are you looking for a really professional course?

Then this is the course you are looking for.

You are in the right place!

In this course, all the subjects are explained in professional order.

If you are new to SQL, no problem! You can easily learn all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects.

After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now.

Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

So come on, what are you waiting for?

Get this course, and get a better job!

Topics covered in the Complete Oracle SQL Bootcamp 2025 Course:

Database Concepts & Terminologies
- What is a Database?
- What is the Oracle Database?
- What is a pluggable database?
- What is SQL?
- What is a database table?
- What is a Relational-Database Management System (RDBMS)?
- What is the Entity-Relationship model in SQL?
- What is a database schema?
- Installing Oracle Sample Schemas (HR, SH, OE, IX, etc.)
- Introduction to Database Objects
Downloading and Installing the Oracle Database (Version 12c, 18c, 19c, 21c, 23ai, etc.)
- Downloading the Oracle Database Installation File
- Installing Oracle Database on Your Local Computer
Working with a Database via a Virtual Machine
- Downloading and Installing a Virtualization Software (VirtualBox, VMWare)
- Downloading Pre-built Virtual Machine Image
- Importing a Virtual Machine into Virtualization Software
- Configuring, Using, and Working with Virtual Machines through Virtualization Software
Downloading, Installing, Configuring, and Using the Oracle SQL Developer Software
Connecting to the Oracle Database Using SQL Developer and SQL Plus
- Configuring SQL Developer for the first use
- Configuring Network Connections to work with Oracle Sample Schemas
Working with Oracle Live SQL
- Introduction to Oracle Live SQL Platform
- How to use Oracle Live SQL
Retrieving Data from the Database Using SELECT Statements
- What is NULL?
- SELECT Statements
- Using Column Aliases in SQL
- DISTINCT and UNIQUE Operators in SQL
- Concatenation Operators in SQL
- The Quote (q) Operator in SQL
Filtering & Restricting Data returned by SQL Queries using the WHERE Clause
- Using the WHERE Clause in SQL
- Using Oracle Comparison Operators in SQL
- BETWEEN AND Operator in SQL
- IN Operator in SQL
- LIKE Operator in SQL
- IS NULL Operator in SQL
- Logical Operators in SQL:
  - AND Logical Operator
  - OR Logical Operator
  - NOT Logical Operator
- Oracle Rules of Precedence in SQL
Sorting Data using the ORDER BY Clause
- Using the ORDER BY Clause
- Using the ASC and DESC Operators
- Using the NULLS FIRST and NULLS LAST Operators
- Using the FETCH Clause
Using Oracle Substitution Variables
- What are Substitution Variables?
- Double Ampersand (&&) and DEFINE & UNDEFINE Commands
- ACCEPT and PROMPT Commands
- SET VERIFY ON / SET VERIFY OFF Commands
Using Oracle Single-Row Functions to Customize the Query Outputs
- Introduction to Oracle Single-Row Functions
- Character Functions
  - Case Conversion Functions
    - UPPER Function
    - LOWER Function
    - INITCAP Function
  - Character Manipulation Functions
    - SUBSTR Function in SQL
    - LENGTH Function in SQL
    - CONCAT Function in SQL
    - INSTR Function in SQL
    - TRIM Function in SQL
    - LTRIM and RTRIM Functions in SQL
    - REPLACE Function in SQL
    - LPAD and RPAD Functions in SQL
  - Numeric Functions
    - ROUND Function in SQL
    - TRUNC Function in SQL
    - CEIL Function in SQL
    - FLOOR Function in SQL
    - MOD Function in SQL
  - Nested SQL Group Functions
  - Date Data Types and SQL Date Functions
    - Date Data Types
      - DATE Data Type in SQL
      - TIMESTAMP Data Type in SQL
      - TIMESTAMP WITH TIME ZONE Data Type in SQL
      - TIMESTAMP WITH LOCAL TIME ZONE Data Type in SQL
    - Oracle Date Functions
      - SYSDATE Function in SQL
      - CURRENT_DATE Function in SQL
      - SESSIONTIMEZONE Function in SQL
      - SYSTIMESTAMP Function in SQL
      - CURRENT_TIMESTAMP Function in SQL
    - Date Manipulation Functions
      - ADD_MONTHS Function
      - MONTHS_BETWEEN Function
      - ROUND Function
      - TRUNC Function
      - EXTRACT Function
      - NEXT_DAY Function
      - LAST_DAY Function
Oracle Conversion Functions
- TO_CHAR Function in SQL
- TO_NUMBER Function in SQL
- TO_DATE Function in SQL
- Null Related Functions in SQL
  - NVL Function
  - NVL2 Function
  - NULLIF Function
  - COALESCE Function
Conditional Expressions in SQL
- CASE Expressions in SQL
- DECODE Function in SQL
Reporting Aggregated Data Using the Group Functions
- Introduction to Oracle Group Functions
- AVG Function in SQL
- COUNT Function in SQL
- MAX Function in SQL
- MIN Function in SQL
- LISTAGG Function in SQL
- Overview of Group Functions in SQL
Displaying Data from Multiple Tables Using Joins
- What is a SQL Join?
- Join Types in Oracle SQL
- How to Create a Join in SQL
- Natural Join
- Join with the USING Clause
- Handling Ambiguous Column Names While Joining Multiple Tables
- Inner Join (Join with the ON Clause)
- Multiple Join Operations
- Restricting Joins
- Self-Join
- Non-Equijoins (Joining Unequal Tables)
- Outer Joins in SQL
  - LEFT OUTER JOIN (LEFT JOIN)
  - RIGHT OUTER JOIN (RIGHT JOIN)
  - FULL OUTER JOIN (FULL JOIN)
- Cross Join (Cartesian Product or Cross Product)
- Oracle's Old Style Join Syntax (Comparison of ANSI vs. Non-ANSI SQL Join Syntaxes)
Using & Building & Analyzing Subqueries
- What is a Subquery in SQL?
- How to Use Subqueries in SQL?
- Subquery Types in SQL:
  - Single-Row Subqueries in SQL
  - Multiple-Row Subqueries in SQL
  - Multiple-Column Subqueries in SQL
  - SCALAR Subqueries in SQL
  - Correlated Subqueries in SQL
- Using Subqueries as a Table
- Using the EXISTS Operator (Semijoins in SQL)
- Using the NOT EXISTS Operator
Working with Oracle SET Operators
- What are SET Operators and Why are They Used?
- UNION Operator
- UNION ALL Operator
- MINUS Operator
- INTERSECT Operator
- Combining Multiple Queries Using Multiple SET Operators in Complex SQL Queries
Using Data Manipulation Language (DML) Statements
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- MERGE Statement
- Multiple INSERT Statements
- Unconditional INSERT (INSERT ALL) Statements
- Conditional INSERT ALL Statements
- Conditional INSERT FIRST Statements
- Pivot Insert in SQL
Using Transaction Control Language (TCL) Statements
- What is a transaction in SQL?
- TCL Commands
- COMMIT and ROLLBACK Statements in SQL
- Row Locking Mechanism in SQL
- SAVEPOINT Statement in SQL
- FOR UPDATE Statement in SQL
Using Data Definition Language (DDL) Statements
- What are Data Definition Language Statements
- Naming Rules & Naming Conventions in Oracle
- Creating Tables using the CREATE TABLE statements
- CREATE TABLE AS SELECT (CTAS) Statement in Oracle
- ALTER TABLE Statement
- Marking Columns Unused (Using The SET UNUSED Clause)
- READ-ONLY Tables in SQL
- DROP TABLE Statement
- TRUNCATE TABLE Statement
- COMMENT Statement
- RENAME Statement
Creating, Using, Working, and Managing Constraints
- What is a Constraint in SQL?
- Oracle Constraint Types
- NOT NULL Constraint
- UNIQUE Constraint
- PRIMARY KEY Constraint
- FOREIGN KEY Constraint
- The ON DELETE CASCADE Clause
- The ON DELETE SET NULL Clause
- CHECK Constraint
- Adding Constraints via ALTER TABLE Statements
- Dropping (Removing) Constraints
- Cascading Constraints in Oracle
- Renaming Constraints
- Enabling / Disabling Constraints
- Status of Constraints
- Deferring (Deferrable) Constraints
Creating, Using, and Managing Database Views in Detail
- What is a Database View and What is it Used for?
- View Types in Oracle
- Creating Simple Views
- Creating Complex Views
- Modifying Views
- Performing DML Operations with Views
- Using the WITH CHECK OPTION Clause in SQL
- Using the WITH READ ONLY Clause on Views
Managing Objects Using Oracle Data Dictionary Views
- What are Data Dictionary views in Oracle?
- The DICTIONARY View (The Main Dictionary)
- USER, ALL, DBA, and V$ Prefixes in Data Dictionary Views
- USER_OBJECTS, ALL_OBJECTS, and DBA_OBJECTS Views
- USER_TABLES, ALL_TABLES, and DBA_TABLES Data Dictionary Views
- USER_TAB_COLUMNS Data Dictionary View
- USER_CONSTRAINTS Data Dictionary View
- USER_CONS_COLUMNS Data Dictionary View
- USER_VIEWS Data Dictionary View
- USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views
Creating and Using, Working with Sequences in SQL
- What is a Sequence?
- Creating Sequences
- Modifying Sequences
- Using Sequences
- Using Sequences as Default Values
- Sequence Caching
- The USER_SEQUENCES View
- Using the IDENTITY Column in Oracle
Creating and Using Synonyms
- What is a Synonym in SQL
- Creating, Using, and Dropping Synonyms
- Analyzing The USER_SYNONYMS View
Working with Indexes in SQL
- What is an Index in SQL
- Index Types in SQL
- How to Create Indexes in SQL
- How to Create Indexes While Table Creation
- How to Remove (Drop) Indexes
- Function-Based Indexes
- Multiple Indexes on the Same Columns & Invisible Indexes
- Analyzing the USER_INDEXES and USER_IND_COLUMNS Views
- How to Modify (Alter) Indexes
Managing Oracle Privileges, Roles, and Schema Objects
- What are Privileges in SQL
- How to Create a User in Oracle Database
- Changing Database Users' Passwords in Oracle Database
- Granting System Privileges
- Roles and PUBLIC in Oracle Database
- Granting Object Privileges
- Definer's Rights and Invoker's Rights
- Revoking Privileges and Roles
- Searching Privileges Using Data Dictionary Views
Retrieving Data By Using Subqueries
Manipulating Data By Using Subqueries
Controlling User Access in Details
Managing Data in Different Time Zones

BENEFITS OF TAKING THIS SQL COURSE:

Knowing SQL can get you a better job or improve the one you have, and it can earn you 250k+ (USD) per/year in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier. This is why it's so popular and backed by Oracle.

This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL code easily and think analytically against any problem in your company.

STUDENT REVIEWS PROVE THIS COURSE'S WORTH:

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high-quality audio/video.

Check out all of the great reviews in the review section ... a lot of happy students :-)

IMPORTANT NOTE:

Knowing SQL is "mandatory" for any IT Professional and having good SQL knowledge will be a "GREAT PLUS" for you!

If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you!

So let’s do this!

I'll see you in the first lecture!

Who this course is for:

Anyone willing to step into the software development career!
Anyone dreaming to get a well-paid SQL Development Job!
Anyone planning to Pass the Oracle 1Z0-071 (OCA) exam!
Anyone who wants to Become an in-demand SQL Professional!

The Complete Oracle SQL Bootcamp (2026)

What you'll learn

Explore related topics

Coding Exercises

Course content

Database Concepts12 lectures • 1hr 5min

Software Download & Installation18 lectures • 2hr 29min

Retrieving Data24 lectures • 1hr 36min

Restricting Data17 lectures • 1hr 23min

Sorting Data10 lectures • 57min

Using Substitution Variables8 lectures • 52min

Single-Row Functions20 lectures • 3hr 1min

Conversion Functions8 lectures • 1hr 6min

Conditional Expressions4 lectures • 33min

Group Functions15 lectures • 51min

Requirements

Description

Who this course is for: