Database Lab
space
Course code
IFI6090.DT
old course code
IFI6090
Course title in Estonian
Andmebaaside praktikum
Course title in English
Database Lab
ECTS credits
3.0
Assessment form
assessment
lecturer of 2023/2024 Spring semester
Not opened for teaching. Click the study programme link below to see the nominal division schedule.
lecturer of 2024/2025 Autumn semester
Not opened for teaching. Click the study programme link below to see the nominal division schedule.
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.
Learning outcomes in the course
Upon completing the course the 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;
- can create different queries which are needed for applications using that database.
Teacher
lektor Jaagup Kippar
space