📄️Introduction to DBMS
A database is an organised collection of data; a database management system (DBMS) is the software that stores, retrieves and protects it.
📄️Relational Model and Keys
Data is stored in relations (tables) made of tuples (rows) and attributes (columns).
📄️SQL Basics
SQL (Structured Query Language) is the standard language for relational databases.
📄️Joins, Aggregation and Subqueries
Sample tables
📄️Normalization
Normalization organises tables to reduce redundancy and avoid anomalies:
📄️Transactions, Concurrency and Indexing
Transactions and ACID