Databases: SQL, NoSQL and modelling
Comes up in: Backend design
This concept is being written. It gets the full five steps — explanation, predict, interview angle, practice with tests, and review cards. Here is exactly what it will cover, so you can study it elsewhere in the meantime.
What it covers
- relational model
- SQL basics (SELECT, JOIN, GROUP BY, indexes)
- transactions and ACID
- isolation levels (overview)
- document, key-value, wide-column, graph stores
- choosing a database
Words you will know
What you will practise
- 10 SQL queries on a sample schema (runs in SQLite)
Interview questions this answers
- SQL vs NoSQL: how do you choose?
- What is a database index and what does it cost?