Course title in Estonian
Course title in English
approximate amount of contact lessons
lecturer of 2019/2020 Autumn semester
Priidu Paomets (eesti keel) tavaline kursus
lecturer of 2019/2020 Spring semester
lecturer not assigned
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
* 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
Complete and submit all individual tasks that were started in class.
All the individual tasks need to be submited and recieve a positive mark in order to be allowed to the exam.
Learning outcomes in the course
Ability to choose appropriate database for the task, keep it optimally operational when data volume and availability demands increase
In order to pass, one has to take the exam. To get to the exam, one needs to present individual assignments and solve given problems. The final grade will be calculated as 40% from assignments and 60% from exam.