FPF:UIAI016 Database systems for Administr - Course Information
UIAI016 Database systems for Administration
Faculty of Philosophy and Science in OpavaWinter 2014
- Extent and Intensity
- 2/2/0. 6 credit(s). Type of Completion: zk (examination).
- Teacher(s)
- prof. Ing. Dušan Marček, CSc. (lecturer)
Mgr. Marek Menšík, Ph.D. (seminar tutor) - Guaranteed by
- prof. Ing. Dušan Marček, CSc.
Institute of Computer Science – Faculty of Philosophy and Science in Opava - Prerequisites (in Czech)
- Znalost programování, znalost operačních systémů, základy informatiky
- Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
- fields of study / plans the course is directly associated with
- Applied Computer Science (programme FPF, B1802 AplI)
- Course objectives
- The course focuses on DB technology for their utilization and application in enterprices and institutions. The aim is to understand the use of DB technology, their theoretical background practical design and deployments, offers an extension of knowledge above administration of Microsoft SQL Server or MySQL and extends further knowledge of SQL language.
- Syllabus
- 1. Introduction to data base systems
2. Database management systems
3. The architectures of databases
4. Components of database systems
5. Date description language
6. Date manipulation language
7. Models of databases
8. Relational database model
9. Programming in MySQL
10. Practical design of relational databases
Activities
None
Guarantors and Lecturers
* Guarantors: Prof. Ing. Dušan MARČEK, CSc.
* Lecturer: RNDr. Miroslav LANGER, Ph.D.
* Tutorial lecturer: RNDr. Miroslav LANGER, Ph.D.
Literature
* Basic: MARČEK, M.: Technologie zpracování dat, databázové zpracování. SU, FPF, Ústav informatiky, Opava, 2008 , ISBN: 978-80-7248-480-5.
* Further literature: HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. 10. vyd. Upper Saddle River: Prentice Hall, 2011. ISBN 978-0-13-608839-4.
HOTEK, Mike. Microsoft SQL Server 2008 krok za krokem. Brno: Computer Press, 2009, ISBN 978-80-251-2466-6.
GROFF, James R. a Paul N. WEINBERG. SQL : kompletní průvodce. Brno: CP Books, 2005, ISBN 80-251-0369-2.
* Recommended: WALTERS, Robert E. Mistrovství v Microsoft SQL Server 2008 : [kompletní průvodce databázového experta]. Brno: Computer Press, 2009, ISBN 978-80-251-2329-4.
Prerequities
None
Other requirements
1 ongoing test, combined exam
- 1. Introduction to data base systems
- Literature
- required literature
- MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, SU FPF, UI, 2008. ISBN 978-80-7248-480-5. info
- recommended literature
- HERNANDEZ, Michael J. Myslíme v jazyku SQL: tvorba dotazů. Praha: Grada, 2000. ISBN 80-247-0899-X. info
- not specified
- GROFF, R. James a Paul N. WEINBERG. SQL kompletní průvodce. Brno, CP, 2005. ISBN 80-251-0369-2. info
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- The course can also be completed outside the examination period.
- Enrolment Statistics (Winter 2014, recent)
- Permalink: https://is.slu.cz/course/fpf/winter2014/UIAI016