Learn SQL Using PostgreSQL: From Zero to Hero

About This Course

Learning SQL is one of the most valuable skills I acquired while building Match, where we managed one of the largest Microsoft SQL Server instances in the 90s, handling millions of records for site functionality. The more proficient we became in SQL, the better we were at optimizing the site for users and answering complex questions about them. In this course, I will guide you through the use of PostgreSQL by covering: basic selection statements, joining multiple tables, grouping records for aggregate data, inserting, updating, and deleting records, creating tables and indexes, utilizing subqueries for sophisticated reports, maintaining data integrity with table constraints, auto-incrementing fields with sequences, common table expressions (CTE) including recursive queries, simplifying complex queries with views, conditional expressions for queries, window functions for combining aggregate and regular data, handling date and time, creating SQL functions, programming with PL/pgSQL, implementing triggers, and working with array and composite data types, as well as transactions and concurrency control.