stackademic

The leading education platform for anyone with an interest in software development.

Learning Paths / Learn Databases

databases
beginner
5h estimated

Learn Databases

Understand relational database design: keys, normalization, indexes, transactions, ACID, and SQL vs NoSQL.

Start learning →

Foundations

  1. 1

    Relational Basics

    How relational databases organize data into tables of rows and columns

  2. 2

    Keys and Relationships

    Using primary and foreign keys to connect tables reliably

Design

  1. 1

    Normalization

    Organizing tables to reduce redundancy and avoid update anomalies

  2. 2

    Indexes

    How indexes speed up lookups and what they cost

Reliability

  1. 1

    Transactions

    Grouping multiple statements into one all-or-nothing operation

  2. 2

    ACID

    The four guarantees that make database transactions reliable

Choosing a Database

  1. 1

    SQL vs NoSQL

    How relational and non-relational databases differ and when to use each