Database Design

Data modeling, normalization, indexing, and query optimization for relational databases.

Topics:

• Entity-relationship (ER) models and normalization forms (1NF–3NF)
• Primary keys, foreign keys, and referential integrity
• Indexing strategies (B-tree, hash) for query performance
• Query optimization and execution plans
• Transactions, ACID properties, and isolation levels

Practical work with PostgreSQL and SQL, using ORMs (Django ORM, SQLAlchemy concepts) to bridge Python and databases. Covered in formal coursework and IBM’s Django Application Development with SQL and Databases.

Related: SQL, PostgreSQL, Django, Data Science