FB

Introduction to Oracle SQL Course

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. It covers the beginner level topics in my SQL Roadmap.

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.

1. Introduction and Setup

Lesson 1

 

Welcome

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

Lesson 2

 

How to Install Oracle Express

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

Lesson 4

 

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.

Lesson 5b

 

Create a New User in SQL Developer

How to create a new user so you can use the database in SQL Developer.

Lesson 6

 

Our Sample Database

Explains what our sample database is.

Lesson 7

 

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: SQL Aggregate Functions: A Guide

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

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 SQL 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: SQL UPDATE: The Complete Guide

Lesson 63

 

Deleting Data

How to delete data from a table

Related: SQL DELETE 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: SQL TRUNCATE TABLE Statement: The Complete Guide

11. Creating, Altering, and Dropping Tables

Lesson 66

 

Create a Table

How to create a new table

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

Lesson 67

 

Alter a Table

How to alter several parts of an existing table

Related: SQL ALTER TABLE: A Complete Guide

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.

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

22 thoughts on “Introduction to Oracle SQL Course”

  1. Hi Ben,

    I am currently going through your series and was wondering how I get access to the create_user.sql file?

    Thanks,
    Michael

    1. Hi Michael, I’ve send you an email about this. I realised the file should have been available after you op-in for the SQL files, but it wasn’t. Thanks for letting me know!

      1. Hi Manu, the create_user.sql file is available along with all the others.
        The sample HR schema doesn’t come with Oracle Express, so I created my own tables rather than use the same ones that other places were using.

  2. Prashant Chegoor

    Hi Ben,

    Oracle is planning to release 18c version of express edition within the next couple of months according to what I have seen on some forums. If it is released, will you be updating any of your videos on Intro to SQL to reflect the new version? Just curious to know.

    Thanks.

    1. Hi Prashant,
      Yeah, I’ve heard that as well, and I’m looking forward to it!
      I’ll probably be updating the download and installation videos, and including some Oracle 18c specific features as well. So yes they will be updated!
      Thanks,
      Ben

  3. Abdulai Sankoh

    INSERT INTO example2 (table_id, first_name, last_name, registration_date, registration_category, upload_data)
    VALUES (1234, ‘Alecia’, ‘Moore’, DATE ‘2018-07-12’, ‘y’, ‘She is a singer’)

    trying to insert these records into a table, and I am receiving this error message ora 01465 invalid hex number.

  4. Marina Yavishkina

    Hi Ben,

    Just wanted to say huge thanks for making Oracle sql so easy to learn!
    I enjoyed your course very much!
    Thank you!

  5. I am getting ORA-01017: invalid username/password; logon denied error after entering my user name and password.
    Although I am pretty sure that the user name and the password is correct

  6. Dear Ben,

    I am trying to create new user following your book ‘Beginning-Oracle-SQL-for-Oracle-Database-18c’. But in my case, I am not able to see any granted roles which is absolutely empty and its throwing error message when i click on apply button. Can you please email me regarding this issue please!!

    I really appreciate your time!!

  7. I use Oracle Database 18c XE.
    I run this script to create user: create_user.sql
    I got error messages pls help me to correct it:

    Error starting at line : 1 in command –
    CREATE USER intro_user IDENTIFIED BY mypassword
    Error report –
    ORA-65096: érvénytelen közönséges felhasználónév vagy szerepnév
    65096. 00000 – “invalid common user or role name”
    *Cause: An attempt was made to create a common user or role with a name
    that was not valid for common users or roles. In addition to the
    usual rules for user and role names, common user and role names
    must consist only of ASCII characters, and must contain the prefix
    specified in common_user_prefix parameter.
    *Action: Specify a valid common user or role name.

    Error starting at line : 3 in command –
    GRANT CONNECT TO intro_user
    Error report –
    ORA-01917: a(z) ‘INTRO_USER’ felhasználó vagy szerepkör nem létezik
    01917. 00000 – “user or role ‘%s’ does not exist”
    *Cause: There is not a user or role by that name.
    *Action: Re-specify the name.

    Error starting at line : 5 in command –
    GRANT CREATE SESSION, GRANT ANY PRIVILEGE TO intro_user
    Error report –
    ORA-01917: a(z) ‘INTRO_USER’ felhasználó vagy szerepkör nem létezik
    01917. 00000 – “user or role ‘%s’ does not exist”
    *Cause: There is not a user or role by that name.
    *Action: Re-specify the name.

    Error starting at line : 7 in command –
    GRANT UNLIMITED TABLESPACE TO intro_user
    Error report –
    ORA-01917: a(z) ‘INTRO_USER’ felhasználó vagy szerepkör nem létezik
    01917. 00000 – “user or role ‘%s’ does not exist”
    *Cause: There is not a user or role by that name.
    *Action: Re-specify the name.

    Error starting at line : 9 in command –
    GRANT CREATE TABLE TO intro_user
    Error report –
    ORA-01917: a(z) ‘INTRO_USER’ felhasználó vagy szerepkör nem létezik
    01917. 00000 – “user or role ‘%s’ does not exist”
    *Cause: There is not a user or role by that name.
    *Action: Re-specify the name.

    1. Hi, this error may appear when you’ve logged in to the Container database instead of the Pluggable database, which is a new feature in Oracle 12c onwards. Which database did you log in to? I believe it should be XEPDB1 and not XE.

  8. Siddhartha Penchala

    Sir, your youtube videos on SQL have solved almost all of my doubts. Thank you for helping. But, I have one doubt on Group by columns. Please can you help me in solving my doubt. Kindly reply to my email ID and there i will ask the doubt.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Table of Contents