Learning SQL For Oracle

Course Curriculum

Chapter 1: Introduction To Oracle SQL

Lecture 1: Important – Download These First – Working Files

Lecture 2: 0102 What Is SQL?

Lecture 3: 0103 Relational Databases Explained – Part 1

Lecture 4: 0104 Relational Databases Explained – Part 2

Lecture 5: 0105 How To Query Data From A Database

Lecture 6: 0106 The Difference Between SQL And PL/SQL

Lecture 7: 0107 Setting Up An Oracle Apex Account

Lecture 8: 0108 Running SQL Using Oracle Apex

Lecture 9: 0109 Assignment 1

Lecture 10: 0110 Assignment 1 – Solution

Lecture 11: 0111 How To Access Your Working Files

Chapter 2: Basic SQL Select Statement

Lecture 1: 0201 Retrieving All Data From A Table

Lecture 2: 0202 Retrieving Some Data From A Table

Lecture 3: 0203 Restricting The Retrieval Of Rows From A Table

Lecture 4: 0204 Using Mathematical And Text Expressions

Lecture 5: 0205 Sorting The Results Using Column Names

Lecture 6: 0206 Assignment 2

Lecture 7: 0207 Assignment 2 – Solution

Chapter 3: Restricting Data – The Basics

Lecture 1: 0301 What Is A Primary Key?

Lecture 2: 0302 Comparison Operators

Lecture 3: 0303 Logical Operators

Lecture 4: 0304 Dealing With Null Values

Lecture 5: 0305 Sorting The Results Using Column Position

Lecture 6: 0306 Assignment 3

Lecture 7: 0307 Assignment 3 – Solution

Chapter 4: Joining Tables – The Basics

Lecture 1: 0401 What Is A Foreign Key?

Lecture 2: 0402 Inner Joins With The Using Clause

Lecture 3: 0403 Joins With The On Clause

Lecture 4: 0404 Joins And The Order Of Processing

Lecture 5: 0405 Assignment 4

Lecture 6: 0406 Assignment 4 – Solution

Chapter 5: Summarizing Data

Lecture 1: 0501 Aggregate Functions

Lecture 2: 0502 The Count Functions

Lecture 3: 0503 The Min And Max Functions

Lecture 4: 0504 The Avg And Sum Functions

Lecture 5: 0505 Concatenating Data

Lecture 6: 0506 Aggregates – Order Of Processing

Lecture 7: 0507 Assignment 5

Lecture 8: 0508 Assignment 5 – Solution

Chapter 6: Joining Multiple Tables

Lecture 1: 0601 Many-To-Many Relationships – Part 1

Lecture 2: 0602 Many-To-Many Relationships – Part 2

Lecture 3: 0603 Join Multiple Tables With The Using Clause

Lecture 4: 0604 Join Multiple Tables With The On Clause

Lecture 5: 0605 Eliminating Duplicate Rows From The Results

Lecture 6: 0606 Sorting The Results Using Column Aliases

Lecture 7: 0607 Assignment 6

Lecture 8: 0608 Assignment 6 – Solution

Chapter 7: Data Subsets

Lecture 1: 0701 Using The Group By Clause

Lecture 2: 0702 Using The Having Clause

Lecture 3: 0703 Having With Compound Conditions

Lecture 4: 0704 Assignment 7

Lecture 5: 0705 Assignment 7 – Solution

Chapter 8: Restricting Data – Advanced Concepts

Lecture 1: 0801 Using The In Operator

Lecture 2: 0802 Using The Between Operator

Lecture 3: 0803 Using The Like Operator For Pattern Matching

Lecture 4: 0804 Outer Joins

Lecture 5: 0805 Assignment 8

Lecture 6: 0806 Assignment 8 – Solution

Chapter 9: Using Subqueries – The Basics

Lecture 1: 0901 How Do Subqueries Work?

Lecture 2: 0902 Subqueries With The In Operator

Lecture 3: 0903 Subqueries Using A Comparison Operator

Lecture 4: 0904 Subqueries Vs. Joins

Lecture 5: 0905 Using A Subquery Vs. A Self-Join

Lecture 6: 0906 Assignment 9

Lecture 7: 0907 Assignment 9 – Solution

Chapter 10: Data Modeling – The Basics

Lecture 1: 1001 How Data Is Organized In A Relational Database

Lecture 2: 1002 The Entity-Relationship Approach

Lecture 3: 1003 Normalization Guidelines – Part 1

Lecture 4: 1004 Normalization Guidelines – Part 2

Lecture 5: 1005 Assignment 10

Lecture 6: 1006 Assignment 10 – Solution

Chapter 11: Creating Tables And Manipulating Data

Lecture 1: 1101 Creating Tables – Part 1

Lecture 2: 1102 Creating Tables – Part 2

Lecture 3: 1103 Specifying Keys

Lecture 4: 1104 The Check Constraint

Lecture 5: 1105 Creating Indexes

Lecture 6: 1106 Modifying And Removing Tables

Lecture 7: 1107 More Constraints

Lecture 8: 1108 Adding Data To A Table

Lecture 9: 1109 Changing Data In A Table – Part 1

Lecture 10: 1110 Changing Data In A Table – Part 2

Lecture 11: 1111 Removing Data From A Table

Lecture 12: 1112 Assignment 11

Lecture 13: 1113 Assignment 11 – Solution

Chapter 12: Single-Row Functions

Lecture 1: 1201 String Functions – Part 1

Lecture 2: 1202 String Functions – Part 2

Lecture 3: 1203 Number Functions

Lecture 4: 1204 Date Functions