PostgreSQL

PluralSight – Join and Combine Data with SQL in PostgreSQL 2026

PluralSight – Join and Combine Data with SQL in PostgreSQL 2026
English | Tutorial | Size: 145.81 MB


Combine data in PostgreSQL using joins, set operations, and subqueries. Learn INNER/OUTER/NATURAL joins, UNION/INTERSECT/EXCEPT with ALL, CTEs, and EXPLAIN to validate results for accurate analytics.

PluralSight – Group and Aggregate Data with SQL in PostgreSQL 2026

PluralSight – Group and Aggregate Data with SQL in PostgreSQL 2026
English | Tutorial | Size: 194.02 MB


Analyze data in PostgreSQL using aggregation, GROUP BY, conditional logic, and window functions. Learn how to summarize data correctly, avoid common grouping errors, and preserve row-level detail for real-world analytics.

PluralSight – PostgreSQL Core Administration and Operational Maintenance 2026

PluralSight – PostgreSQL Core Administration and Operational Maintenance 2026
English | Tutorial | Size: 269.85 MB


Proper installation and configuration lay the foundation for a stable, secure PostgreSQL environment. In this course, you’ll learn essential DBA skills to install, configure, back up, and automate maintenance for PostgreSQL instances.