Learn PostgreSQL

Get started with PostgreSQL - learn what it is, understand databases and tables, and write your first query.

Learn to filter query results using the WHERE clause with comparison operators, logical operators, and pattern matching.

Learn to add new data with INSERT, change existing data with UPDATE, and remove data with DELETE.

Learn how to summarize and analyze data using aggregate functions like COUNT, SUM, AVG, MIN, and MAX, and how to group results with GROUP BY and filter groups with HAVING.

Master advanced sorting techniques with ORDER BY and learn how to paginate through large result sets using LIMIT, OFFSET, and FETCH FIRST.

Explore PostgreSQL's rich type system including numeric, text, date/time, and boolean types. Learn type casting and understand when to use each type.

Learn how to create, modify, and remove database tables using CREATE TABLE, ALTER TABLE, DROP TABLE, and TRUNCATE commands.

Learn how to combine data from multiple tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, and self joins.

Master the art of nesting queries inside other queries to solve complex data retrieval problems using scalar subqueries, IN, EXISTS, and correlated subqueries.

Write cleaner and more readable SQL using WITH clauses, chain multiple CTEs together, and traverse hierarchical data with recursive CTEs.

Combine, intersect, and subtract result sets using UNION, UNION ALL, INTERSECT, and EXCEPT to answer complex business questions.

Master PostgreSQL string manipulation functions to clean, transform, and format text data effectively.

Learn to perform date arithmetic, extract components, and format temporal data in PostgreSQL.

Understand how PostgreSQL constraints enforce data integrity and prevent invalid data from entering your database.

Learn how to group database operations into atomic units of work using transactions, savepoints, and rollback strategies.

Master PostgreSQL window functions including ranking, aggregation over partitions, and row comparison techniques that unlock powerful analytical queries.

Understand how PostgreSQL indexes work, learn to create and use different index types, and master EXPLAIN ANALYZE to diagnose and optimize query performance.

Learn to store, query, and manipulate JSON data in PostgreSQL using the powerful JSONB type, operators, and functions for flexible schema-less data.

Learn to create reusable virtual tables with views and boost performance with materialized views that cache expensive query results.

Learn to create reusable SQL and PL/pgSQL functions in PostgreSQL, including parameters, return types, control flow, and error handling.

Master PostgreSQL triggers to automate database actions, enforce business rules, and maintain audit trails.

Harness PostgreSQL's built-in full-text search engine to build fast, relevance-ranked search features without external tools.

Go beyond GROUP BY with conditional aggregation, FILTER clauses, GROUPING SETS, ROLLUP, and CUBE for powerful summary reports.