From Queries to Clusters

Mastering Database Architecture, Performance, and Beyond.

What is a database? Types (Relational vs. NoSQL). Core components: schema, tables, indexes, transactions.

Core Topics

Relational vs. NoSQL databases
Tables, schema, primary/foreign keys
Popular DBs: PostgreSQL, MySQL, Oracle, MongoDB, Redis
Project: Install PostgreSQL/MySQL and run your first SQL query (create tables for a bookstore, insert/select/update/delete data).

Test Your Knowledge

Database System Concepts (Silberschatz)

by Ch. 1 & 2

PostgreSQL Tutorial Introduction

by PostgreSQL Docs