Excel
Course title Data Bases
Course code DatZ2011
Credit points (ECTS) 3
Total Hours in Course 81
Number of hours for lectures 16
Number of hours for seminars and practical classes 16
Independent study hours 49
Date of course confirmation 20/04/2011
Responsible Unit Institute of Computer Systems and Data Science
 
Course developers
Dr. sc. ing., prof. Gatis Vītols

There is no prerequisite knowledge required for this course
 
Course abstract
Studies of basic functionality of databases are performed. Functionality and application of database management systems for the development of relation database are discussed. Students learn how to develop, normalize and create relationships between data tables. Table relationship types are evaluated. Theoretical and practical studies of data retrieval from tables with the help of SQL are performed. Students gain practical skills for work with the database management systems Microsoft Office Access and PostgreSQL, including development of database for storage of certain type of data.
Learning outcomes and their assessment
Students gain knowledge about general concepts of databases and Structured Query Language SQL. Practical skills about the development of databases for storage of various data types and retrieval of data with Structured Query Language are gained. Students have competences together with the group or individually analyze data, choose database management system and argue about technological solution for data storage and retrieval.
Compulsory reading
1. Date C.J. An Introduction to Database Systems, An 8th Ed. Boston: Addison Wesley, 2004. 983 lpp.
2. Beaulieu A. Learning SQL. Cambridge: O’Reilly, 2009. 3. Silberschatz A., Sudarshan S. Database System Concepts. New York : McGraw-Hill Companies, 2011. 1349 lpp.
Further reading
1. Groh M.R. Access 2010 Bible. Indianapolis: Wiley Publishing, Inc., 2010. (Pieejama pie studiju kursa atbildīgā mācībspēka).
2. Matthew N., Stones R. Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition. New York: Apress, 2005. (Pieejama pie studiju kursa atbildīgā mācībspēka). 3. Крёнке, Д. Теория и практика построения баз данных. Москва: Питер, 2003. 799 lpp.
Periodicals and other sources
1. Žurnāls "Data Base Journal", QuinStreet, Pieejams: http://www.databasejournal.com 2. Открытые системы. СУБД. Москва: Открытые системы. ISSN 1028-7493.