PostgreSQL: SQL & PostgreSQL from Scratch

Introduction to the Relational Model

Setting Up Your PostgreSQL Environment

Creating Your Store Database

Designing the Products Table

Building the Customers Table

Introduction to SELECT Queries

Filtering Data with WHERE

Advanced Filtering Operators

Sorting Query Results

Limiting and Offsetting Results

Understanding Primary Keys

Implementing Foreign Keys

Applying NOT NULL and UNIQUE Constraints

Using CHECK Constraints

Normalizing the Store Schema

Inserting Records into Tables

Updating Existing Records

Deleting Records Safely

Introduction to Transactions

Advanced Transaction Management

Understanding INNER JOIN

Working with LEFT JOIN

Introduction to Aggregate Functions

Grouping Data with GROUP BY

Filtering Groups with HAVING

Using JSONB for Flexible Data

Working with UUIDs

Handling Timestamps