Course title in Estonian
Course title in English
approximate amount of contact lessons
autumn - spring
lecturer of 2019/2020 Spring semester
õppejõud on määramata
lecturer of 2020/2021 Autumn semester
lecturer not assigned
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.
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.
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.
lektor Jaagup Kippar
Kippar, Jaagup, Savisaar, Erki. Andmebaasipõhiste veebirakenduste arendamine Microsoft Visual Studio ja SQL Server’i baasil. SQL ja andmed. Tallinn, 2010.
Eessaar, Erki. Andmebaaside projekteerimine. Tallinna Tehnikaülikool 2008.
Aine on asenduskirjanduse alusel võimalik läbida vaid eraldi kokkuleppel õppejõuga.