Postgresql For Developers: Design, Query & Scale Databases
https://WebToolTip.com
Published 8/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 597.64 MB | Duration: 2h 53m
Master PostgreSQL fundamentals, advanced queries, and performance tuning tailored for developers.
What you'll learn
Fundamentals of Relational Databases
Installation and Configuration of PostgreSQL
Creating Databases and Users
Basic SQL Commands (SELECT, INSERT, UPDATE, DELETE)
Data Types and Operators in PostgreSQL
Advanced SQL Queries (joins, subqueries, set operations)
Aggregate Functions (SUM, AVG, COUNT, MIN, MAX)
Grouping Data with GROUP BY
Designing Database Schemas
Creating Tables and Defining Relationships
Primary Keys, Foreign Keys, and Unique Constraints
Transactions and Data Integrity
Triggers and Rules
PostgreSQL Extensions and Modules
Requirements
No prior SQL or PostgreSQL experience required