Databases
Course code
IFI6106.DT
old course code
IFI6106
Course title in Estonian
Andmebaasid
Course title in English
Databases
ECTS credits
4.0
approximate amount of contact lessons
56
Teaching semester
autumn
Assessment form
Examination
lecturer of 2019/2020  Autumn semester
Priidu Paomets (eesti keel) tavaline kursus
lecturer of 2019/2020  Spring 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
Exam.
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.
Teacher
Priidu Paomets