Course code DatZ2011
Credit points 3
Data Bases
Total Hours in Course81
Number of hours for lectures16
Number of hours for seminars and practical classes16
Independent study hours49
Date of course confirmation20.04.2011
Responsible UnitInstitute of Computer Systems and Data Science
Course developer
Gatis Vītols
Dr. sc. ing.
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.