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.
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
Cíl předmětu - angličtina
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 ..
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
Literatura - angličtina
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
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
Požadavky ke zkoušce - angličtina
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.
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
Sylabus - angličtina
Database systems
History of data storing and processing
Database approach and database management systems
Database system architecture
Database models
Conceptual modeling
Entity Relationship Diagram
Database design
Relational databases, keys, indexes
Datatypes and attributs
Database normalization
Normal forms and database schemas
Decompozition and synthese
SQL
Sublanguages
Procedural extensions
Data queries
Server administration
Structure definition
Data queries with advenced options
Data access control
Poslední úprava: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)
