The Ultimate Oracle SQL Course
4.6 (886 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,703 students enrolled

The Ultimate Oracle SQL Course

Practical, Complete, Hands-On Oracle SQL training that will help you become an Oracle SQL genius. Updated for Oracle 18c
4.6 (887 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,703 students enrolled
Last updated 6/2020
English
English
Current price: $15.99 Original price: $199.99 Discount: 92% off
5 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 11.5 hours on-demand video
  • 17 articles
  • 74 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be able to use SQL to retrieve, filter, analyze, format and present information from Oracle databases.
  • You will be able to use SQL to insert, modify and delete information from Oracle databases.
  • You will understand SQL code written by other people and feel confident to modify it.
  • You will be able to write the SQL code needed to solve the most common problems found in real work situations and academic tests.
  • Please note that PL/SQL is not covered in this course.
Course content
Expand all 118 lectures 12:55:37
+ Course Introduction
2 lectures 10:53


Watch this lecture to get a clear picture of what will be covered in the course.

Preview 07:05

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

How to take Full Advantage of the Course
03:48
+ Environment Setup
7 lectures 37:27

Watch this lecture to understand what is covered in this section and get any pertinent recommendations.

Preview 02:42

You are recommended to watch this lecture even if you are going to use a local Oracle database to take the course.  You must watch it if you plan to take the course from your internet browser, without installing a local database.

How to take the course without installing any program
08:43

In this article you will find another way to take the course from your internet browser, without installing any additional software on your computer.  There are two ways to take the course from the browser, the first one is described in the previous lesson, and this is the second one.

You need only one of the options.  I decided to show you both, so that you can decide which one you like or works better for you.

Another way to take the course without installing anything
02:35

Watch this lecture for instructions on how to download and install the Oracle Database software, which you will use to start learning SQL.

Downloading and installing Oracle Database Express Edition 18c
12:52

This lesson explains the options you have to take the course using a Mac. It was added because the Oracle database cannot be installed directly on a computer running Mac OS.X (now macOS).

Taking the Course on a Mac
02:08

Watch this lecture for instructions on how to download and install Oracle SQL Developer

Downloading and installing Oracle Sql Developer
04:34

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.

Oracle Sql Developer Basics
03:53
+ Basic Concepts
6 lectures 26:39

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.

Introduction
00:44

This lecture covers the most basic database concepts, which you really need to know before starting to learn Oracle SQL

Basic Database Concepts
07:29

This is a short lecture that introduces you to the SQL language

What is SQL?
03:50

This lesson contains a high level overview of the Oracle Database architecture and some other basic Oracle concepts.

Basic Oracle Database Concepts and Architecture
05:19

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.

The Multitenant Architecture (New!)
05:10

This lecture explains the most basic and important peculiarities you need to know about Oracle databases.

Basic Oracle Database Peculiarities
04:07
+ Retrieving information from the Database (The SELECT statement)
6 lectures 25:57

Watch this lecture to understand what is covered in this section and get any pertinent recommendations.

Introduction to retrieving information from an Oracle database.
01:03

This lecture guides you through the process of creating the tables you will use to practice the contents of the first practical lectures.

Creating the first Test Tables
04:56

In this lecture you will learn about the most commonly used data types in Oracle databases.

Basic Oracle Datatypes
05:54

In this lecture you will be introduced to the SELECT statement.

The SELECT Statement in its Simplest Form
08:26

In this lecture you will learn why aliases are important and how to use them.

Column and Table Aliases in Oracle
04:37

Congratulations on finishing the section!

Now, take this quiz before moving to the next lesson ;)

Section Quiz (RIFD)
1 question
Solution to the practice challenges in this section (RIFD)
01:01
+ Filtering and Sorting Results
7 lectures 49:25

Watch this lecture to understand what is covered in this section and get any pertinent recommendations.

Introduction to filtering and sorting results from Oracle SQL queries.
00:47

Here you will start learning how to filter the results of you queries by using the WHERE clause

Preview 05:45

Here you will learn how to use more complex conditions to filter the results of your Oracle SQL queries.

More complex WHERE Conditions
09:20

In this lecture you will learn how and when to use the DISTINCT clause

Preview 04:14

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)
09:10

A very important lesson that covers the concept of NULL and how to handle it in Oracle.

Understanding and Handling NULLs
17:33

Congratulations!  You know everything you need to know about filtering and sorting results!

To confirm that the previous statement is true, go ahead and take this quiz.

Section Quiz (FSR)
3 questions
Solution to the practice challenges in this section (FSR)
02:36
+ Operators
6 lectures 33:22

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.

Introduction to the use of Operators in Oracle SQL.
00:42

Here you will learn how the comparison operators work in Oracle SQL

Comparison Operators (=,<,>,ANY,ALL)
02:42

Here you will learn how the SQL operators work in Oracle SQL

SQL Operators (LIKE, IN, BETWEEN, IS NULL)
08:24

Here you will learn how the logical operators work in Oracle SQL

Logical Operators (AND, OR, NOT)
09:49

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.

Substitution Variables
06:23

Congratulations on your progress!

Take this quiz before moving to the Group Operations section.

Section Quiz (O)
1 question
Solution to the practice challenges in this section (O)
05:22
+ Group Operations
5 lectures 25:58

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".

Introduction to Group Operations in Oracle SQL.
00:47

In this lecture you will be introduced to group operations and will learn how to use aggregate functions in Oracle SQL.

Aggregate Functions (MIN, MAX, SUM, COUNT, AVG)
08:12

Here you will learn how to group rows by using the GROUP BY clause.  A very important topic.

Grouping Rows (The GROUP BY Clause)
09:07

