|
Week - 1 |
Introduction to databases and database management systems. |
|
Week - 2 |
The Entity-Relationship (E/R) model and advanced E/R concepts. |
|
Week - 3 |
From E/R diagrams to relational schema. |
|
Week - 4 |
QL basics: Data definition, querying, and data manipulation. |
|
Week - 5 |
Schema refinement: Functional dependencies, normalization, and normal forms. |
|
Week - 6 |
Transactions (TXNs): ACID properties and introduction to concurrency control. |
|
Week - 7 |
NoSQL databases. |
|
Week - 8 |
Modern data architectures: Data warehouse, data lake, and lakehouse approaches. |
|
Week - 9 |
Distribution, scalability, and performance approaches in database systems. |
|
Week - 10 |
Multi-model and specialized database systems. |
|
Week - 11 |
Geospatial databases in the AI era. |
|
Week - 12 |
Vector databases and similarity search. |
|
Week - 13 |
The intersection of AI and databases: AI agents, memory systems, and in-database machine learning. |
|
Week - 14 |
Data privacy in AI-era databases. |
Eskisehir Technical University Info Package