DBMS Sheet

    The relational model, SQL, normalization, indexing, query optimization, transactions and recovery — 10 patterns, 50 topics.

    10 Patterns50 Topics

    Interview Soon

    5 patterns, 25 topics — the ones that come up first

    5 patterns
    1
    Database Systems and Architecture5 topics
    Interview Soon
    5 sub
    Why Databases Exist
    core
    Data Abstraction and the Three-Schema Architecture
    core
    Data Models and Database Languages
    important
    Database System Structure
    important
    Database Users and the DBA
    depth
    2
    The Relational Model5 topics
    Interview Soon
    5 sub
    3
    Entity-Relationship Modelling5 topics
    Interview Soon
    5 sub
    4
    SQL5 topics
    Interview Soon
    5 sub
    5
    Normalization5 topics
    Interview Soon
    5 sub

    Deep Dive

    5 patterns, 25 topics for full coverage

    5 patterns
    DBMS Sheet