Course Content
Week 1: Introduction to database systems
Week 2: Data modeling – ER diagrams
Week 3: ER to relational model
Week 4: SQL basics – SELECT, WHERE
Week 5: Joins
Week 6: Aggregations (GROUP BY, HAVING)
Week 7: Subqueries
Week 8: DDL (CREATE, ALTER, DROP)
Week 9: DML (INSERT, UPDATE, DELETE)
Week 10: Normalization
Week 11: Indexes and query optimization
Week 12: Transactions and ACID properties
Learning Outcomes
Upon successful completion of the course, students will be able to:
Understand core concepts of database systems
Design relational databases using ER modeling
Use SQL effectively
Define and manipulate database structures (DDL)
Manage data using SQL (DML)
Write complex queries (joins, subqueries, aggregations)
Apply integrity constraints
Understand normalization principles
Analyze and improve query performance
Use a DBMS (e.g., PostgreSQL, MySQL) in practical scenarios
