Database
This course aims to have an introductory to relational databases with emphasis on building complex schemas and queries. It prepares data scientists for the effective development of database applications. The course presents the fundamental features of current 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 in the evolution of database systems in the area of Big Data.
Brief description of topics to be covered
- Introduction to Databases
- Conceptual design
- Relational Model
- SQL Languages (SQL)
- Data Warehousing
- ETL & SCD (Slowly Changing Dimensions)
- Analytical Queries
- Big Data (overview)
- Application Development
Lectures
Lecture/consultation: Wednesday 10.15 - 12.00 Delta - 2034
Some lectures content will be recorded and posted online on Panopto.ut.ee.
Practice session
Every week: Thursday 14.15 - 16.00 Delta - 1022
Contacts
- Responsible Lecturer: Simon Pierre
- Office: (Delta:3107)
- Report IT issues: UT IT support: it.ut.ee and UniTartuCS IT support: ati.comp@ut.ee