Here you will learn how to filter the results of grouped queries by using the HAVING clause

Filtering Group Results (HAVING Clause)
05:49

Great to see you continue making progress!

Here is the quiz for the Group Operations section.  Enjoy!

Section Quiz (GO)
1 question
Solution to the practice challenges in this section (GO)
02:03
+ Subqueries
8 lectures 01:01:18

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".

Introduction to Subqueries in Oracle SQL.
00:57

In this lecture you will be introduced to subqueries and will understand what they are and how they work in Oracle SQL

Preview 11:49

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!

Common Questions About Subqueries
10:26

Here you will learn about the type of subqueries that are known as "inline views"

Inline Views
02:37

Here you will learn about the subquery factoring clause in Oracle SQL.  This is a very important and powerful clause.

Subquery Factoring (The WITH Clause)
09:36

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

Top-N Queries (And Intro to ANALYTIC Functions)
11:03

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.

The Row Limiting Clause (New!)
08:25

Let's see how much you learnt about subqueries!

Here is a short quiz for you.  Enjoy!

Section Quiz (S)
3 questions
Solution to the practice challenges in this section (S)
06:25
+ Functions
11 lectures 01:33:40

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.

Introduction to Single Row Functions in Oracle SQL.
00:56

In this lecture you will be introduced to single-row functions

What is a Function?
01:40

Here you will learn how and when to use the most common text functions available in Oracle.

Text Functions
14:52

Here you will learn how and when to use the most common numeric functions available in Oracle.

Numeric Functions
04:43

Here you will learn how and when to use the most common date functions available in Oracle.

Date Functions
11:01

In this and the next lecture you will learn about conversion functions, which are very, very important.

Conversion Functions Part 1
11:13
Conversion Functions Part 2
08:07

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.

Implicit Conversions Are Evil!
12:47

In this lecture you will learn 2 different methods to implement IF-THEN-ELSE logic in Oracle SQL statements

The DECODE Function and CASE Expressions
10:13

Here you will learn how to make date calculations in Oracle SQL without using functions.

Date Arithmetic
04:21

Let's confirm that you are ready to move out of the Functions section, by taking this short quiz.

Ready?

Section Quiz (F)
5 questions
Solution to the practice challenges in this section (F)
13:47
+ Transposing Rows into Columns and Columns into Rows
5 lectures 26:21

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.

Introduction
01:10

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.

Solving the Problem with the Traditional Method
06:00

Watch this lecture to understand how to use the awesome Pivot feature of Oracle SQL

Pivot
06:37

Watch this lecture to understand how to use the awesome Unpivot feature of Oracle SQL

Unpivot
10:12

Let’s see how much you learned in this section!

Section Quiz (TRC)
3 questions
Solution to the practice challenges in this section (TRC)
02:22
Requirements
  • If you want to install your own 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).
  • If you don’t have a computer where you can install and run applications, or you don’t want to do that, you can take the whole course and do all the coding exercises from any device with internet access, from the browser (this includes tablets and even smart phones).
  • You should have a real desire to learn, and time to watch the lectures and practice the concepts as suggested by the instructor.
  • Ideally you should have taken the free Udemy course “Oracle SQL Developer : Tips and Tricks”, because knowing how to use SQL Developer would be of great help in your SQL learning process.
Description

Updated for Oracle 18c !  (Now covers Oracle 11g, 12c and 18c)

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.

In spite of what you might have heard, relational databases are not going away anytime soon, and the demand for good Oracle SQL developers will continue on the rise.

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

  • Understand the most basic concepts about relational databases and Oracle.

  • Learn how to read, filter and sort information from database tables.

  • Learn how to use comparison, logical, set and other type 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.

  • Learn how to use SQL to create and use tables, constraints, sequences, indexes and views.

  • Get tips and knowledge that is usually only learned through years of SQL experience.

  • Much more.


Oracle  implementation of SQL is very powerful. Learn it and use it smartly and stand out from the crowd.

I created this course because although there are many courses about Oracle SQL available on different platforms and in different formats, most of them, 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 the instructor, but unfortunately, such 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.

In addition to that, most SQL courses, if not all, teach you the same kind of content you would find in a text book, but, what about those things that are not part of the “official” curriculum and are only learned through experience?

The goal of this course is to help you learn Oracle SQL in a way that can make you stand out from the crowd. I really want you to learn and shine, and at the same time contribute with my grain of sand to bring more talented people to the IT industry.  I want to help you become a standout Oracle SQL developer.

Content and Overview:

This course was designed with beginners in mind, but if you have some previous SQL knowledge you will still learn a lot.  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 be gradually progressing to more advanced concepts.

It does not include demonstration lectures because the whole course is a coding demonstration. In 90% of the video lectures you will be watching my computer screen while I type, explain and run 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.

You are hiring me to teach you Oracle SQL, and that is what I am going to do, and I will do my best to help you learn in a way that can really make you stand out from the crowd of thousands of people who start learning SQL every day.

I will not only teach you SQL. I will share my years of Oracle experience with you through what I call “experience tips”. Those tips can really help you differentiate.

And you don’t even need to have a computer on which you can install Oracle software to take the course. I will show you how you can watch the whole course and do practically all the coding exercises from your browser, without needing to install anything, if that is what you need or want.

Oracle SQL is very powerful, and you are about to start learning it!

You could be 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.

Who this course is for:
  • Aspiring application or database developers looking to acquire solid SQL knowledge to improve their careers.
  • College/University students who need SQL knowledge to pass their database-related courses.
  • Anyone with only basic SQL knowledge wanting to solidify their skill and use the language with confidence.
  • This course is not for you if you are already an experienced 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.