VisaSpark
Sign in

Database Design & PostgreSQL

Beyond basic SQL: relational modeling, normalization, transactions, indexing, and the operational discipline a real production database needs. Each course below is independent -- start with whichever one fits what you want to learn.

Database Design and PostgreSQL

Beyond basic SELECT: relational modeling, normalization, real PostgreSQL data types and schema implementation, advanced querying, transactions and concurrency, indexing, and operational safety.

14 lessons9hadvanced
Start course
  1. 1. Relational Modeling: Entities, Attributes, and Relationships
  2. 2. Primary Keys, Foreign Keys, and Constraints
  3. 3. Normalization: First and Second Normal Form
  4. 4. Third Normal Form and Denormalization Tradeoffs
  5. 5. PostgreSQL Data Types and DDL
  6. 6. Implementing a Normalized Schema in PostgreSQL
  7. 7. Joins and Aggregation, Beyond the Basics
  8. 8. Subqueries and Common Table Expressions
  9. 9. Window Functions: Calculations Across Rows Without Collapsing Them
  10. 10. Transactions and ACID Guarantees
  11. 11. Concurrent-Update Problems and Isolation Levels
  12. 12. Indexes, Composite Indexes, and Reading EXPLAIN
  13. 13. Views, Roles, and the Principle of Least Privilege
  14. 14. Migrations, Schema Evolution, and Operational Safety