Tiyaze Resource Hub — v1.0
Beginner 01 / 04 ~3 hrs 6 lessons

Introduction to
Databases

Before you write SQL, you need to understand what databases are, why they exist, and how they work. This module builds the conceptual foundation every database developer needs — from file systems to ACID, from tables to relationships.

// Lessons
Foundations
01
What is a Database?
The problem databases solve, data vs information, and why file-based systems failed.
→
02
Types of Databases
Relational, document, key-value, and graph models — when to use each.
→
03
How Databases Store Data
Pages, blocks, indexes, B-Trees, and the ACID guarantees that make databases reliable.
→
04
Tables, Rows & Columns
The relational model, data types, constraints, and how to design a well-structured table.
→
05
Keys & Relationships
Primary keys, foreign keys, one-to-many, many-to-many, and junction tables.
→
06
Intro to Database Management Systems
What a DBMS does, MySQL vs PostgreSQL vs SQLite, and the three-level architecture.
→
What You'll Learn
  • Explain what a database is and why file systems failed
  • Compare relational, document, key-value, and graph databases
  • Understand how pages, indexes, and ACID work
  • Design tables with correct data types and constraints
  • Model relationships using primary and foreign keys
  • Know which DBMS to use for common scenarios
Prerequisites

None. This is the conceptual foundation module. No software installation required — just a browser and curiosity.

Up next
SQL Fundamentals →