UdemyBestseller on UdemyPostgreSQLPaid courseAll LevelsCertificate

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours (Udemy.com)

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...

4.5

5,539 reviews

Created by: Adnan Waheed

Last updated October 2023

Our take

Based on the ratings of 5,539 students, a sample of their written reviews and the syllabus, as the course stood in October 2023. No course pays to be reviewed.

Adnan Waheed's course is a very long, very slow walk through PostgreSQL for people starting from nothing. It runs 67 hours across 629 lectures, and the syllabus covers tables, data types, constraints, joins, JSON, indexes, views, subqueries, CTEs and window functions. Nearly 44,000 students have enrolled, and it holds a 4.5 rating from about 5,500 reviews. The listing also promises PL/pgSQL, triggers and partitioning, though the listed sections stop at window functions. The last update was October 2023.

Happy reviewers like the pace. One says the steps are explained at a level for a newbie, and a developer coming from Oracle says it goes through all possible content with lots of examples. The complaints are consistent too. Several reviewers say there is little on why you would use a feature or how to combine features in real work, and one calls the classes cheat sheets. Others dislike how often the same create database, create table and import data steps repeat, and the many small sample databases. A few criticize the English and the audio clarity, and two note that nothing covers installing on Linux.

On value, it suits learners who want one long course that leaves little out and who don't mind skipping through the repetition. There are no quizzes or coding exercises, so practice is self-directed. Anyone who already writes SQL will find it slow, and experienced reviewers say the harder parts get only a brief explanation. Beginners who learn by watching and copying commands get the most from it.

Best forComplete beginners who want PostgreSQL taught slowly, step by step, with every command shown on screen.

Skip it ifYou already write SQL and want real-world projects, or you get impatient with repeated setup steps.

Pros

Slow pace and step-by-step explanations that reviewers say suit newbies
Covers a lot of ground: joins, JSON, indexes, views, CTEs and window functions
Plenty of worked examples on sample HR and Northwind style databases
Reviewers who already knew some SQL say they still picked up new things

Cons

Heavy repetition of create database, create table and import data steps
Often described as light on the why and on real-world projects, with no Linux install help
Last updated October 2023, with no quizzes or coding exercises

I haven't finished the course but looked ahead and I can say its easy to learn and practical. I would definitely recommend this to anyone interested in learning postgres whether you're trying to be a DBA or not.

Kevin Franklin, a student

Labeled All Levels, but it really suits true beginners. Reviewers with SQL experience call it slow.

What you will learn

Learn with 60+ hours of hands-on practical exercises
Step-by-step walkthrough to perform simple to complex SQL queries
Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions, and much more
How to create a database from scratch
Creating and using various Data types
Creating User-defined data types
Table and Column constraints
Understanding, Using, and creating custom Sequences
String Functions
Aggregate Functions
Date/Time Functions with query analysis
Grouping data with group sets
Schemas creations and privileges
Table Partitioning techniques
Exploring Array Functions
In-depth JSON data types and queries
Subqueries
Common Table Expressions (CTEs)
Recursive Common Table Expressions
Advanced Window Functions
Server Programming
Functions with SQL Language
Functions with PL/pgSQL Language
Exploring Stored Procedures
Indexes and queries performance optimizations
Multiple Data Views types and Security
Using Regular Expressions for Text Patterns
Power Text Searches with special data types and indexes
Crosstab Reports with crosstab extensions
Making our database for global languages - Internationalization
psql Utility Commands
Understanding PostgreSQL Internals
Triggers
Using Cursors
Data integrity with Transactions and Savepoints
Managing PostgreSQL security
Extended PostgreSQL echosystem
Analyze sample HR, Stocks, Northwind, Global Trades databases
Practice with huge number of queries
Use SQL to perform data analysis
Confident putting SQL and PostgreSQL on your resume

Course content

28 sections · 629 lectures · 67 hours of video 19 articles

