FB

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

Lesson 1

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.

Create a New User in SQL Developer

How to create a new user so you can use the 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

Lesson 8

How to View Data With the SELECT Statement

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

Lesson 9

Selecting Individual Columns

How to select individual columns in a SELECT statement

Lesson 10

Filtering Data with WHERE

How to restrict the rows you display with the WHERE clause

Lesson 11

Comparison Operators

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

Lesson 12

Filtering on Partial Values with LIKE

How to use the LIKE operator to filter on partial values

Lesson 13

Filtering on Date Values

How to filter on date values in SQL

Lesson 14

Using Two Filters

How to use two filters in a SELECT query in SQL

Lesson 15

More Than Two Filters

How to use more than two filters in a single query

Lesson 16

What is NULL?

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

Lesson 17

Getting Unique Records with DISTINCT

How to find unique records using the DISTINCT keyword

3. More Operators

Lesson 18

IN and NOT IN

Learn about the IN and NOT IN operators

Lesson 19

BETWEEN and NOT BETWEEN

This lesson covers the BETWEEN and NOT BETWEEN operators

Lesson 20

ALL Keyword

Learn what the ALL keyword does with sets of values

Lesson 21

ANY Keyword

Learn what the ANY keyword does with sets of values

4. Sorting Data

Lesson 22

Sorting Results with the ORDER BY Clause

Specify the order of your result set using ORDER BY

Related: SQL ORDER BY – The Complete Guide

Lesson 23

Ordering By Multiple Columns

Learn how to order by multiple columns using ORDER BY

5. Set Operators

Lesson 24

Set Operators and UNION

Explains what set operators are and how to use UNION

Lesson 25

UNION ALL Operator

What UNION ALL is and how to use it.

Related: SQL Set Operators: The Complete Guide to UNION, INTERSECT & MINUS

Lesson 26

INTERSECT Operator

Learn what the INTERSECT operator is and how to use it

Lesson 27

MINUS Operator

Learn what the MINUS operator is and how to use it

Lesson 28

Three or More Sets At Once

How to handle three or more sets in the one query

6. Aggregate Functions and Grouping

Lesson 29

What are Functions?

An explanation of what functions are in SQL

Related: What Are Oracle SQL Aggregate Functions?

Lesson 30

Counting Data

Learn how to count data and records using a function

Lesson 31

Using COUNT in Other Ways

Other ways to use the COUNT function in SQL

Lesson 32

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

Lesson 33

GROUP BY with WHERE and ORDER BY

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

Lesson 34

GROUP BY with Multiple Columns

Learn how to group with multiple columns

Lesson 35

GROUP BY with HAVING

Combine the HAVING clause with GROUP BY to filter records

Related: The Difference Between WHERE and HAVING Clause

Lesson 36

The SUM Function

Learn how to add values using the SUM function

Lesson 37

Using the MAX and MIN functions

Learn how to use the MAX and MIN functions

Lesson 38

Using the AVG function

Find the average of values using the AVG function

7. Joins

Lesson 39

What are Table Aliases?

Learn what table aliases are and how to use them

Lesson 40

What Are Column Aliases?

Learn what column aliases are and how to use them

Lesson 41

What Are Joins?

Find out what joins are, and how they are useful.

Related: SQL Joins: The Complete Guide

Lesson 42

Inner Join

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

Lesson 43

Left Outer Join

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

Lesson 44

Right Outer Join

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

Lesson 45

Full Outer Join

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

Lesson 46

Natural Join

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

Lesson 47

Cartesian or Cross Join

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

Lesson 48

Self Join

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

Related: What Is a Self Join?

Lesson 49

Joining Many Tables

Find out how to join many tables together

Lesson 50

Alternative Join Syntax

Learn about Oracle’s alternative syntax for joining tables

8. Functions

Lesson 51

String Functions

Learn what string functions are and see some examples of them

Related: Oracle SQL Functions list

Lesson 52

Nesting Functions Within Functions

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

Lesson 53

Number Functions

Learn what number functions are and see some examples of them

Lesson 54

Date Functions

Learn what date functions are and see some examples of them

Lesson 55

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

Lesson 56

The CASE Statement

Learn what the CASE statement is and how to use it

9. Subqueries

Lesson 57

What are Subqueries?

Find out what subqueries are and how you might use them

Lesson 58

Single Row Subqueries

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

Lesson 59

Multi Row Subqueries

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

10. Inserting, Updating, and Deleting Data

Lesson 60

Inserting Data

How to add or insert data into a table

Related: The Complete Guide to the Oracle INSERT INTO Statement

Lesson 61

Inserting Data From Another Table

How to insert data into a table from another table

Lesson 62

Updating Data

How to update data that’s already in a table

Related: A Guide to the Oracle UPDATE Statement

Lesson 63

Deleting Data

How to delete data from a table

Related: Oracle DELETE SQL Statement – The Complete Guide

Lesson 64

COMMIT and ROLLBACK

An explanation of what COMMIT and ROLLBACK is

Lesson 65

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

Lesson 66

Create a Table

How to create a new table

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

Lesson 67

Alter a Table

How to alter several parts of an existing table

Related: A Guide to the Oracle ALTER TABLE SQL Statement

Lesson 68

Drop a Table

How to drop or delete a table

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

Lesson 69

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!