Udemy - Postgresql For Developers - Design, Query and Scale Datab...

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