The Ultimate Oracle SQL Course: SQL Made Practical from Udemy

What's inside

Learning objectives

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.
Please note that pl/sql is not covered in this course.

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.
Please note that pl/sql is not covered in this course.

Syllabus

After this section you will have a very clear picture of what the course covers and how the contents are going to be delivered, and you will know how to take full advantage of the course.

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

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 have some early fun writing code!

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 Exercises

After this section you will have you environment ready to start learning SQL, and if you can't or don't want to install any software, you will know how to take the course from your browser.

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

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 browser

Using Live SQL to take the course on the browser

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

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

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

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.

This section covers some very basic topics you need to know about Databases and SQL.

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.

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

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

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

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.

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

Section Recap (BC)

After this section you will be able to write basic SELECT statements.

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

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

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

Practice Challenge: Basic SELECT Statement

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

Congratulations on finishing the section!

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

Solution to the practice challenges in this section (RIFD)

Section Recap (RIFD)

After this section you will be able to add conditions to filter rows in your queries and sort their results.

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

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

Practice Challenge: Filtering Results

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

Practice Challenge: More complex WHERE Conditions

Watch this video to see how I solved the practice challenge from the "More Complex WHERE Conditions" lesson.

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

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 2

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

Practice Challenge: Understanding and Handling NULLs

Understanding and Handling NULLs Part 2

NULL-handling Functions in Oracle SQL (NVL, COALESCE)

Practice Challenge: NULL-handling Functions in Oracle SQL

NULL-handling Functions in Oracle SQL Part 2 (NVL2, NULLIF, LNNVL)

Practice Challenge: NULL-handling Functions in Oracle SQL Part 2

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.

Solution to the practice challenges in this section (FSR)

Section Recap (FSR)

Coding Exercise: Filtering and Sorting Results

After this section you will have a clear understanding of the different operators available in SQL and how to use them.

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.

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

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

Practice Challenge: SQL Operators

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

Practice Challenge: Logical Operators

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 Variables

Congratulations on your progress!

Take this quiz before moving to the Group Operations section.

Solution to the practice challenges in this section (O)

Section Recap (O)

Coding Exercise: Operators

After this section you will be able to write grouped queries and use aggregate functions.

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

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

Practice Challenge: Aggregate Functions

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

Practice Challenge: Grouping Rows

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

Practice Challenge: Filtering Group Results

Great to see you continue making progress!

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

Solution to the practice challenges in this section (GO)

Section Recap (GO)

Coding Exercise: Group Operations

This section covers the very important topic of Subqueries. You learn everything about them, and will also be introduced to Analytic Functions.

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

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

Practice Challenge: Subqueries

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!

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

Practice Challenge: Inline Views

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

Practice Challenge: Subquery Factoring

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 Queries

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 Clause

Let's see how much you learnt about subqueries!

Here is a short quiz for you. Enjoy!

Solution to the practice challenges in this section (S)

Section Recap (S)

Coding Exercise: Subqueries

Coding Exercise: Subqueries Part 2

Functions are used very frequently in SQL, and this section will teach you the most commonly used ones.

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.

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches Oracle SQL with up-to-date coverage of the 19c release

Based on decades of Oracle database experience

Designed for beginners and those looking to enhance their SQL skills

Covers advanced concepts like Analytic Functions, Hierarchical Queries, and Pivot/Unpivot features

Provides practical exercises to enhance skill retention and prepare for real-world scenarios

Reviews summary

Informative sql course

Learners say this course is very good for learning the fundamentals of Oracle SQL. The instructor is knowledgeable, and the content is well organized. The assignments and exercises are helpful for practicing the skills learned.

Assignments are helpful.

Content is well organized.

Instructor is very good.

"The course instructor is very good at this topic"

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in The Ultimate Oracle SQL Course: SQL Made Practical with these activities:

Review your notes from a previous SQL course

Show steps

Refreshing your SQL knowledge will help you build a stronger foundation for this course.

Browse courses on SQL

Show steps

Gather your notes from a previous SQL course.
Review the notes.
Complete any practice exercises.

Follow the Oracle SQL Tutorial on W3Schools

Show steps

This tutorial will provide you with a step-by-step guide to learning the basics of Oracle SQL.

Browse courses on SQL

Show steps

Visit the W3Schools website.
Click on the "SQL" tab.
Follow the lessons in the "Oracle SQL Tutorial" section.

Read "Database Systems: The Complete Book by Garcia-Molina, Ullman, Widom"

Show steps

Reviewing this book will help you build a solid foundation in database systems and SQL, which will be essential for success in this course.

View Database Systems: The Complete Book on Amazon

Show steps

Purchase the book.
Read the first three chapters.
Complete the exercises at the end of each chapter.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Join a study group for Oracle SQL

Show steps

Joining a study group will allow you to collaborate with other students and learn from each other.

Browse courses on Oracle SQL

Show steps

Find a study group online or in your local area.
Attend the study group meetings.
Participate in discussions.

