Databases

⚡ Performance, transactions and NoSQL

Speed up queries with indexes, guarantee integrity with ACID transactions and get to know the NoSQL world: documents, key-value, graphs, the CAP theorem and scaling.

What you'll learn

Index columns with CREATE INDEX and diagnose plans with EXPLAIN QUERY PLAN
Group operations into transactions with BEGIN, COMMIT and ROLLBACK complying with ACID
Compare SQL and NoSQL (documents, key-value, graphs, columnar) and choose based on the use case
Reason about the CAP theorem and scale with replication and sharding

Lessons

Indexes: speeding up searchesHow an index turns a linear search into a logarithmic one, when to create it and what it costs. Transactions and ACIDGrouping operations into an atomic unit, the four ACID guarantees and race conditions. NoSQL, the CAP theorem and scalingNoSQL families (documents, key-value, graphs, columnar), SQL vs NoSQL, CAP and how to scale.

Practice this module in the app

DevPath is a hands-on course: you read the theory here; in the app you put it into practice with exercises that really run, offline.

Start free in the app →