Introduction to Database
This course aims to have an introductory to relational databases with emphasis on building complex schemas and queries for transactional and decision-making systems. It prepares data scientists, administrators, engineers for the effective development and deployment of database applications. The course presents the fundamental features of traditional database architectures, with a specific emphasis on (i) the entity-relationship model, (ii) the relational model, (iii) Advanced SQL and Database application development. The course will also illustrate the main directions of the evolution of database systems in the field of Big Data, including Documents stores, Graph Stores and LLM-friendly stores.
Objectives:
- Understand fundamental concepts of database systems and data models.
- Write and optimize SQL queries for data retrieval and manipulation.
- Understand DB designing principle.
- Apply Normalization and integrity constraints management to ensure consistency.
- Understand NoSQL principles, models and modern storages systems.
Course Sequences:
- Seq 1: Database & DB Systems
- Seq 2: Data models & architectures
- Seq 3: E-R Modeling
- Seq 4: Relational modeling
- Seq 5: Normalization & Algebra expression
- Seq 6: Structured Query Language (SQL)
- Seq 7: Advanced SQL
- Seq 8: Physical Model
- Seq 9: Data warehousing
- Seq 10: Data Ingestion & Analytical query
- Seq 11: Documents store
- Seq 12: Graph Store
- Seq 13: Vectorized Databases
- Seq 14: Data values, qualities and security
Learning Outcomes
- Explain the purpose and components of a Database Management System (DBMS).
- Implement relational databases and use SQL to create, query, and manipulate data.
- Apply Normalization to eliminate redundancy and improve efficiency.
- Management of basic administration tasks, including user management and backups.
- Explain the differences between relational and NoSQL databases, and when to use each.
- Implement Data warehouse using dimensional modeling to support decision-making.
Assessments
- Individual: Quizzes (5%), Assignments (40%), Exams (35%)
- Group: project (20%)
Meeting days and times
- Lectures : Wednesday 10.15-12.00 / Room : Delta building - 2045
- Practices: Thursday 14.15 - 16.00 / Room : Delta building - 2045
- NB: Lectures and Practices content will be recorded and posted online on Panopto
Teaching Staff
| Name | Position | |
|---|---|---|
| Miika Juhani Hannula | miika.juhani.hannula@ut.ee | Lecturer |
| Simon Pierre DEMBELE | simon.pierre.dembele@ut.ee | Lecturer |
| Assistant 1 | Assistant |
For helps
- Office: (Delta:3107)
- UniTartuCS IT support: ati.comp@ut.ee