Do you want to learn SQL?

You’ve come to the right place.

On this page, you’ll find videos, links, and information for this Introduction to Oracle SQL course.

So, keep reading to see what you’ll learn and watch the videos in this course.

Contents – Introduction to Oracle SQL

Here’s what’s included in this course. You can click on each of the headings to be taken to that part of the page, where you can watch the video and find related posts.

 

  1. Introduction and Setup
  2. Viewing Data with SELECT
  3. More Operators
  4. Sorting Data
  5. Set Operators
  6. Aggregate Functions and Grouping
  7. Joins and Aliases
  8. Functions
  9. Subqueries
  10. Inserting, Updating, and Deleting Data
  11. Creating, Altering, and Dropping Tables

If you want all of the scripts that I’ve used in this course, so you can follow along with the videos and run the commands yourself, enter your email address below.

Get All The SQL Scripts Used In This Course

1. Introduction and Setup

Welcome

This video welcomes you to the course and explains to you what you’ll learn.

How to Install Oracle Express

This video explains how to install Oracle Express, which is the database we’ll be using for this course.

How to Download and Set Up SQL Developer

This video explains how to download and set up SQL Developer, which is the IDE we’ll be using in this course.

Set Up a Connection in SQL Developer

How to create a connection to your database in SQL Developer.

Our Sample Database

Explains what our sample database is.

Setting Up Our Sample Data

How to set up the sample data for this course.

2. Viewing Data with SELECT

How to View Data With the SELECT Statement

Getting started with the SELECT statement to view data in a table

Selecting Individual Columns

How to select individual columns in a SELECT statement

Filtering Data with WHERE

How to restrict the rows you display with the WHERE clause

Comparison Operators

What comparison operators are and how to use them in your queries.

Filtering on Partial Values with LIKE

How to use the LIKE operator to filter on partial values

Filtering on Date Values

How to filter on date values in SQL

Using Two Filters

How to use two filters in a SELECT query in SQL

More Than Two Filters

How to use more than two filters in a single query

What is NULL?

What a NULL value is and how it’s treated in SQL

Getting Unique Records with DISTINCT

How to find unique records using the DISTINCT keyword

3. More Operators

IN and NOT IN

Learn about the IN and NOT IN operators

BETWEEN and NOT BETWEEN

This lesson covers the BETWEEN and NOT BETWEEN operators

ALL Keyword

Learn what the ALL keyword does with sets of values

ANY Keyword

Learn what the ANY keyword does with sets of values

4. Sorting Data

Sorting Results with the ORDER BY Clause

Specify the order of your result set using ORDER BY

Related: SQL ORDER BY – The Complete Guide

Ordering By Multiple Columns

Learn how to order by multiple columns using ORDER BY

5. Set Operators

Set Operators and UNION

Explains what set operators are and how to use UNION

UNION ALL Operator

What UNION ALL is and how to use it.

Related: UNION vs UNION ALL: What’s The Difference?

INTERSECT Operator

Learn what the INTERSECT operator is and how to use it

MINUS Operator

Learn what the MINUS operator is and how to use it

Three or More Sets At Once

How to handle three or more sets in the one query

6. Aggregate Functions and Grouping

What are Functions?

An explanation of what functions are in SQL

Related: What Are Oracle SQL Aggregate Functions?

Counting Data

Learn how to count data and records using a function

Using COUNT in Other Ways

Other ways to use the COUNT function in SQL

Counting Data Within Groups with GROUP BY

How to use grouping and count to count occurrences of data.

Related: Oracle SQL GROUP BY – The Complete Guide

GROUP BY with WHERE and ORDER BY

Using GROUP BY to group records, filter them, and order them

GROUP BY with Multiple Columns

Learn how to group with multiple columns

GROUP BY with HAVING

Combine the HAVING clause with GROUP BY to filter records

Related: The Difference Between WHERE and HAVING Clause

The SUM Function

Learn how to add values using the SUM function

Using the MAX and MIN functions

Learn how to use the MAX and MIN functions

Using the AVG function

Find the average of values using the AVG function

7. Joins

What are Table Aliases?

Learn what table aliases are and how to use them

What Are Column Aliases?

Learn what column aliases are and how to use them

What Are Joins?

Find out what joins are, and how they are useful

Inner Join

Learn what an inner join is and how to include it in your query

Left Outer Join

Learn what a left outer join is and how you can use it

Right Outer Join

Learn what a right outer join is, how it differs from a left outer join, and how to use it

Full Outer Join

Learn what a full outer join is, and how to use it in your queries

Natural Join

Find out what a natural join is and when you should/shouldn’t use it

Cartesian or Cross Join

See what a cartesian join or cross join is, and when you might use one

Self Join

Learn what a self join is and when you can use one.

Related: What Is a Self Join?

Joining Many Tables

Find out how to join many tables together

Alternative Join Syntax

Learn about Oracle’s alternative syntax for joining tables

8. Functions

String Functions

Learn what string functions are and see some examples of them

Related: Oracle SQL Functions list

Nesting Functions Within Functions

Learn how to nest one function inside another function, and why this might be needed

Number Functions

Learn what number functions are and see some examples of them

Date Functions

Learn what date functions are and see some examples of them

Data Types and Conversion Functions

Find out about different data types and how to convert between them

Related: A Guide to the Oracle Data Types

Related: How to Convert Data Types in Oracle SQL

The CASE Statement

Learn what the CASE statement is and how to use it

9. Subqueries

What are Subqueries?

Find out what subqueries are and how you might use them

Single Row Subqueries

Explains what a single row subquery is and how it’s used

Multi Row Subqueries

Explains what a multi row subquery is and what it can be used for

10. Inserting, Updating, and Deleting Data

Inserting Data

How to add or insert data into a table

Related: The Complete Guide to the Oracle INSERT INTO Statement

Inserting Data From Another Table

How to insert data into a table from another table

Updating Data

How to update data that’s already in a table

Related: A Guide to the Oracle UPDATE Statement

Deleting Data

How to delete data from a table

Related: Oracle DELETE SQL Statement – The Complete Guide

COMMIT and ROLLBACK

An explanation of what COMMIT and ROLLBACK is

Truncating Data

What the TRUNCATE statement does and how it’s different to DELETE.

Related: A Guide to the Oracle TRUNCATE TABLE Statement

11. Creating, Altering, and Dropping Tables

Create a Table

How to create a new table

Related: Oracle Create Table Syntax and Examples – The Complete Guide

Alter a Table

How to alter several parts of an existing table

Related: A Guide to the Oracle ALTER TABLE SQL Statement

Drop a Table

How to drop or delete a table

Related: A Guide to the Oracle DROP TABLE Statement to Delete Tables in SQL

Conclusion

The conclusion to the course

If you want all of the scripts that I’ve used in this course, so you can follow along with the videos and run the commands yourself, enter your email address below.

Get All The SQL Scripts Used In This Course

If you have any questions or feedback, let me know in the comments below!