CORE COMPUTER SCIENCE

Databases

Design structured relational data models and guarantee data integrity using transaction properties.

~30 hours

Learning Objectives

Relational Data ModelingNormalization (1NF, 2NF, 3NF)SQL QueryingIndexes and PerformanceACID Transactions

Design an e-commerce schema (Users, Orders, Products, Order_Items), write the SQL to create the tables, and query the total revenue per user.

📖 Learn by Reading

Database System Concepts

Abraham Silberschatz, Henry F. Korth, S. Sudarshan

Comprehensive coverage of database modeling, SQL, normalization, and transaction management.

🎥 Learn by Watching

Database Design Course - Learn how to design and plan a database

freeCodeCamp.org • YouTube • 8:00:00

Comprehensive introduction to relational schemas and normalization.