Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Oracle SQL - The Ultimate Course: SQL Made Practical

From beginner or intermediate to SQL genius: A Hands-On Oracle SQL training to Become a Professional SQL Developer.

Created byCarlos DL, Standout-Dev Academy

Last updated 2/2025

English

What you'll learn

Learn SQL by actually practicing with lots of real-world exercises and challenges.
Use Oracle SQL to retrieve, filter, analyze, format and present information from Oracle databases.
Create tables, constraints, indexes, views, and many other types of database objects.
Use SQL to insert, modify and delete information from Oracle databases.
Write the SQL code needed to solve the most common problems found in real work situations and academic tests.
Learn some advanced topics like Analytic Functions, Hierarchical Queries, and others.
Please note that PL/SQL is not covered in this course.

Coding Exercises

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

Course content

20 sections • 212 lectures • 16h 20m total length

Welcome to the Course and Curriculum Overview5:33

Watch this lecture to get a clear picture of what will be covered in the course.
Use Udemy's Features Wisely!2:41
Just a short video recommending how to use a few Udemy's features, to make sure you have a good experience taking this course.
Let’s run some SQL code right away!7:53
Let's have some early fun writing code!
How to take Full Advantage of the Course3:48
You should want to take full advantage of the investment you made by enrolling in the course. This lecture will give you the most important recommendations about what you need to do to take full advantage of the course
IMPORTANT: Practice Challenges and Coding Exercises2:24

Introduction2:42
Watch this lecture to understand what is covered in this section and get any pertinent recommendations.
How to take the course without installing any program5:34
You must watch it if you plan to take the course from your internet browser, without installing a local database.
Setting Up and using Apex to take the course on the browser5:06
Using Live SQL to take the course on the browser7:18
Downloading and installing Oracle Database Express Edition 18c12:15
Watch this lecture for instructions on how to download and install the Oracle Database software, which you will use to start learning SQL.
Taking the Course on a Mac or Windows "Home" Computer9:40
This lesson explains the options you have to take the course using a Mac or a Windows "Home" edition computer. It was added because the Oracle database cannot be installed directly on a computer running Mac OS.X (now macOS) or Windows Home..
Downloading and installing Oracle Sql Developer4:34
Watch this lecture for instructions on how to download and install Oracle SQL Developer
Oracle Sql Developer Basics7:47
Watch this lecture for the very basics on how to use Oracle SQL Developer. You can safely skip this lesson if you already took my "Oracle SQL Developer : Tips and Tricks" course.

Introduction0:44
Watch this lecture to understand what is covered in this section and get any pertinent recommendations. This section covers the basic concepts about databases, which are really vital to learn SQL correctly.
Basic Database Concepts (Tables, rows, columns, primary and foreign keys, etc)7:29
This lecture covers the most basic database concepts, which you really need to know before starting to learn Oracle SQL
What is SQL?4:01
This is a short lecture that introduces you to the SQL language
Basic Oracle Database Concepts and Architecture (Database, Instance, Storage...)5:19
This lesson contains a high level overview of the Oracle Database architecture and some other basic Oracle concepts.
The Multitenant Architecture5:10
In this lesson you will learn about the "multitenant" architechture, which was introduced in Oracle 12c, and is now included in the Express Edition 18c.
Basic Oracle Database Peculiarities4:07
This lecture explains the most basic and important peculiarities you need to know about Oracle databases.
Section Recap (BC)2:34

Introduction to retrieving information from an Oracle database.1:03
Watch this lecture to understand what is covered in this section and get any pertinent recommendations.
Creating the first Test Tables7:15
This lecture guides you through the process of creating the tables you will use to practice the contents of the first practical lectures.
Basic Oracle Datatypes (NUMBER, VARCHAR2, DATE, LOB, etc)5:54
In this lecture you will learn about the most commonly used data types in Oracle databases.
The SELECT Statement in its Simplest Form (SELECT and FROM clauses)7:49
In this lecture you will be introduced to the SELECT statement.
Practice Challenge: Basic SELECT Statement0:18
Column and Table Aliases in Oracle4:02
In this lecture you will learn why aliases are important and how to use them.
Section Quiz (RIFD)
Solution to the practice challenges in this section (RIFD)1:01
Section Recap (RIFD)2:11