Solve Oracle SQL practice problems on LeetCode

Show steps

Solving practice problems will help you improve your problem-solving skills and reinforce your understanding of Oracle SQL.

Browse courses on Oracle SQL

Show steps

Create a LeetCode account.
Search for "Oracle SQL" problems.
Solve the problems.

Attend an Oracle SQL workshop

Show steps

Attending a workshop will allow you to learn from experts and get hands-on experience with Oracle SQL.

Browse courses on Oracle SQL

Show steps

Find an Oracle SQL workshop in your area.
Register for the workshop.
Attend the workshop.

Build a simple database application using Oracle SQL

Show steps

Building a simple database application will help you apply your SQL skills and gain practical experience.

Browse courses on Oracle SQL

Show steps

Choose a simple project idea.
Design the database schema.
Create the database and tables.
Insert data into the tables.
Write SQL queries to retrieve and manipulate data.

Create a blog post or article on a topic related to Oracle SQL

Show steps

Creating a blog post or article will help you solidify your understanding of Oracle SQL and share your knowledge with others.

Browse courses on Oracle SQL

Show steps

Choose a topic related to Oracle SQL.
Research the topic.
Write the blog post or article.
Publish the blog post or article.

Career center

Learners who complete The Ultimate Oracle SQL Course: SQL Made Practical will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator is responsible for the installation, configuration, maintenance, and performance optimization of database management systems, including Oracle. This course provides a solid foundation in Oracle SQL, which is essential for managing Oracle databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Database Administrator.

See salaries and explore the career path for Database Administrator

Business Intelligence Analyst

A Business Intelligence Analyst is responsible for using data to solve business problems and make informed decisions. This course provides a strong foundation in Oracle SQL, which is essential for working with data. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Business Intelligence Analyst.

See salaries and explore the career path for Business Intelligence Analyst

Data Analyst

A Data Analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. This course provides a strong foundation in Oracle SQL, which is essential for working with data. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Data Analyst.

See salaries and explore the career path for Data Analyst

Data Scientist

A Data Scientist is responsible for using statistical and machine learning techniques to extract insights from data. This course provides a strong foundation in Oracle SQL, which is essential for working with data. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Data Scientist.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. This course provides a strong foundation in Oracle SQL, which is essential for working with databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Software Engineer.

See salaries and explore the career path for Software Engineer

Data Governance Specialist

A Data Governance Specialist is responsible for developing and implementing data governance policies and procedures. This course provides a strong foundation in Oracle SQL, which is essential for working with databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Data Governance Specialist.

See salaries and explore the career path for Data Governance Specialist

Web Developer

A Web Developer is responsible for designing, developing, and maintaining websites and web applications. This course provides a strong foundation in Oracle SQL, which is essential for working with databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Web Developer.

See salaries and explore the career path for Web Developer

Systems Analyst

A Systems Analyst is responsible for analyzing and designing computer systems. This course provides a strong foundation in Oracle SQL, which is essential for working with databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Systems Analyst.

See salaries and explore the career path for Systems Analyst

Database Architect

A Database Architect is responsible for designing and managing database systems. This course provides a strong foundation in Oracle SQL, which is essential for working with databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Database Architect.

See salaries and explore the career path for Database Architect

IT Auditor

An IT Auditor is responsible for evaluating an organization's IT systems and processes to ensure that they are operating in accordance with established policies and procedures. This course provides a strong foundation in Oracle SQL, which is essential for working with databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as an IT Auditor.

See salaries and explore the career path for IT Auditor

Information Security Analyst

An Information Security Analyst is responsible for protecting an organization's information systems from unauthorized access, use, disclosure, disruption, modification, or destruction. This course provides a strong foundation in Oracle SQL, which is essential for working with databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as an Information Security Analyst.

See salaries and explore the career path for Information Security Analyst

Technical Writer

A Technical Writer is responsible for creating and maintaining technical documentation. This course may be useful for Technical Writers who need to write documentation for Oracle databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Technical Writer.

See salaries and explore the career path for Technical Writer

Project Manager

A Project Manager is responsible for planning, organizing, and managing projects. This course may be useful for Project Managers who need to work with Oracle databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Project Manager.

See salaries and explore the career path for Project Manager

Quality Assurance Analyst

A Quality Assurance Analyst is responsible for testing and evaluating software applications to ensure that they meet quality standards. This course may be useful for Quality Assurance Analysts who need to work with Oracle databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Quality Assurance Analyst.

See salaries and explore the career path for Quality Assurance Analyst

Business Analyst

A Business Analyst is responsible for analyzing business needs and developing solutions to improve business processes. This course may be useful for Business Analysts who need to work with Oracle databases. The course covers a wide range of topics, including data retrieval, filtering, sorting, grouping, and aggregation, as well as the use of functions and subqueries. With its practical approach and emphasis on hands-on practice, this course will help you develop the skills and knowledge needed to succeed as a Business Analyst.

See salaries and explore the career path for Business Analyst