Database Design

Learn to design scalable, high-performance databases for modern applications - from schema design and indexing to SaaS architecture and APIs.

This course teaches how to design robust, scalable, and maintainable database systems for modern applications. It focuses on real-world schema design, performance considerations, and how database decisions directly impact APIs and system architecture.

Target audience
Backend developers, fullstack engineers, and DevOps professionals working with relational or hybrid database systems.

Agenda
● Relational modeling fundamentals in real systems
● Normalization vs denormalization trade-offs
● Designing schemas for APIs and business domains
● Indexing strategies and query optimization
● Transactions, locking, and consistency models
● PostgreSQL vs NoSQL: when to use what
● Designing multi-tenant and SaaS-ready schemas
● Common database design mistakes in production systems

Hands-on
Participants design a full database schema for a SaaS application (users, billing, roles, permissions), including relationships, indexing strategy, and API alignment.

Instructor
The training is conducted by an experienced consultant from The Better Software Initiative.

Practical information
Training language and study materials will be in English.