Crookshanks' Academy
Data Analysis

PostgreSQL

5 Seasons · 26 Episodes · 0/26 watched

A binge-worthy 5-season journey through PostgreSQL. Learn to turn raw numbers into decisions — one episode at a time.

Log in to start Certificate

About this course

A binge-worthy 5-season journey through PostgreSQL. Learn to turn raw numbers into decisions — one episode at a time.

PostgreSQL is a free, self-paced data analysis course from Crookshanks' Academy. It contains 26 video lessons organised into 5 seasons, each with study notes and a practice task. Track your progress as you go and earn a certificate of completion when you finish every episode.

What you'll learn

Season 1

  • How to Backup & Restore PostgreSQL Database in pgAdmin 4
  • CTE in PostgreSQL Explained | WITH Clause, Syntax, Examples & Multi-Step CTE Query
  • PostgreSQL Subqueries Tutorial for Beginners | Scalar & List Subquery with Practical Examples
  • PostgreSQL Date & Time Functions Explained | Timestamp, Interval, EXTRACT & TO_CHAR with Queries
  • Can You Solve These Advanced PostgreSQL Queries? 🔥 Joins, GROUP BY, HAVING
  • Advanced PostgreSQL Practice Session | Real SQL Interview Questions & Solutions

Season 2

  • PostgreSQL GROUP BY & HAVING Clause Explained with Practical Questions
  • PostgreSQL Aggregate Functions Tutorial | COUNT, SUM, AVG, MIN, MAX with Real Examples
  • PostgreSQL FULL OUTER JOIN vs CROSS JOIN Explained with Real Database Examples
  • PostgreSQL LEFT JOIN vs RIGHT JOIN Explained | Real Examples, Interview Questions & Tricks
  • Why pgAdmin 4 is So Slow on Mac M1/M2/M3 Pro (And How to Fix It)
  • PostgreSQL INNER JOIN Explained with Venn Diagram + 3 Real Queries (Beginner to Advanced)

Season 3

  • PostgreSQL Foreign Key Interview Questions Solved Practically
  • PostgreSQL Foreign Key Explained | Junction Tables, Many To many Relationships & ON DELETE CASCADE
  • Database Architecture: Why UUIDv7 Wins Over SERIAL
  • PostgreSQL Constraints Explained | NOT NULL, UNIQUE, CHECK
  • Learn PostgreSQL Sorting & Pagination in One Video | ORDER BY + LIMIT + OFFSET
  • Advanced Filtering in PostgreSQL 🚀 IN, BETWEEN, LIKE & ILIKE Operators Explained with Queries

Season 4

  • PostgreSQL WHERE Clause Full Tutorial | Comparison, Logical Operators & Common Mistakes
  • DELETE Query in PostgreSQL Explained | DELETE vs TRUNCATE + Soft Delete + Best Practices
  • PostgreSQL UPDATE Query Tutorial (Day 6) | Don't Make This CRITICAL Mistake!
  • PostgreSQL SELECT Operation: Practical Examples & Tips | #5
  • PostgreSQL INSERT Tutorial in PGAdmin 4 | Single, Multiple, CSV & Excel Import (Complete Guide)
  • PostgreSQL Tutorial: Build Your First Database & Tables from Scratch (CLI + pgAdmin4)

Season 5

  • PostgreSQL Installation 2026: Install PostgreSQL + pgAdmin 4 + CLI Setup
  • PostgreSQL Tutorial for Beginners 2026 — Day 1 | Database, DBMS, RDBMS & SQL Explained

Episodes

  1. 1
    How to Backup & Restore PostgreSQL Database in pgAdmin 4
  2. 2
    CTE in PostgreSQL Explained | WITH Clause, Syntax, Examples & Multi-Step CTE Query
  3. 3
    PostgreSQL Subqueries Tutorial for Beginners | Scalar & List Subquery with Practical Examples
  4. 4
    PostgreSQL Date & Time Functions Explained | Timestamp, Interval, EXTRACT & TO_CHAR with Queries
  5. 5
    Can You Solve These Advanced PostgreSQL Queries? 🔥 Joins, GROUP BY, HAVING
  6. 6
    Advanced PostgreSQL Practice Session | Real SQL Interview Questions & Solutions