1Welcome 1 free preview2 lectures · 1 min
2Introduction to PostgreSQL11 lectures · 34 min
3Creating and Modifying Tables12 lectures · 54 min
4Modifying Data in the tables9 lectures · 34 min
5Querying Data10 lectures · 52 min
6Filtering Data17 lectures · 2.2 hours
7PostgreSQL Data types 1 free preview14 lectures · 2.5 hours
8Modifying Table Structures, Add constraints3 lectures · 24 min
9Data type conversions4 lectures · 29 min
10Conversion Functions4 lectures · 24 min
11User-defined Data Types 1 free preview15 lectures · 1.1 hours
12Explore PostgreSQL Constraints15 lectures · 2.2 hours
13PostgreSQL Sequences10 lectures · 46 min
14String Functions12 lectures · 56 min
15Aggregate functions8 lectures · 1 hour
16Using DATE/TIME functions23 lectures · 2.7 hours
17Grouping Data7 lectures · 57 min
18Joining Multiple Tables21 lectures · 2.6 hours
19Combining queries together 1 free preview5 lectures · 35 min
20PostgreSQL Schemas10 lectures · 1.1 hours
21Exploring array functions18 lectures · 2.1 hours
22JSON with PostgreSQL 1 free preview17 lectures · 1.7 hours
23Indexes and Performance Optimization33 lectures · 4.3 hours
24All about Views 2 free previews27 lectures · 2.3 hours
25Fun with subqueries 1 free preview13 lectures · 1.3 hours
26Common Table Expressions (CTE) 1 free preview7 lectures · 1 hour
27Grouping sets 1 free preview4 lectures · 37 min
28Window Functions 1 free preview41 lectures · 4.6 hours

Who it is for

The instructor says it suits

Complete beginners to database world
Anyone wanting to learn SQL or PostgreSQL
Anyone wanting to learn advanced query expressions
Application engineers seeking to expand their backend skillset
Anyone wants to learn from basic to advanced functionality of PostgreSQL

What you need before you start

No pre-knowledge is required: I'll teach you absolutely everything you need to know!
A computer is required, but any will do. A desktop or a laptop running Mac, Windows, or Linux
All the software used in the course is free, and I'll personally walk you through setting it all up

How it compares

Against the other 47 rated Udemy courses in PostgreSQL on CourseDuck:

Rating4.5 out of 5higher than 74% of them
Reviews5,539#7 of 48 by number of reviews
Length67.3 hourslonger than 100% of them
Last updatedOctober 2023earlier than 55% of them

Course Description

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more...

I've design this course from step-by-step move from basic to advanced topics. Here is a partial list of some of the topics that are covered in 50+ sections and 60+ hours of this course:

Apply powerful SQL commands to store, update and retrieve information
Step-by-step walkthrough to perform simple to complex SQL queries
How to create a database from the scratch, Creating and modifying tables
Using UPSERT for INSERT and UPDATE at the same time
Query data with ORDER BY, Logical operators, and filters
Understand PostgreSQL various data types with examples
Data type conversions with CAST, and conversion functions
Create your own user-defined data types
Explore table and column constraints, create multiple composite constraints, see data integrity operations
Create your own custom sequences
Parsing data with queries using string functions
Aggregate data with aggregate functions
Date/Time data types, Intervals, and handling timezones
Grouping Data with GROUP BY, conditional filter with HAVING
Joining Multiple Tables with various joins techniques
Combining Queries together with UNION, INTERSECT, and EXCEPT
Understand and create PostgreSQL Schemas, ownership, security privileges
Constructing arrays and ranges, query array data with conditional filters
Storing data with JSONB objects and Indexing
Query performance optimization with indexes, understanding indexes nodes and outputs
Create and update regular and materialize views
Simple to advances step-by-step Subqueries
Creating Common Table Expressions (CTEs), and recursive CTEs queries
Making data into group sets
Simple to advanced Windows Functions
Using regular expressions for text patterns
Powerful text searches in PostgreSQL
Create and exploring table partitioning techniques
Server programming with SQL and PL/pqSQL
Creating Stores Procedures
Extending PostgreSQL echosystem with custom indexes, and aggregate functions
Creating, and executing Triggers
Using Cursors
pqsql Utility Commands
Creating Crosstab reports
Making our database for storing global language data - Internationalization
Running queries with PostgreSQL transactions
Crating, and Managing PostgreSQL Security
All about PostgreSQL internals on how data gets stored and much more
Running hundreds of queries on sample databases like HR, Northwind, Stock Markets, Word Trades database

