PostgreSQL for Developers: Design, Query & Scale Databases

Install and configure PostgreSQL on Windows by downloading the installer, setting the data folder and password, and verifying the local server on port 5432 with pgAdmin.

Learn practical PostgreSQL server administration by creating databases, managing users and permissions, enabling connect access, and performing read/write operations across schemas with monitoring and security practices.

Explore PostgreSQL basics by building a sample employees table and executing the five core SQL commands: create, insert, select, update, and delete through practical step-by-step examples.

Explore PostgreSQL data types and operators by creating and populating a sample employees table, applying arithmetic, text, and conditional operators to query and analyze joining dates and ages.

Explore advanced PostgreSQL queries with joins, subqueries, and set operations while building tables, inserting data, and performing inner and left joins to analyze departments and employees.

Create a sales table, insert sample data, and apply aggregate functions (sum, avg, count, min, max) to compute total quantity, average price, and min/max price.

Learn to group data with the group by clause, compute totals like total quantity and total revenue, and generate detailed breakdowns by product and region.

Design and implement PostgreSQL database schemas, create tables within named schemas, enforce constraints like primary keys and unique keys, and build a reporting view for monthly sales analysis.

Create and relate tables in PostgreSQL by defining primary keys, serial ids, and foreign keys to establish one-to-one, one-to-many, and many-to-many relationships among employees, departments, and projects.

Explore PostgreSQL transactions and data integrity by using begin, commit, and rollback to atomically manage updates to a banking-style accounts table.

Explore creating and using stored procedures and functions in PostgreSQL to automate data operations, including building an employees table, inserting records, and querying salaries with plpgsql.

Explore designing audit trails in PostgreSQL with triggers and rules. Create trigger functions to log inserts and price changes on a product table and test with insert and update.

Explore how to install and use PostgreSQL extensions like pg_trgm, postgis, and uid, including creating extensions, configuring geospatial data, and building tables with geographic coordinates for real-world applications.

Learn how PostgreSQL stores and queries json data by creating a users table with a json column, inserting records, and extracting name and email with the arrow operator.

Master the security and access control features in PostgreSQL by creating and managing roles and permissions, granting access on the users table, and implementing row-level security for multi-tenant data.