MySmartCoPilot

Your country

Tools that support it use your country for local currency, number formats, units and paper size. Your choice is saved only in this browser.

Computer science fundamentals

Database Management Systems

The planned outline of 16 modules. Lessons are written, run and reviewed before they are published.

Coming soon 16 modules

Coming soon. This track is being written. Below is its planned outline: a lesson appears here once its examples have been run and its technical review is signed off.

Planned outline

  1. Module 1

    Foundations: what a DBMS does and how it works

    Coming soon
  2. Module 2

    The relational model, keys and integrity

    Coming soon
  3. Module 3

    Conceptual design with the ER model

    Coming soon
  4. Module 4

    Relational algebra and relational calculus

    Coming soon
  5. Module 5

    SQL semantics: how queries really evaluate

    Coming soon
  6. Module 6

    Functional dependencies

    Coming soon
  7. Module 7

    Normal forms and decomposition

    Coming soon
  8. Module 8

    Storage and file organisation

    Coming soon
  9. Module 9

    Indexing

    Coming soon
  10. Module 10

    Query processing and optimisation

    Coming soon
  11. Module 11

    Transactions and schedules

    Coming soon
  12. Module 12

    Concurrency control

    Coming soon
  13. Module 13

    Logging and recovery

    Coming soon
  14. Module 14

    Storage engines, NoSQL and analytics

    Coming soon
  15. Module 15

    Distributed and cloud databases

    Coming soon
  16. Module 16

    GATE and interview readiness

    India-specific Coming soon

Related tools

SQL Formatter Readable, consistently indented SQL for 20 dialects — or a safe one-line copy. CSV to SQL Converter Typed CREATE TABLE and batched INSERTs, upserts or bulk-load scripts for six databases.

Official documentation

More in Computer science fundamentals