SQL Bootcamp 2024: Master SQL & PostgreSQL – Hands-On Course

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Intro

Chapter 2: Beginner: PostgreSQL Downloading & Installing + Preparing Airlines Database

Lecture 1: SQL PostgreSQL Down and install

Lecture 2: PostgreSQL Database creation

Lecture 3: SQL Restore

Chapter 3: Beginner: Database Airlines Overview

Lecture 1: SQL Database Overview Part 1

Lecture 2: SQL Database Overview Part 2

Lecture 3: SQL Data Types

Chapter 4: Beginner: SQL Basics Part 1

Lecture 1: Select Statement

Lecture 2: Select Challenge Solution

Lecture 3: Select Statement For all Airlines Database Tables

Lecture 4: Distinct

Chapter 5: Beginner: SQL Basics Part 2

Lecture 1: Where Clause

Lecture 2: Operators used with Where Clause

Lecture 3: Where Clause + AND & Where Clause + OR

Lecture 4: Where Clause + LIKE

Lecture 5: (Where Clause + BETWEEN & IN) & AS

Chapter 6: Beginner: SQL Basics Part 3

Lecture 1: LIMIT & ORDER BY

Lecture 2: FETCH vs LIMIT

Lecture 3: NOT IN

Lecture 4: ISNULL & IS NOT NULL

Lecture 5: CAST

Chapter 7: Intermediate: SQL Aggregations

Lecture 1: COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE

Lecture 2: SUM( ) Function

Lecture 3: MIN( ) , MAX( ) & AVG( ) Functions

Lecture 4: GROUP BY & HAVING

Chapter 8: Intermediate: SQL Conditional

Lecture 1: CASE Clause in SQL

Lecture 2: NULLIF() Function in SQL

Lecture 3: COALESCE() Function in SQL

Chapter 9: Intermediate: SQL Time Data management

Lecture 1: Overview of Time Functions in PostgreSQL

Lecture 2: TIMESTAMP EXTRACT()

Lecture 3: DATE_TRUNC() & DATE_PART()

Lecture 4: Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( )

Chapter 10: Intermediate: SQL Joins

Lecture 1: INNER JOIN

Lecture 2: Joins Types Overview

Lecture 3: LEFT OUTER JOIN

Lecture 4: Deep understanding of LEFT JOIN

Lecture 5: RIGHT OUTER JOIN

Lecture 6: FULL OUTER JOIN

Lecture 7: CROSS JOIN

Lecture 8: UNION, UNION ALL, INTERSECT & EXCEPT

Lecture 9: SELF JOIN

Lecture 10: USING

Lecture 11: NATURAL JOIN

Chapter 11: Intermediate: Sub-queries & Common Table Expression in SQL

Lecture 1: Sub-queries

Lecture 2: SQL Sub-query + EXISTS, ANY OR ALL

Lecture 3: Common Table Expression

Chapter 12: Advanced: PostgreSQL Math & Window functions.

Lecture 1: Math Functions

Lecture 2: Window Functions OVER()

Lecture 3: Window Functions RANK() + OVER() & NTILE() + OVER()

Lecture 4: Window Functions OVER() + LEAD()

Lecture 5: Window Functions OVER() + LAG()

Chapter 13: Advanced: PostgreSQL String Functions.

Lecture 1: PostgreSQL POSITION Function

Lecture 2: STRPOS() & REPLACE() in PostgreSQL

Lecture 3: PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT_PART() Functions

Lecture 4: PostgreSQL CONCAT Function

Lecture 5: PostgreSQL LOWER(), UPPER() & INITCAP() Functions

Chapter 14: Advanced: Other SQL Functions

Lecture 1: GROUPING SETS(), ROLLUP(), CUBE()

Lecture 2: SELECT Statement + INTO & SELECT Statement + INTO + IN

Lecture 3: VIEW()

Chapter 15: Lots of SQL Challenges

Lecture 1: Challenge(1)

Lecture 2: Solution

Lecture 3: Challenge(2)

Lecture 4: Solution

Lecture 5: Challenge(3)

Lecture 6: Solution

Lecture 7: Challenge(4)

Lecture 8: Solution

Lecture 9: Challenge(5)

Lecture 10: Solution

Lecture 11: Challenge(6)

Lecture 12: Solution

Lecture 13: Challenge(7)

Lecture 14: Solution

Lecture 15: Challenge(8)

Lecture 16: Solution

Lecture 17: Challenge(9)

Lecture 18: Solution

Lecture 19: Challenge(10)

Lecture 20: Solution

Lecture 21: Challenge(11)

Lecture 22: Solution

Lecture 23: Challenge(12)

Lecture 24: Solution

Lecture 25: Challenge(13)

Lecture 26: Solution