Preparing your workspace
Learn the core ideas behind databases, including data storage, tables, rows, columns, keys, relationships, constraints, normalization, queries, indexes, transactions, and different database types.
Understand what a database is, why applications need databases, and how databases store and retrieve information.
Understand the major database categories and the difference between relational databases and common NoSQL approaches.
Learn the basic structure of relational databases using tables, rows, and columns.
Understand primary keys, unique identifiers, and why every important record needs a reliable way to be identified.
Learn how database tables are connected using relationships and foreign keys.
Understand the four basic operations that applications perform on stored data.
Learn how database constraints protect data quality and what NULL means.
Understand what database indexes are, why they improve some queries, and why indexes also have costs.
Learn what database transactions are and understand the basic ACID properties.
Learn the basic principles of designing a database, avoiding unnecessary duplication, and evolving its structure safely over time.