Databases
BASIC DATA
course listing
A - main register
course code
ICM0005
course title in Estonian
Andmebaasid
course title in English
Databases
course volume CP
4.00
ECTS credits
6.00
to be declared
yes
assessment form
Examination
teaching semester
autumn
language of instruction
Estonian
English
The course is a prerequisite
Data Analysis (ICM0031)
Study programmes that contain the course
code of the study programme version
course compulsory
IAAM17/25
yes
Structural units teaching the course
IC - IT College
Course description link
Timetable link
View the timetable
Version:
VERSION SPECIFIC DATA
course aims in Estonian
Kursuse eesmärgiks on anda kuulajatele piisavalt põhjalik ülevaade andmebaaside kavandamise metoodikatest, andmebaaside loomise ning käsitlemise meetoditest ja andmebaasisüsteemide kasutamisest infosüsteemide loomisel. Pärast kursuse läbimist peavad kuulajatel olema teadmised, mis võimaldavad neil luua iseseisvalt väiksemaid andmebaasisüsteemidel põhinevaid infosüsteeme ja osaleda suurte infosüsteemide arendusprojektides.
course aims in English
The aim of the course is to provide students with a sufficiently comprehensive overview of database design methods, database creation and handling methods, and database systems usage for creating information systems. After completing the course, the listeners have the knowledge that enables them to create smaller information systems based on database systems and participate in large-scale information systems development projects.
learning outcomes in the course in Est.
1. saab aru andmebaasi mõistest, selle tähendusest ja kohast erineva struktuuriga infosüsteemides.
2. omab ülevaadet andmebaaside valdkonnas kasutatavatest mõistetesüsteemist
3. tunneb andmemudelite erinevad füüsilisi ja loogilisi arhitektuure
4. oskab luua andmemudelite olemisuhte diagramme (ERD) ja dokumenteerida seda
5. omab algteadmisi andmekäsitluskeele SQL kasutamiseks
6. oskab SQL-keele abil luua (initsialiseerida) andmebaasi ja luua andmebaasi struktuuri
7. omab ülevaadet andmekäsitluse optimeerimise tehnikatest
8. omab ülevaadet andmete lukustusmehhanismidest andmebaasides ja lukustamisega kaasnevatest probleemidest
9. teab, mis on andmemudeli normaliseerimine ja andmemudeli erinevad normaalkujud
10. oskab luua Domeen-võtme normaalkujule normaliseeritud väikseid andmemudeleid
11. teab, mis on kasutajaõigused andmebaasides (kasutajad, kasutajagrupid, süsteemsed ja ressursi õigused)
12. oskab luua andmebaasides kasutajaid, kasutajagruppe ning anda neile õigusi
13. omab ülevaadet andmebaaside haldamiseks tehtavatest toimingutest
14. omab ülevaadet indeksite kasutamisest andmebaasides ja oskab neid luua ning kasutada
learning outcomes in the course in Eng.
1. understands the meaning of databases and their place in information systems, with different structure.
2. have an overview of the concepts used in data modelling and database systems.
3.knows the process of creating a data model and the techniques it uses.
4. have the basic knowledge for using SQL, the data management language.
5. acquire an overview of data management techniques.
6. get an overview of data locking mechanisms in databases and locking problems.
7. knows what is normalization of data models and different normal forms of data models (not normalized form, 1st normal form, 2nd normal form, 3rd normal form).
8. know the normalization and denormalization basic rules.
9. understand different anomalies of normal forms.
10. knows what are the user rights in databases (users, user groups, system and resource permissions)
11. understand problems resulting from user rights issues.
12. acquire an overview of database operations.
13. get an overview of the use of indexes in databases.
brief description of the course in Estonian
http://enos.itcollege.ee/~priit/E-kursus%20(I%20245)%20AB-de%20alused/

Kursus on mõeldud erinevate infotehnoloogia erialade tudengitele. Kursus on andmebaaside aluskursus s.t. mõeldud kuulajatele, kes ei ole veel läbinud ühtegi andmebaaside kursust.
Kursus eeldab, et selle kuulajad evivad elementaarse programmeerimise oskust ja tunnevad elementaarseid andmestruktuure (jada, puu, pinu, järjekord, teek, paisktabel).
brief description of the course in English
http://enos.itcollege.ee/~priit/E-kursus%20(I%20245)%20AB-de%20alused/

The course presumes that the audience has elementary skills of programming and elementary knowledge of data structures (sequence, tree, stack, queue, library, hash table).
The aim is to give the audience a sufficiently profound overview of the design methods of databases, creation and handling methods of databases and of the use of database systems in the creation of information systems. After completing the course the students should have the knowledge, which enables them to independently create smaller information systems based on database systems and to participate in big information system development projects.
type of assessment in Estonian
-
type of assessment in English
-
independent study in Estonian
Kirjeldus hindamiskriteeriumites
independent study in English
Described in the assessment criteria
study literature
Põhiõpik:
Fundamentals of Database Systems
Kirjastaja: Benjamin/Cummings Publishing Company
Autor: Ramez Elmsari, Shamkant B. Navathe
ISBN: ISBN: 0-8053-1753-8
Täiendav kirjandus:
A Hands-On Guide to Relational Database Design
Kirjastaja: Addison-Wesley Pub Co
Autor: Michael J. Hernandez
ISBN: 0-2016-9471-9
Database Processing: Fundamentals, Design and Implementation
Kirjastaja: Science Research Association
Autor: David M. Kroenke
ISBN: 0-1308-4816-6
Complete SQL Queries Training Course
Kirjastaja: Prentice Hall Computer Books
Autor: Michael J. Hernandez, Jon L. Viescas
ISBN:0-1308-9727-2
Database Systems: Design, Implementation, and Management
Kirjastaja: Course Technology
Autor: Peter Rob, Carlos Coronel
ISBN: 0-7600-1090-0
study forms and load
daytime study: weekly hours
4.0
session-based study work load (in a semester):
lectures
2.0
lectures
-
practices
0.0
practices
-
exercises
2.0
exercises
-
lecturer in charge
-
LECTURER SYLLABUS INFO
semester of studies
teaching lecturer / unit
language of instruction
Extended syllabus
2025/2026 autumn
Priit Raspel, IC - IT College
Estonian
    HindamiskriteeriumidENG_ ICM0005.pdf 
    display more
    2024/2025 autumn
    Priit Raspel, IC - IT College
    Estonian
      HindamiskriteeriumidENG_ ICM0005.pdf 
      2023/2024 autumn
      Priit Raspel, IC - IT College
      Estonian
        2022/2023 autumn
        Priit Raspel, IC - IT College
        Estonian
          2021/2022 autumn
          Priit Raspel, IC - IT College
          Estonian
            HindamiskriteeriumidENG_ ICM0005.pdf 
            2020/2021 autumn
            Priit Raspel, IC - IT College
            Estonian
              HindamiskriteeriumidENG_ ICM0005.pdf 
              2019/2020 autumn
              Priit Raspel, IC - IT College
              Estonian
                HindamiskriteeriumidENG_ ICM0005.pdf 
                2018/2019 autumn
                Priit Raspel, IC - IT College
                Estonian
                  HindamiskriteeriumidENG_ ICM0005.pdf 
                  2017/2018 autumn
                  Priit Raspel, IC - IT College
                  Estonian
                    HindamiskriteeriumidENG_ ICM0005.pdf 
                    Course description in Estonian
                    Course description in English