PostgreSQL

Master relational database design, querying, and administration with PostgreSQL.

• PostgreSQL
• SQL Fundamentals
• SELECT, WHERE, ORDER BY
• INSERT / UPDATE / DELETE
• Data Types
• Numeric & Text Types
• Date/Time & Boolean
• Tables & Constraints
• Primary & Foreign Keys
• UNIQUE, CHECK, NOT NULL
• Joins
• INNER, LEFT, RIGHT, FULL
• Indexes
• B-tree, GIN, GiST
• Views
• Materialized Views
• Stored Procedures & Functions
• Transactions
• ACID & Isolation Levels
• JSONB
• Full-Text Search
• Replication
• Performance Tuning
• EXPLAIN ANALYZE & Vacuuming
• psql CLI