Oracle SQL – A Complete Introduction

Course Curriculum

Chapter 1: Introduction and Setup

Lecture 1: Introduction

Chapter 2: Software Setup

Lecture 1: Oracle Express 18c Download and Setup

Lecture 2: How To Install Oracle On A Mac

Lecture 3: How to Resolve Oracle Connection Issues

Lecture 4: SQL Developer Download

Lecture 5: Create a New User

Chapter 3: Sample Data

Lecture 1: Our Sample Database

Lecture 2: Setting Up Our Sample Data

Chapter 4: Viewing Data

Lecture 1: How to View Data With the SELECT Statement

Lecture 2: Selecting Individual Columns

Lecture 3: Filtering Data with WHERE

Lecture 4: Comparison Operators

Lecture 5: Filtering on Partial Values with LIKE

Lecture 6: Filtering on Date Values

Lecture 7: Using Two Filters

Lecture 8: More Than Two Filters

Lecture 9: What is NULL?

Lecture 10: Getting Unique Records with DISTINCT

Chapter 5: More Operators

Lecture 1: IN and NOT IN

Lecture 2: BETWEEN and NOT BETWEEN

Lecture 3: ALL Keyword

Lecture 4: ANY Keyword

Chapter 6: Sorting Data

Lecture 1: Sorting Results with the ORDER BY Clause

Lecture 2: Ordering By Multiple Columns

Chapter 7: Set Operators

Lecture 1: Set Operators and UNION

Lecture 2: UNION ALL Operator

Lecture 3: INTERSECT Operator

Lecture 4: MINUS Operator

Lecture 5: Three or More Sets At Once

Chapter 8: Aggregate Functions and Grouping

Lecture 1: What are Functions?

Lecture 2: Counting Data

Lecture 3: Using COUNT in Other Ways

Lecture 4: Counting Data Within Groups with GROUP BY

Lecture 5: GROUP BY with WHERE and ORDER BY

Lecture 6: GROUP BY with Multiple Columns

Lecture 7: GROUP BY with HAVING

Lecture 8: The SUM Function

Lecture 9: Using the MAX and MIN functions

Lecture 10: Using the AVG function

Chapter 9: Joins

Lecture 1: What are Table Aliases?

Lecture 2: What Are Column Aliases?

Lecture 3: What Are Joins?

Lecture 4: Inner Join

Lecture 5: Left Outer Join

Lecture 6: Right Outer Join

Lecture 7: Full Outer Join

Lecture 8: Natural Join

Lecture 9: Cartesian or Cross Join

Lecture 10: Self Join

Lecture 11: Joining Many Tables

Lecture 12: Alternative Join Syntax

Chapter 10: Functions

Lecture 1: String Functions

Lecture 2: Nesting Functions Within Functions

Lecture 3: Number Functions

Lecture 4: Date Functions

Lecture 5: Data Types and Conversion Functions

Lecture 6: The CASE Statement

Chapter 11: Subqueries

Lecture 1: What are Subqueries?

Lecture 2: Single Row Subqueries

Lecture 3: Multi Row Subqueries

Chapter 12: Inserting, Updating, and Deleting Data

Lecture 1: Inserting Data

Lecture 2: Inserting Data From Another Table

Lecture 3: Updating Data

Lecture 4: Deleting Data

Lecture 5: COMMIT and ROLLBACK

Lecture 6: Truncating Data

Chapter 13: Creating, Altering, and Dropping Tables

Lecture 1: Create a Table

Lecture 2: Alter a Table

Lecture 3: Drop a Table

Lecture 4: Conclusion