Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
This course is focused on techniques of data manipulation and storing. The main focus is on relational databases and SQL. Students gain skills in entity relational modeling, database design and using of SQL. During the course several databases will be designed and implemented on most popular database servers.
Cíl předmětu - angličtina
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
The focus of this subject is to introduce students to the problems of database systems, their theories and principles of database design. The course has several views on database technology, the main emphasis is on data modeling and data analysis. The course deals with various problems with access to data architecture, relational data model, ER model, normalization, data warehousing, distributed databases and knowledge bases. In the practical part, students practice their theoretical knowledge of designing and implementing database transformations of data models into relational database schema based on SQL standards. The course is also familiar with the basic operations manager database servers and their users access and other services, security and automatic data backup ..
Literatura - angličtina
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
Michael J. Hernandez: Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Addison-Wesley Professional, 2013
Codd, E. F. (1970). "A relational model of data for large shared data banks", Communications of the ACM 13 (6): 377. doi:10.1145/362384.362685
Požadavky ke zkoušce - angličtina
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
An exam is a combination of practical and theoretical part:
Theoretical part is leaded as an oral exam. In the practical part student constructs a SQL data query.
Sylabus - angličtina
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)