Databases
space
Course code
IFI6106.DT
old course code
IFI6106
Course title in Estonian
Andmebaasid
Course title in English
Databases
ECTS credits
4.0
Assessment form
Examination
lecturer of 2022/2023 Autumn semester
Priidu Paomets (language of instruction:Estonian)
lecturer of 2022/2023 Spring semester
Not opened for teaching. Click the study programme link below to see the nominal division schedule.
Course aims
Give an opportunity to learn how to select appropriate relational and other modern databases for the task at hand, keep them operational, optimize and scale them to match the demand.
Brief description of the course
Requirements for modern databases: fault tolerance, scaling, global access, high availability

Database classifications:
* SQL - traditional relational databases
* "No-SQL" - key-value store, columnar store, document store, graph db
* "New-SQL" - new generation relation databases meant to use distributed [cloud] environments

Management of relational databases, problems related to growth of the data, optimizations, replication, geo-replication, multi-tenancy, sharding, backup and recovery plans

Cloud databases (Azure, Amazone, Google), solutions for databases with global reach

Data consistency levels: ACID, CAP, BASE
Learning outcomes in the course
Upon completing the course the student:
- has ability to choose appropriate database for the task, keep it optimally operational when data volume and availability demands increase.
Teacher
Priidu Paomets
space