Oracle SQL From Scratch

Learn Oracle SQL with this intensive hands-on training. Become a standout Oracle SQL developer. * 85% off
4.6 (18 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
123 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 85
  • Length 10 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2016 English

Course Description

- Currently 85% off from the normal sale price -

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:

  • Understand the most basic concepts about relational databases.
  • 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.
  • Learn how to create and use tables, constraints, sequences, indexes and views.
  • Get tips and knowledge that is usually only learned through years of 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 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.

Content and Overview:

This course was designed with beginners in mind, but if you have some previous 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 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.

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

What are the 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.

What am I going to get from this course?

  • You will be able to use SQL to retrieve, filter, 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 SQL code needed to solve the most common problems found in real work situations and academic tests.

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
06:17


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

01:23

This is a very short video that shows you the main topics that will be covered in the course.  Use it to get a better idea of the contents, and to get excited about what you are about to start learning.

Enjoy it!

03:35

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

Section 2: Environment Setup
02:50

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

08:11

You are recommended to watch this lecture even if you are going to use a local 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.

Article

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.

07:30

Watch this lecture for instructions on how to download and install the Oracle Database software

Article

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

09:40

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

03:29

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.

Section 3: Basic Concepts
00:50

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.

07:29

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

03:50

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

03:47

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

Section 4: Retrieving information from the Database (The SELECT statement)
01:30

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

04:38

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

04:57

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

08:26

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

04:07

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

Section 5: Filtering and Sorting Results
05:02

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

09:20

Here you will learn how to use more complex conditions to filter results

04:14

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

09:10

This lecture teaches you how to order the results of you queries by using the ORDER BY clause

14:25

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

Solution to the practice challenges in this section
Article
Section 6: Operators
03:05

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

08:24

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

10:09

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

Solution to the practice challenges in this section
Article
Section 7: Group Operations
08:20

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

09:07

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

05:49

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

Solution to the practice challenges in this section
Article
Section 8: Subqueries
11:39

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

02:37

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

07:26

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

11:55

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

Solution to the practice challenges in this section
Article
Section 9: Functions
02:00

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

09:56

Here you will learn how and when to use the most common text functions

04:42

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

09:27

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

12:19

In this lecture you will learn about the very important conversion functions

10:13

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

04:57

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

12:29

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

10:12

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

Solution to the practice challenges in this section
Article
Section 10: Analytic Functions
17:16

A very important lesson that will help you understand how Analytic Functions work in Oracle
SQL

04:13

Here you will find specific examples and recommendations about COUNT, SUM, MIN and MAX, when they are used as analytic functions

07:24

A very interesting lesson about the ranking analytic functions

03:46

A short but very interesting lesson about the LISTAGG analytic function

05:32

Here you will learn how and when to use the awesome LEAD and LAG analytic functions

Solution to the practice challenges in this section
Article
Section 11: Set Operators
01:51

Here you will be introduced to SET operators and will receive some general recommendations about how to use them

10:26

A lesson that covers the UNION and UNION ALL operators in detail

02:57

A lesson that covers the INTERSECT operator in detail

03:07

Here you will learn how to use the MINUS set operator

04:36

A very important lesson on how to use more than on set operator in a single query, correctly

Solution to the practice challenges in this section
Article
Section 12: Selecting Data from More than one Table
08:44

The introduction to this very interesting and most likely long awaited section about querying more than one table in the same statement.  An initial explanation of what a JOIN is.

06:51

In this lecture you will create a more complex database schema that will allow you to write more complex queries

08:56

A very important lesson about the INNER type of joins

05:39

An explanation of the other types of joins that exist in Oracle SQL

12:09

A very important and interesting lesson about the OUTER types of joins

Solution to the practice challenges in this section
Article
Section 13: Additional Practice
Article

Here you have a lot of problems with different difficulty levels to help you practice what you have learned until this point.  You are expected to not continue to the next section until you are able to solve them all.

You will enjoy this practice session!

Section 14: Changing the Contents of Database Tables
12:28

This lecture introduces you to the section where you will learn how to UPDATE, DELETE and INSERT data into your database tables.  Here you will learn what a database transaction is and how it works in Oracle databases.

12:40

Here you will  learn how to insert new rows into a database table

14:42

Here you will  learn how to modify the existing data in a database table

06:18

Here you will  learn how to delete information from database tables

11:31

In this and the following lecture you are going to learn about the MERGE statement, which can help you simplify certain types of operations and to make them more efficient.

13:38

This is the second part of the MERGE statement.

Solution to the practice challenges in this section
Article
Section 15: Data Definition Language (DDL)
01:32

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

15:37

In this lecture you will learn how to create and drop database tables, which is a very important topic in your SQL learning process

05:02


Here you will learn how to change the definition of tables that already exist in the database.  This is important because this is a very common scenario when you work for a company, as an Oracle SQL developer

09:03

Here you will learn how to define, drop and disable the different types of constraints that exist in Oracle

11:03

Watch this lecture to learn how to create, drop and use database sequences, which is another type of object that is widely used in companies.

09:33

Here you will start learning about the fascinating world of indexes

08:00

In this part of the lesson you will complete the basic understanding and knowledge you need to
have about indexes in Oracle databases

08:50

Watch this lesson to start learning about database views.  Learn how they are and how to create and use them

07:34

In the second part of the views lesson you complete the basic knowledge you need to have about views in Oracle databases

Solution to the practice challenges in this section
Article
Section 16: Conclusion

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Carlos De Leon, Professional Software Developer & Trainer

Carlos is an experienced systems engineer with a strong passion for software development and technology in general. He has been developing enterprise software for almost 20 years, and has worked with different database management systems, which has helped him develop a complete understanding and knowledge of the SQL language and its most popular vendor-specific implementations, being Oracle where his main experience is, as he has been working with Oracle databases on a daily basis for more than a decade.

His passion for software development and his entrepreneurial spirit also took him into the mobile world, where he has developed applications for several mobile platforms in his spare time.

He's also a blogger and a regular contributor to the Oracle database community, and over the years has been known as an expert in different internet forums and IT knowledge exchange sites.

In addition to software development, he loves teaching and sharing his knowledge and experience with others, which is the reason why he joined Udemy.

If you are into software or database development, make sure to check out Carlos's courses now.

Ready to start learning?
Take This Course