Introduction and Setup
  • Introduction
Software Setup
  • Oracle Express 18c Download and Setup
  • How To Install Oracle On A Mac
  • How to Resolve Oracle Connection Issues
  • SQL Developer Download
  • Create a New User
Sample Data
  • Our Sample Database
  • Setting Up Our Sample Data
Viewing Data
  • How to View Data With the SELECT Statement
  • Selecting Individual Columns
  • Filtering Data with WHERE
  • Comparison Operators
  • Filtering on Partial Values with LIKE
  • Filtering on Date Values
  • Using Two Filters
  • More Than Two Filters
  • What is NULL?
  • Getting Unique Records with DISTINCT
  • SELECT Quiz
More Operators
  • IN and NOT IN
  • BETWEEN and NOT BETWEEN
  • ALL Keyword
  • ANY Keyword
  • Operators Quiz
Sorting Data
  • Sorting Results with the ORDER BY Clause
  • Ordering By Multiple Columns
Set Operators
  • Set Operators and UNION
  • UNION ALL Operator
  • INTERSECT Operator
  • MINUS Operator
  • Three or More Sets At Once
Aggregate Functions and Grouping
  • What are Functions?
  • Counting Data
  • Using COUNT in Other Ways
  • Counting Data Within Groups with GROUP BY
  • GROUP BY with WHERE and ORDER BY
  • GROUP BY with Multiple Columns
  • GROUP BY with HAVING
  • The SUM Function
  • Using the MAX and MIN functions
  • Using the AVG function
Joins
  • What are Table Aliases?
  • What Are Column Aliases?
  • What Are Joins?
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Natural Join
  • Cartesian or Cross Join
  • Self Join
  • Joining Many Tables
  • Alternative Join Syntax
Functions
  • String Functions
  • Nesting Functions Within Functions
  • Number Functions
  • Date Functions
  • Data Types and Conversion Functions
  • The CASE Statement
Subqueries
  • What are Subqueries?
  • Single Row Subqueries
  • Multi Row Subqueries
Inserting, Updating, and Deleting Data
  • Inserting Data
  • Inserting Data From Another Table
  • Updating Data
  • Deleting Data
  • COMMIT and ROLLBACK
  • Truncating Data
Creating, Altering, and Dropping Tables
  • Create a Table
  • Alter a Table
  • Drop a Table
  • Conclusion