Introduction to filtering and sorting results from SQL queries.0:47
Watch this lecture to understand what is covered in this section and get any pertinent recommendations.
Filtering Results (Introducing the WHERE Clause)5:18
Here you will start learning how to filter the results of you queries by using the WHERE clause
Practice Challenge: Filtering Results0:11
More complex WHERE Conditions6:26
Here you will learn how to use more complex conditions to filter the results of your Oracle SQL queries.
Practice Challenge: More complex WHERE Conditions0:22
Solution to the More Complex Conditions Challenge4:36
Watch this video to see how I solved the practice challenge from the "More Complex WHERE Conditions" lesson.
Filtering Duplicate Rows (DISTINCT Clause)5:22
In this lecture you will learn how and when to use the DISTINCT clause
Ordering the Results (ORDER BY Clause) Part 16:12
This lecture teaches you how to order the results of your queries by using the ORDER BY clause in Oracle.
Ordering the Results (ORDER BY Clause) Part 25:26
Understanding and Handling NULLs6:02
A very important lesson that covers the concept of NULL and how to handle it in Oracle.
Practice Challenge: Understanding and Handling NULLs0:24
Understanding and Handling NULLs Part 24:18
NULL-handling Functions in Oracle SQL (NVL, COALESCE)9:10
Practice Challenge: NULL-handling Functions in Oracle SQL0:26
NULL-handling Functions in Oracle SQL Part 2 (NVL2, NULLIF, LNNVL)6:46
Practice Challenge: NULL-handling Functions in Oracle SQL Part 21:01
Section Quiz (FSR)
Solution to the practice challenges in this section (FSR)5:19
Section Recap (FSR)4:08
Coding Exercise: Filtering and Sorting Results

Introduction to the use of Operators in SQL.0:42
Watch this lecture to understand what is covered in this section and get any pertinent recommendations. In this section you will learn everything about conditions and operators.
Comparison Operators (=,<,>,ANY,ALL)4:00
Here you will learn how the comparison operators work in Oracle SQL
SQL Operators (LIKE, IN, BETWEEN, IS NULL)9:34
Here you will learn how the SQL operators work in Oracle SQL
Practice Challenge: SQL Operators0:38
Logical Operators (AND, OR, NOT)8:30
Here you will learn how the logical operators work in Oracle SQL
Practice Challenge: Logical Operators0:17
Substitution Variables6:10
In this lecture you will learn how to use substitution variables in tools like SQL Developer or SQL*Plus to create generic or parameterized SQL statements.
Practice Challenge: Substitution Variables0:57
Section Quiz (O)
Solution to the practice challenges in this section (O)5:51
Section Recap (O)2:34
Coding Exercise: Operators

Introduction to Group Operations in SQL.0:47
Watch this lecture to understand what is covered in this section and get any pertinent recommendations. This section covers the very important topic of "Group Operations".
Aggregate Functions (MIN, MAX, SUM, COUNT, AVG)7:38
In this lecture you will be introduced to group operations and will learn how to use aggregate functions in Oracle SQL.
Practice Challenge: Aggregate Functions0:16
Grouping Rows (The GROUP BY Clause)8:23
Here you will learn how to group rows by using the GROUP BY clause. A very important topic.
Practice Challenge: Grouping Rows0:10
Filtering Group Results (HAVING Clause)5:43
Here you will learn how to filter the results of grouped queries by using the HAVING clause
Practice Challenge: Filtering Group Results0:17
Section Quiz (GO)
Solution to the practice challenges in this section (GO)2:03
Section Recap (GO)1:53
Coding Exercise: Group Operations

Introduction to Subqueries in Oracle SQL.0:57
Watch this lecture to understand what is covered in this section and get any pertinent recommendations. This section covers the very interesting topic of "Subqueries".
Understanding Subqueries11:20
In this lecture you will be introduced to subqueries and will understand what they are and how they work in Oracle SQL
Practice Challenge: Subqueries0:15
Common Questions About Subqueries10:27
Based on the feedback from some of you, I decided to add this new lesson to answer a couple of common questions about subqueries. Enjoy it!
Inline Views2:09
Here you will learn about the type of subqueries that are known as "inline views"
Practice Challenge: Inline Views0:11
Subquery Factoring (The WITH Clause)9:07
Here you will learn about the subquery factoring clause in Oracle SQL. This is a very important and powerful clause.
Practice Challenge: Subquery Factoring0:20
Top-N Queries (And Intro to ANALYTIC Functions)10:32
Watch this lecture to understand how to write TOP-N queries correctly, using different methods. Here you will also be introduced to the amazing world of Analytic Functions in Oracle SQL
Practice Challenge: Top-N Queries0:24
The Row Limiting Clause (FETCH FIRST n ROWS, OFFSET, etc)8:10
In this lesson you will learn about the ROW LIMITING clause, which was introduced in Oracle 12c, and is now available in the express edition version 18c.
Practice Challenge: The Row Limiting Clause0:32
Section Quiz (S)
Solution to the practice challenges in this section (S)5:57
Section Recap (S)4:01
Coding Exercise: Subqueries
Coding Exercise: Subqueries Part 2

