SQL for Newcomers – The Full Mastery Course

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Tools Used in This Course

Chapter 2: Setting Up Course Tools

Lecture 1: Download PostgreSQL

Lecture 2: Install PostgreSQL

Lecture 3: Download SQLectron

Lecture 4: Install SQLectron

Lecture 5: Connect to PostgreSQL – Credentials

Lecture 6: Connect to PostgreSQL Using SQLectron

Lecture 7: Import Course Data Using SQLectron

Lecture 8: FOR WINDOWS 32-BIT USERS: SQL Alternative – DBeaver

Lecture 9: FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data

Chapter 3: Browsing & Filtering Data

Lecture 1: Check Imported Data

Lecture 2: So.. What is a Database?

Lecture 3: SQL Data Types

Lecture 4: Finally Some Fun! Extracting Data Based on Requirements

Lecture 5: Filtering Data using WHERE Keyword

Lecture 6: Filter Data by Range Using BETWEEN

Lecture 7: Filter Data by Set of Values Using IN

Lecture 8: Filter Data by Date

Lecture 9: More Filtering by Date

Lecture 10: Another Query Filtering by Date

Lecture 11: Filter Data by Strings (Names, Addresses, …)

Lecture 12: More Filtering by Strings

Lecture 13: More Filtering by Strings 2

Lecture 14: More Filtering by Strings 3

Lecture 15: How to Ignore Caps when Filtering by String

Chapter 4: Filter Data with AND, OR, NOT Operators

Lecture 1: AND Operator

Lecture 2: OR Operator

Lecture 3: NOT Operator

Lecture 4: AND, OR & NOT Operators: Which Has The Highest Priority?

Chapter 5: Math Operations

Lecture 1: Basic Math Operations

Lecture 2: Modulo Operator

Lecture 3: It's Payday! Calculate The Net Salary for Employees

Lecture 4: Filter Data with Math Equations

Chapter 6: String Concatenation

Lecture 1: Concatenate Strings with '||' Operator

Lecture 2: Concatenate Strings with Numbers

Chapter 7: Tidy Up Your Results: Sorting, Alias Names, Limit Records

Lecture 1: Give Your Report Fields A Cool Name

Lecture 2: A Report for Payroll

Lecture 3: Order Records by Column

Lecture 4: Order Records by Multiple Columns

Lecture 5: How Alias Names Cannot Be Used with WHERE

Lecture 6: LIMIT Record Count Fetched by Your Query

Chapter 8: NULL, DISTINCT & CASE Statements

Lecture 1: Fetch A Field's Unique Values Using DISTINCT

Lecture 2: Using DISTINCT Keyword with Multiple Columns

Lecture 3: What is a NULL Value Anyway?

Lecture 4: Build More Sophisticated Queries with CASE Statements

Lecture 5: Your Knowledge So Far Under A Great Test

Chapter 9: Functions in SQL: Multiple-Row Functions

Lecture 1: Let Me Introduce You to Functions

Lecture 2: SUM Function

Lecture 3: AVG (Average) Function

Lecture 4: COUNT Function

Lecture 5: MIN & MAX Functions

Lecture 6: How To Count Your Field's Unique Values

Lecture 7: GROUP BY Clause: Use Functions with Dimensions

Lecture 8: GROUP BY More Than One Dimension

Lecture 9: Now For Some Tough Workout

Lecture 10: Filter By Aggregate Functions with HAVING Clause

Chapter 10: Functions in SQL: Single-Row Functions

Lecture 1: Character Functions – UPPER, LOWER & INITCAP

Lecture 2: Character Functions – CONCAT & LENGTH

Lecture 3: Character Functions – LPAD & RPAD

Lecture 4: Character Functions – TRIM

Lecture 5: Character Functions – REPLACE

Lecture 6: Character Functions – SUBSTR

Lecture 7: Number Functions – MOD & ROUND

Lecture 8: Number Functions – TRUNC

Chapter 11: Nested Queries

Lecture 1: Selectception: A Select Query Inside Another Select Query!

Chapter 12: Casting & Data Conversion

Lecture 1: Auto Data Conversion in SQL

Lecture 2: Cast Date to Character

Lecture 3: Cast Number to Character

Lecture 4: Cast Timestamp to Character

Lecture 5: Cast Character to Number

Lecture 6: Cast Character to Date & Timestamp

Chapter 13: Combination Relationships

Lecture 1: UNION

Lecture 2: UNION ALL

Lecture 3: Important Note about Combining Queries

Lecture 4: INTERSECT

Lecture 5: EXCEPT

Chapter 14: Joins in SQL

Lecture 1: Employees & Departments Tables Revised

Lecture 2: Entity Relationship Diagram (ERD)

Lecture 3: Cartesian Join

Lecture 4: Table Aliases with Joins

Lecture 5: Why I Don't Recommend Cartesian Joins

Lecture 6: Inner Join

Lecture 7: In-Depth Look into Join Types in SQL

Lecture 8: Outer Join – Right, Left & Full

Chapter 15: Data Manipulation (DML)