🔹 SQL Foundations

Learn core SQL concepts to query and manipulate data.

• SELECT, WHERE
• ORDER BY, LIMIT, OFFSET
• DISTINCT
• JOINs and Aggregates
• Subqueries
• CTE (Common Table Expressions) basics

---

🔹 Schema Foundations

Understand how relational databases are structured.

• Tables and columns
• Primary & Foreign Keys
• Relationships (1-1, 1-M, M-M)
• Constraints (NOT NULL, UNIQUE, etc.)
• Normalization basics

---

🔹 PostgreSQL Basics

Get started with PostgreSQL tools and environment.

• What is PostgreSQL
• Architecture overview
• Installation and setup
• psql (CLI)
• GUI tools (pgAdmin, etc.)
• Data types
• CRUD operations
• Transactions basics

Resources:

Books:

Tutorials:

Videos:

🔹 App Development Basics

Learn how PostgreSQL is used in real-world applications and backend systems.

• PostgreSQL drivers & connectivity
• Schema design for applications
• Introduction to indexing
• Understanding EXPLAIN and query behavior

---

🔹 Admin Foundations

Build essential database management and operational skills.

• Users and roles management
• Privileges and access control
• Backup using pg_dump
• Restore basics
• Logs and monitoring awareness

---

Resources:

Books:

Tutorials:

Videos:

🔹 Conceptual Foundations

Build a deeper understanding of how PostgreSQL works internally and how it evolves over time. This track prepares you for advanced topics like performance, concurrency, and system design.

• PostgreSQL history and evolution
• Introduction to MVCC (Multi-Version Concurrency Control)
• Version awareness and release cycles
• Open-source ecosystem and community basics

---

Resources:

Books:

Tutorials:

Videos: