Databases

Storing and querying data reliably.

3 weeks · wk 9–11Applied pace6 topics18 Interview Questions

Why this pace:You've likely wired up MongoDB/Postgres in Node projects — go deeper into indexing, normalization, and query tuning you may have skipped.

SEC FOCUS

SQL injection defense: parameterized queries, least-privilege DB accounts, no string-concatenated queries.

Topics & Action Items (6)

SQL: joins, indexes, transactions

4-5 hrs

Normalization vs denormalization

2 hrs

NoSQL: document, key-value, graph stores

2-3 hrs

ACID vs BASE consistency models

1-2 hrs

Query optimization and indexing strategy

3 hrs

ORMs — and when to skip them

1-2 hrs

Previous Stage

Object-oriented programming

Next Stage

Testing