PostgreSQL Tutorial

PostgreSQL Fundamentals

1 Introduction to PostgreSQL 5 min 2 Install PostgreSQL and pgAdmin 5 min 3 CREATE DATABASE and Schemas 5 min 4 Tables, Constraints, and SERIAL 5 min 5 SELECT Queries and Filtering 5 min 6 JOINs and Subqueries 5 min

Advanced PostgreSQL

7 Indexes and EXPLAIN ANALYZE 5 min 8 JSONB Columns and Queries 5 min 9 Transactions and Isolation Levels 5 min 10 Views and Materialized Views 5 min 11 PostgreSQL with .NET (Npgsql) 5 min 12 PostgreSQL Interview Questions 5 min