PostgreSQL: SQL & PostgreSQL from Scratch

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

Establishing Naming Conventions

Database Documentation Standards

Reviewing the Store Application

String Manipulation Functions

Working with Patterns and LIKE

Boolean Logic in Queries

COALESCE and Handling NULLs

Subqueries in WHERE Clauses

Introduction to Views

Managing Table Schemas

Understanding Indexes

Advanced Indexing Strategies

Using Sequences for IDs

Exporting and Importing Data

Database Security Basics

Analyzing Query Plans

Working with Schema Namespaces

Using DISTINCT for Clean Data

Common Table Expressions (CTEs)

Advanced Window Functions

Dealing with Time Zones

Recursive Queries

Database Constraints Refinement

Performance Tuning Checklists

Introduction to Stored Procedures

Creating Triggers

Working with Arrays

Full-Text Search Basics

Database Maintenance Tasks