Introduction to Single Row Functions in Oracle SQL.0:56
Watch this lecture to understand what is covered in this section and get any pertinent recommendations. This section covers Single Rows Functions, Case Expressions and Date Arithmetic.
What is a Function?3:34
In this lecture you will be introduced to single-row functions
Text Functions (SUBSTR, REPLACE, INSTR, LENGTH, TRANSLATE, UPPER, LOWER, etc)14:33
Here you will learn how and when to use the most common text functions available in Oracle.
Practice Challenge: Text Functions0:53
Numeric Functions (TRUNC, ROUND, FLOOR, CEIL, SIGN, MOD, etc)4:19
Here you will learn how and when to use the most common numeric functions available in Oracle.
Practice Challenge: Numeric Functions0:18
Date Functions (ADD_MONTHS, LAST_DAY, MONTHS_BETWEEN, NEXT_DAY, etc)10:35
Here you will learn how and when to use the most common date functions available in Oracle.
Practice Challenge: Date Functions0:35
Conversion Functions Part 1 (TO_CHAR, TO_NUMBER, format models, errors, etc)11:13
In this and the next lecture you will learn about conversion functions, which are very, very important.
Conversion Functions Part 2 (TO_DATE, CAST, VALIDATE_CONVERSION, etc)7:32
Practice Challenge: Conversion Functions1:17
Implicit Conversions Are Evil!12:01
This is a very important lesson which is an experience tip in itself. Implicit conversions are very dangerous, but this lesson will teach what you need to know about them, and how to avoid them.
The DECODE Function and CASE Expressions9:40
In this lecture you will learn 2 different methods to implement IF-THEN-ELSE logic in Oracle SQL statements
Practice Challenge: The DECODE Function and CASE Expressions0:58
Date Arithmetic4:30
Here you will learn how to make date calculations in Oracle SQL without using functions.
Practice Challenge: Date Arithmetic0:22
Section Quiz (F)
Solution to the practice challenges in this section (F)13:47
Section Recap (F)9:04
Coding Exercise: Functions and CASE Expressions

Introduction1:10
Watch this lecture to understand what is covered in this section and get any pertinent recommendations. This section focuses on a specific type of problems in which you need to transpose rows into columns or columns into rows, and teaches you the 2 basic methods we have to solve them.
Solving the Problem with the Traditional Method6:00
In this lecture you will understand the problem and will learn how to solve it using the traditional method, which includes the use of CASE expressions.
Pivot6:37
Watch this lecture to understand how to use the awesome Pivot feature of Oracle SQL
Practice Challenge: Pivot0:10
Unpivot8:31
Watch this lecture to understand how to use the awesome Unpivot feature of Oracle SQL
Practice Challenge: Unpivot0:24
Section Quiz (TRC)
Solution to the practice challenges in this section (TRC)2:22
Section Recap (TRC)4:17

Requirements

No prior Oracle SQL knowledge is required. You will learn Oracle SQL from scratch (if that is what you need).
If you want to install your own Oracle SQL database, you will need a computer running Windows or Linux, where you can install and run applications (A computer running Mac OS X can be used as well, but you will need to run your database software on a virtual machine).
You should have a real desire to learn Oracle SQL and time to watch the lectures and practice the concepts as suggested by the instructor.

Description

* Covers Oracle Database 11g, Oracle 12c, Oracle 18c, and Oracle 19c

Oracle is currently the most popular relational database management system in the world. It is used by thousands of big companies who are usually willing to pay good salaries to the right people, which includes those with practical Oracle SQL knowledge that is based on best practices and experience.

Most SQL courses give you theoretical SQL knowledge. In this course, you will learn by actually writing code.

What do other learners say about this course?

