Oracle SQL Tutorial

Welcome to The Ultimate Oracle SQL Tutorial.  Your final destination if you want to learn Oracle SQL for free.

I have a paid video course on Oracle SQL, but even though I offer it with a huge discount to my readers, I acknowledge that not everyone can afford $9.99 at the moment, so , I decided to put together this Oracle SQL tutorial with most of the contents from the video course, so that it can help anyone learn Oracle SQL, regardless of their current financial situation.

New lessons will be posted regularly, covering from the very basics of Oracle and databases in general to some advanced features of the Oracle database like sequences, the use of indexes and more.

Make sure to subscribe to the mailing list to be informed about new lessons and other types of educational content.

Enjoy!

TABLE OF CONTENTS

Course Introduction

Environment Setup

Basic Concepts

Retrieving Information from the Database

Filtering and Sorting Results

Operators

Group Operations

  • Common Aggregate Functions (MIN, MAX, SUM, COUNT, AVG)
  • Grouping Rows (The GROUP BY Clause)
  • Filtering Group Results (HAVING Clause)

Subqueries

  • Understanding Subqueries
  • Common Questions About Subqueries
  • Inline Views
  • Subquery Factoring (The WITH Clause)
  • Top-N queries and Intro to Analytic Functions
  • The Row Limiting Clause

Functions

  • What is a Function?
  • Text Functions
  • Numeric Functions
  • Date Functions
  • Conversion Functions Part 1
  • Conversion Functions Part 2
  • Implicit Conversions are EVIL!
  • The DECODE Function and CASE Expressions
  • Date Arithmetic

Set Operators

  • The UNION and UNION ALL Operators
  • INTERSECT
  • MINUS
  • Mixing Set Operators in a Single Query

Selecting Data From More Than One Table

  • SQL Joins Explained
  • A More Complex Test Schema
  • Inner Joins
  • Other Types of Joins (Equijoins, Non-Equijoins, Self, Cross and Outer Joins)
  • Outer Joins in Detail

Changing the Contents of Database Tables

  • Database Transactions
  • The INSERT Statement
  • The UPDATE Statement
  • The DELETE Statement

Data Definition Language (DDL)

  • Creating, Altering and Dropping Tables
  • Changing the Definition of Tables
  • Adding, Disabling and Dropping Constraints
  • Sequences
  • Indexes
  • Views