PostgreSQL Essentials
Query Optimization and EXPLAIN ANALYZE
PostgreSQL Essentials
0% Completed
Introduction to PostgreSQL
This topic introduces students to PostgreSQL, explaining what sets it apart from other database systems, and gets them set up with the tools needed to start working with it.
This topic covers the foundational SQL commands used to retrieve, add, modify, and remove data in PostgreSQL — the core operations every database user needs to know.
This topic teaches students how to properly structure a PostgreSQL database, covering how tables are defined and how relationships between them are established.
This topic teaches students how to combine data from multiple tables and summarize data using aggregate functions, essential skills for querying real-world databases
This topic highlights features that make PostgreSQL stand out from other relational databases, giving students hands-on experience with its more advanced and flexible capabilities.
This topic introduces the basics of database performance in PostgreSQL, helping students understand how indexes work and how to analyze and optimize slow queries.
This final topic lets students apply everything learned throughout the course by designing a database and writing queries for a complete, practical application.
This lesson introduces the EXPLAIN ANALYZE command, teaching students how to inspect a query’s execution plan to identify performance bottlenecks and optimize accordingly.