Master SQL – Simple to advanced 200+ queries

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Install PostgreSQL 13

Lecture 3: Install pgAdmin 4 v5.5

Lecture 4: Run PostgreSQL on the cloud

Chapter 2: *** Employees Management System ***

Lecture 1: Understand the database model

Lecture 2: Create tables and populate data

Lecture 3: Get filtered data via WHERE clause

Lecture 4: Referencing an alias and concatenate columns

Lecture 5: Using conditional logic with CASE expression

Lecture 6: Using ORDER BY, LIMIT and RANDOM

Lecture 7: Find NULL values and transform into real values

Lecture 8: Searching for patterns

Lecture 9: Sorting on data dependent key

Lecture 10: Staking tables together

Chapter 3: Hierarchical Queries

Lecture 1: Expressing a Parent-Child Relationship

Lecture 2: Expressing a Child-Parent-Grandparent Relationship

Lecture 3: Creating a hierarchical view of a table

Lecture 4: Finding all child rows for a given parent row

Lecture 5: Which rows are leaf, branch, or root nodes

Chapter 4: Working with numbers

Lecture 1: Computing an average, min/max values

Lecture 2: Sum, and count

Lecture 3: Generating a running total

Lecture 4: Calculating 3-point moving averages

Lecture 5: Calculate a mode

Lecture 6: Calculate a median, averages without highs and lows

Chapter 5: Date Arithmetic

Lecture 1: Add, subtract dates, and numbers of days

Lecture 2: Compute running date difference

Lecture 3: Comparing records using dates

Chapter 6: Advances Searching

Lecture 1: Find differences between rows within same group or partition

Lecture 2: Pagination

Lecture 3: Skipping n rows

Lecture 4: Selecting the Top n Records

Chapter 7: Window Functions

Lecture 1: Turn aggregate function to window function

Lecture 2: PARTITION BY clause

Lecture 3: Handling NULLs

Lecture 4: The ORDER BY clause matters

Chapter 8: Metadata Queries

Lecture 1: Listing tables, columns and indexes

Lecture 2: Listing constraints on a table

Lecture 3: Using SQL to Generate SQL

Chapter 9: International Debt Analysis

Lecture 1: Preparing the data

Lecture 2: Analyzing International debt – Part 1

Lecture 3: Analyzing International debt – Part 2

Chapter 10: Stocks Markets Analysis

Lecture 1: Introduction to Stock Markets Data

Lecture 2: CODE: Table Creation – Sectors, Symbols, Prices

Lecture 3: Import sample datasets

Lecture 4: CODE: Import sample datasets

Lecture 5: Important – SQL Query is in CODE: Articles

Lecture 6: List data, sectors in ascending and descending orders

Lecture 7: CODE: List data, sectors in ascending and descending orders

Lecture 8: Using COUNT, WHERE, IN and NOT IN with sectors

Lecture 9: CODE: Using COUNT, WHERE, IN and NOT IN with sectors

Lecture 10: CODE: Find total stocks per each sectors

Chapter 11: Club House Analysis

Lecture 1: Introduction to database model

Lecture 2: Load sample datasets

Lecture 3: Using conditions, stain search and classify results

Lecture 4: Get unique data, aggregate with max/min functions

Lecture 5: Joining tables and apply filter conditions

Lecture 6: inner join on multiple columns, multiple inner joins

Lecture 7: Using case statement, inner joins, and filters

Lecture 8: aggregate on multiple columns, date extractions

Lecture 9: Using count, having with filters

Lecture 10: Using sum, order by aggregate functions

Lecture 11: Using rollup aggregation

Chapter 12: Congratulations and Thank You!

Lecture 1: Your feedback is very valuable!

Lecture 2: Updates to the course

Lecture 3: Bonus Lectures