Course code
old course code
Course title in Estonian
Course title in English
ECTS credits
approximate amount of contact lessons
Teaching semester
Assessment form
lecturer of 2019/2020  Spring semester
õppejõud on määramata
lecturer of 2020/2021  Autumn semester
lecturer not assigned
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
Independent work
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
Assessment methods
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.
Priidu Paomets