This comprehensive course will teach you everything about PostgreSQL to use in your next big project!

Master the PostgreSQL database, and see how to apply it with real world database and queries. Sign up today and master PostgreSQL!

All Levels

Time: 67.3h

Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

Instructor Details

Adnan Waheed

4.5 Rating
5,539 Reviews

Hello Everyone,

I am an entrepreneur, a deliverer, a dreamer, a believer, a darer and a doer.

I had worked in Bloomberg for 17 years, and build, manage, and lead several projects and team on global basis. After Bloomberg, had build my own companies like KlickAnalytics, ClickAPIs, ZoomMarkets providing global financial markets analytics with tera bytes data on cloud servers.

I've worked extensively with PHP, Python, Angular, Rest APIs, Cloud systems, time series database, financial data analytics, UNIX systems, MongoDB, PostgreSQL, and advanced system architecture design and more.

My utmost passion is the invention, innovation, changing paradigms, game-changing disruptions, people, personal development and the true adventures of life. Master the getting the job done well.

My Motto: Change the Game!

Master Vector Databases (2024)
4.2 (259 Reviews)

- Provider: Udemy
- Time: 7.3h

$10.99

All courses by Adnan Waheed

Reviews

4.5

5,539 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Stefano Seri on 8/8/2026

I would like building a vocabulary straight away. Example: introduced the term schema without explaining what Schema is by analogy with other programming or db environments.

By Cristian Rares Zbarcea on 5/19/2026

I took this course as an Oracle Database Developer looking at fundamental changes in the way PostgreSQL handles things. This course is intended for complete beginners and it goes through all possible content. Lots of examples to understand the basic concepts. For someone with experience this course may be a bit slow and it only briefly explains the complex parts. I might have passed by, but I don't recall hearing about why the "public" schema should exist in a production scenario. When I used PostgreSQL a while back, it was always recommended to just drop it.

By Muhammad Jahanzaib on 4/23/2026

Personally my experience is good. The course was good. It was a fairly in-depth course for the capabilities of PostgreSQL. Best course for learning PostgreSQL from basic.

By Kevin Franklin on 4/20/2026

I haven't finished the course but looked ahead and I can say its easy to learn and practical. I would definitely recommend this to anyone interested in learning postgres whether you're trying to be a DBA or not.

By Vasco Lopes on 2/9/2026

I'm just in the beggining (section 3 lesson 22) and everything is still very easy, i have a background with PostgresSQL but i never learned with anyone just learned by doing. It's good to get some bases and restart from the basic hopefully in the end of the course i will have a much more solid toolset in my pocket.

By Balogun Vincent on 1/9/2026

This is really a great course. It opened my knowledge of PostgreSQL. Adnan is a great teacher as well. I will always recommend.

By Manash Khattry on 1/7/2026

It just explained the above side of the course, actually beginners need learn from the core of the courses. Actually Why we learn sql where we use sql, every comma and semicolon uses etc are needed. But this was not seen where I saw video so far.

By Elisa Gerard on 11/7/2025

Questo corso è quello che cercavo. Gli argomenti trattati partendo da semplici esempi pratici. A volte un po' ripetitivo, ma meglio ripetersi a volte. Avrei gradito più materiale a supporto degli esempi. Comunque un ottimo corso per Postgresql.

By Md Nahid Prawez on 10/27/2025

Thank you Adnan! Absolutely Outstanding PostgreSQL Course! This course exceeded all my expectations! The instructor has done a phenomenal job in breaking down complex PostgreSQL concepts into clear, digestible lessons. Whether you're a beginner or someone looking to deepen your database knowledge, this course is a goldmine. The hands-on exercises, real-world examples, and well-structured modules made learning both effective and enjoyable. I especially appreciated the focus on performance tuning, advanced queries, and practical use cases — it’s clear the instructor knows their stuff! Highly recommended for anyone serious about mastering PostgreSQL. Thank you for such a valuable learning experience!

By Bohdana Buslenko on 10/25/2025

Excellent course!! Above any expectations! - clear structure; - proper course of knowledge advancing; - great explanation and examples; - easy-to-understand speaker's language.

Showing all 10 reviews on CourseDuck

Read all 5,539 reviews on Udemy