Shruti says: “It was such an amazing course. Absolutely a beginner friendly course”.
Daniel says “Excellent match. In spite of knowing sql for more than a decade, learnt a loooot of new stuff.”
David says: “Really well explained! Love the energy of the instructor!”.
Scott says: “This is an incredible course! I love how the instructor Carlos presents topics very clearly, but also challenges students in the quizzes and practice challenges. Too many courses out there contain practice challenges that are exact replicas of what was just taught, which are too easy and limit growth of the student. I have no suggestions for improvement on the course content and presentation, as it was simply perfect in my opinion. ... I would rate this course higher than 5 stars if that were possible. Thank you Carlos!”
Thomas says: “Honestly, I've seen some good udemy courses... This course is one of the best structured iv'e seen. It places a priority on the practice challenges that allows the quality of the course to rival a university course ... Great instruction, great value for the course!”
Roshan says: “great course to cover all the fundamentals, great for interview preparations.”
Paul says “This course is very thorough, and Carlos is a skilled instructor!”
Radu says “Very clear course, concise presentation, excellent tips, very good pronunciation, captions without errors, lots of exercises for practice... Thank you for the excellent course, Carlos.”

Learn Oracle SQL in a practical and smart way and jump-start your career as an Oracle SQL developer:

Learn everything about the SELECT statement including the FROM, JOIN, WHERE, GROUP BY, HAVING, OVER, PIVOT and all other related clauses.
Learn how to use all types of operators in Oracle SQL.
Learn how to use numeric, text, date, conversion, aggregate, analytic, and other types of Oracle SQL functions.
Learn how to add, modify, and delete information from Oracle databases using SQL by means of the UPDATE, DELETE, MERGE and other kinds of statements.
Learn how to use SQL to create and use tables, constraints, sequences, indexes, and views.
Solve interesting and challenging problems by actually writing Oracle SQL code, which will improve your learning and retention, and will give you confidence to put your skills to work in real life situations.
Get tips and knowledge that is usually only learned through years of SQL experience.
Much more.

Carlos created this course because most courses, if not all, focus too much on “telling” or “demonstrating” how to do things, but don’t give you, as a student, the opportunity to test and practice what is being taught. Some of them tell you to practice or to do things along with the instructor, but unfortunately, such an approach doesn’t really work. Seeing how things are done or just copying or repeating what you see on the screen is not going to help you learn SQL. You might feel that you are learning, but when the time comes for you to write a command on your own, you are most likely not going to feel very confident.

Here you will learn and practice much more than just SQL basics.

Content and Overview:

This course will not only help beginners learn the SQL language. If you already have previous SQL knowledge, you will also learn a lot of new concepts, features and techniques that will make you an even better SQL developer.

After setting the learning environment, it starts with the most basic concepts about databases in general and a very short introduction to Oracle and the SQL language.

You will start learning about the simplest SQL statements, and before you even notice it, you will have covered all the SQL basics and will be gradually progressing to more advanced concepts.

The course includes several topics that some people, including experienced developers and other instructors, consider advanced, such as Analytic Functions, Hierarchical Queries, Pivot and Unpivot features, and many more.

It does not include demonstration lectures because the whole course is a coding demonstration. In 90% of the video lectures, you will be watching the instructor's computer screen while he types, explains, and runs Oracle SQL code.

It does not include labs at the end of each section because practically every lesson has a coding task for you to practice what you are learning.

Please note that PL/SQL (Oracle's procedural language) is not covered in this course.

The instructor will not only teach you SQL. He will share his decades of Oracle experience with you through what he calls “experience tips”. Those tips can really help you differentiate and stand out.

Final words from the instructor:

You could enjoy being seen as an experienced and knowledgeable SQL developer by your friends, peers, and potential employers in a very short time, but you have to take action. If you want my help, you’ve got it.

-Carlos, founder of the Standout-Dev Academy.

Who this course is for:

Application or database developers looking to acquire solid SQL knowledge to accelerate their careers.
Anyone with existing SQL knowledge wanting to solidify their skill and use the language with confidence.
Anyone with prior SQL experience in a different RDBMS wanting to learn the most useful Oracle-specific features of the language.
College/University students who need SQL knowledge to pass their database-related courses.
This course is not for you if you are already an experienced Oracle SQL developer looking to learn the most advanced features of the language.
This course is not for you if you are looking for a theoretical course.

Oracle SQL - The Ultimate Course: SQL Made Practical

What you'll learn

Explore related topics

Coding Exercises

Course content

Course Introduction5 lectures • 22min

Environment Setup8 lectures • 55min

Basic Database and SQL Concepts7 lectures • 29min

Retrieving information from the Database using SQL (The SELECT statement)8 lectures • 30min

Filtering and Sorting Results in SQL18 lectures • 1hr 12min

Operators used in SQL10 lectures • 39min

Group Operations in SQL9 lectures • 27min

Subqueries in SQL14 lectures • 1hr 4min

Single Row SQL Functions18 lectures • 1hr 46min

Transposing Rows into Columns and Columns into Rows with SQL8 lectures • 30min

Requirements

Description

Who this course is for: