Week - 1 |
Database basic concepts |
Week - 2 |
Relational Data Model and Relational Database Constraints |
Week - 3 |
Relationships Between Entities: 1-1, 1-N, N-M Type Relationships |
Week - 4 |
SQL (DDL) – Data Definition Language |
Week - 5 |
Normalization 1NF and 2NF |
Week - 6 |
Normalization 3NF and 4NF |
Week - 7 |
Midterm |
Week - 8 |
Midterm |
Week - 9 |
SQL Data Types |
Week - 10 |
Basic SQL Operations (SELECT) |
Week - 11 |
ORDER BY , ASC-DESC , WHERE (number or “text”), AND-OR Operations |
Week - 12 |
GROUP BY, HAVING |
Week - 13 |
Basic SQL Operations (INSERT, UPDATE, DELETE) |
Week - 14 |
Sub-queries |