PostgreSQL Academy
HomePricingAbout

Login

Sign up
Comprehensive SQL Course

Course Curriculum

Explore everything covered in PostgreSQL Academy — from basic queries to advanced SQL concepts with hands-on examples.
Enroll Now — $29.99Preview Free Lessons
PostgreSQL
Course Overview
12
Sections
98
Lectures
3h 22m
Total Length
300+
Quiz Questions

What You'll Learn

Practical skills you can apply immediately

  • Querying
  • String Operators
  • Aggregate Functions
  • Joins
  • Date Functions
  • Working with JSON & JSONB
  • Working with Arrays
  • Window Functions
  • Schema Design & Data Types
  • Views, Indexes & Transactions
  • CRUD Operations

    • Course Content

    12 sections · 98 lectures · 3h 22m total

    • Prerequisites
    • Working Data

    • Select
    • Select Multiple
    • Select Constants
    • Order By
    • Limit and Offset
    • Where
    • IS NULL
    • And/Or
    • Not
    • In
    • Between
    • Any/Some
    • Alias
    • Exists
    • Distinct
    • Like
    • Case When

    • Upper
    • Initcap
    • Concat
    • Left
    • Right
    • Substring
    • Length
    • Replace
    • Cast
    • Trim
    • Split Part

    • Introduction
    • Min
    • Max
    • Sum
    • Avg
    • Count
    • Filter
    • Group By
    • Group By Multiple
    • Having
    • Over

    • Union
    • Union All
    • Left Join
    • Inner Join

    • Current
    • At Timezone
    • Extract
    • Date Part
    • Date Trunc
    • Date Difference
    • Age
    • To Char
    • To Date
    • Interval
    • Make Interval

    • Introduction
    • Select Property
    • Select Sub Property
    • Aggregation
    • JSON Build

    • Introduction
    • Unnest
    • Slicing
    • Append
    • Length
    • Search
    • Aggregates
    • String to Array

    • Introduction
    • Partition By
    • Row Number
    • Ntile

    • Introduction
    • Database
    • Tables
    • Columns
    • Default
    • Not Null
    • Unique
    • Check
    • Primary Key
    • Compound Key
    • Foreign Key
    • On Delete
    • Index
    • If Not Exists

    • CRUD
    • Insert Multiple
    • On Conflict
    • Transactions
    • Greatest
    • Subquery
    • Coalesce
    • Except
    • CTE
    • Generate Series

    • Where to Go

    Test Your Knowledge

    Put what you learn into practice with 6 quizzes covering beginner, intermediate, and advanced topics — over 300 questions in total.

    6

    Quizzes

    300+

    Questions

    3

    Difficulty Levels

    Ready to Start Learning?

    Get lifetime access to all course content for a one-time payment.
    Enroll Now — $29.99