Database Lab
Course code
IFI6090.DT
old course code
IFI6090
Course title in Estonian
Andmebaaside praktikum
Course title in English
Database Lab
ECTS credits
3.0
approximate amount of contact lessons
42
Teaching semester
autumn - spring
Assessment form
assessment
lecturer of 2019/2020  Autumn semester
õppejõud on määramata
lecturer of 2019/2020  Spring semester
lecturer not assigned
Course aims
Support theoretical background and practical skills for creating and using middle-size databases.
Brief description of the course
Main concepts with relational databases: database, table, field, data type, row. SQL commands for creating and changing data table. Commands for insert, update and delete data. Different queries, sorting, searching. Aggregate functions and grouping data. Joining tables with queries. One to many and many to many data structures and queries with them. SQL commands handling workflow data. Subqueries replacing value, list and table. Joining subqueries for getting complicate results. Indexing, accelating queries. Automatically running triggers. Business logic with saved procedures. SQL standard and company-based additions. Planning and realizing database schema. Creating and optimizing queries with test data. Automated tools for creating database user interface. Database commands in different programming languages.
Independent work
Creating own solutions based on examples started at classes.
Learning outcomes in the course
Student can practitally design and develop real middle-sized databases for applications (~20 joined data tables). He can plan them, analyze structure and manipulate data with SQL. He can create different queries which are needed for applications using that database.
Assessment methods
Explanation of 5 independent works, control work and seminar. For finishing course, all things must be done. With exception solving hardest item in control work allows not to do one independent work.
Teacher
lektor Jaagup Kippar
Study literature
Kippar, Jaagup, Savisaar, Erki. Andmebaasipõhiste veebirakenduste arendamine Microsoft Visual Studio ja SQL Server’i baasil. SQL ja andmed. Tallinn, 2010.
http://minitorn.tlu.ee/~jaagup/kool/java/loeng/dotnet/sql.docx

Eessaar, Erki. Andmebaaside projekteerimine. Tallinna Tehnikaülikool 2008.
Replacement literature
Aine on asenduskirjanduse alusel võimalik läbida vaid eraldi kokkuleppel õppejõuga.