Database Systems
BASIC DATA
course listing
A - main register
course code
RAM0730
course title in Estonian
Andmebaasisüsteemid
course title in English
Database Systems
course volume CP
-
ECTS credits
6.00
to be declared
yes
fully online course
not
assessment form
Examination
teaching semester
autumn - spring
language of instruction
Estonian
English
Prerequisite(s)
Prerequisite 1
Information Systems Design (RAM0720)The course is a prerequisite
Study programmes that contain the course
code of the study programme version
course compulsory
yes
Structural units teaching the course
EV - Virumaa College
Timetable link
Version:
VERSION SPECIFIC DATA
course aims in Estonian
Õpetada andmebaaside arendusprotsessi, käsitledes seda infosüsteemi tervikarenduse komponendina. Praktiseerida objekt-orienteeritud ja relatsioonilisel andmebaasil põhineva klient-server lahenduse projekteerimist/ehitamist.
course aims in English
To teach database development process, to practice designing/building of the client-server solution which is based on object-orientated and relational database.
learning outcomes in the course in Est.
Üliõpilane tunneb andmebaaside arendusprotsessi, oskab kasutades SQL keelt koostada lihtsat klient-serveri andmebaasi, luua erinevaid andmebaasiobjekte.
learning outcomes in the course in Eng.
A student knows database development process, can use SQL for compile client-server database, create various database objects.
brief description of the course in Estonian
Infosüsteemide arhitektuur, klient/server andmebaasid ning nende loomine. Klient/server süsteemide arhitektuuri ja komponentandmebaaside loomine. Tabelite, piirangute, andmebaasiobjektide loomine ja modifitseerimine PostgreSQL ja Microsoft SQL Server näidetel. Normaliseerimine ja teised projekteerimise põhiprobleemid. Denormaliseerimine. Mälu- ja indeksistruktuurid. Indekseerimise tüübid. Päringute optimiseerimine. Salvestatud protseduurid ja kasutajafunktsioonid. Trigerid. Paralleelse töö korraldamine. Andmeturvalisuse tagamine. Andmebaaside administreerimine
brief description of the course in English
Architecture of info systems, distributed, client/server database and their creation. Database Management Systems, Architecture of client/server systems and database components creation. Creating and modifying tables, constraints; database objects on the example of PostgreSQL ja Microsoft SQL Server; normalisation and other basic problems of projection; denormalisation; memory and index structures; indexation types; query optimization; Store procedures and user functions; triggers; organizing parallel work; ensuring data security; administration of database.
type of assessment in Estonian
vt. fail
type of assessment in English
see attachment
independent study in Estonian
Iga tudeng teeb projekti. Andmebaasina tuleb kasutada PostgreSQL andmebaasi või Microsoft SQL Server.
independent study in English
Individual project using PostgreSQL database or Microsoft SQL Server.
study literature
1.Connolly, T.M., Begg, C.E. Database systems. A Practical Approach to Design, Implementation and Management. Pearson Education, 2014., 2.Paul Atkinson, Robert Vieira Beginning Microsoft SQL Server 2012 Programming, Wrox Publisher, 2016.
study forms and load
daytime study: weekly hours
4.0
session-based study work load (in a semester):
lectures
2.0
lectures
8.0
practices
2.0
practices
16.0
exercises
0.0
exercises
0.0
lecturer in charge
-
LECTURER SYLLABUS INFO
semester of studies
teaching lecturer / unit
language of instruction
Extended syllabus
2024/2025 spring