SQL for Beginners: The Easiest Way to Learn SQL Step by Step

Course Curriculum

Chapter 1: Database Concepts

Lecture 1: What is the Database?

Lecture 2: Why Oracle Database?

Lecture 3: What is a Table?

Lecture 4: Special Gifts for Our Students

Lecture 5: What is a Relational Database?

Lecture 6: Entity Relationship Logic in Databases

Lecture 7: What is Pluggable Database?

Lecture 8: The Sample (HR) Schema Used in This Course

Lecture 9: What is SQL?

Chapter 2: Preparation for SQL Development

Lecture 1: About the Database Installation

Lecture 2: The Ways to Get a Database

Lecture 3: Option 1: Installing VMware and VirtualBox on Windows

Lecture 4: Option 1: How to Install VirtualBox on Mac OS X?

Lecture 5: Option 1: Downloading Virtual Machine Image (19c)

Lecture 6: Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)

Lecture 7: Option 1: Configuring the VMware Virtualization Software

Lecture 8: Option 1: Configuring the Oracle VirtualBox Virtualization Software

Lecture 9: Option 1: Configuring SQL Developer inside of the Virtual Machine

Lecture 10: Important Note

Lecture 11: Option 2: Downloading And Installing the Oracle Database

Lecture 12: Option 2: Unlocking the HR Schema

Lecture 13: Option 2: Configuring and Using Oracle SQL Developer

Lecture 14: Option 2: Installing Sample Schemas in Oracle Database

Lecture 15: Option 3: Using Oracle Live SQL

Lecture 16: Option 3: About Oracle Live SQL Restrictions

Chapter 3: Entering the Database!

Lecture 1: Basic SQL Statements

Lecture 2: SQL Coding Tips!

Lecture 3: Let's describe the tables!

Lecture 4: How to Get Data? (Select Statement)

Lecture 5: Aliasing The Columns

Lecture 6: Getting Different Rows – DISTINCT Operator!

Lecture 7: Concatenating The Returning Rows

Lecture 8: Arithmetic Expressions

Lecture 9: What is the NULL Value? Is it dangerous?

Chapter 4: Conditional Retrieval

Lecture 1: Getting Data Just We Want – WHERE Clause!

Lecture 2: Comparison Operators

Lecture 3: Between…AND Operators

Lecture 4: IN Operator

Lecture 5: Get Me Something LIKE this

Lecture 6: What If Looking For Something NULL

Lecture 7: Logical Operators – AND, OR, NOT

Chapter 5: Converting Data & Conversion Functions

Lecture 1: What is a Function?

Lecture 2: Why to Convert Data?

Lecture 3: Conversion Functions

Lecture 4: Converting to a Character – TO_CHAR Function

Lecture 5: Converting to a Date – TO_DATE Function

Lecture 6: NULL Value Conversion – NVL Function

Chapter 6: Ordering The Results

Lecture 1: ORDER BY Clause

Lecture 2: ASC and DESC Operators

Chapter 7: Single Row Functions

Lecture 1: About Single Row Functions

Lecture 2: Character Functions

Lecture 3: Number Functions

Lecture 4: Nesting Functions

Lecture 5: Date Functions

Lecture 6: DECODE Function

Chapter 8: Grouping the data (Group Functions)

Lecture 1: What are group functions?

Lecture 2: MAX Function

Lecture 3: MIN Function

Lecture 4: Count() Function

Lecture 5: AVG Function

Lecture 6: SUM Function

Chapter 9: Grouping the Data

Lecture 1: GROUP BY Clause

Lecture 2: HAVING Clause

Chapter 10: Selecting From Multiple Tables (Joins)

Lecture 1: What is join?

Lecture 2: Types of Joins!

Lecture 3: Let's Join Tables!

Lecture 4: Join With USING Clause

Lecture 5: Join with ON Clause

Lecture 6: Join A Table with Itself!

Lecture 7: Joining Multiple Tables

Lecture 8: What are the Outer Joins?

Lecture 9: What are the Left Joins? (Left Outer Joins)

Lecture 10: What are the Right Joins? (Right Outer Joins)

Lecture 11: Full Outer Joins

Lecture 12: Cross Joins – Cartesian Product

Chapter 11: Query inside a Query – Subqueries

Lecture 1: What is a subquery?

Lecture 2: Single Row Subqueries

Lecture 3: Multiple Row Subqueries

Lecture 4: Multiple Columns Subqueries