804 Data Management
| Category: Elective Class Hours: 3 Laboratory Hours: 0 ECTS: 4 |
Course Type: Scientific Area Προαπαιτούμενα Μαθήματα: 304. Applied Informatics Language of Teaching and Exams: Greek Is the course offered to ERASMUS students: Yes (in English) |
Course Curriculum:
- Introduction to databases, basic concepts and the architecture of database systems
- Conceptual modeling and design of databases, the entity-relationship model
- Relational data model and introduction to the SQL language
- Database programming techniques (SQL and PHP)
- Object-Oriented, Object-Relational, and XML: Concepts, Models, Languages, and Standards
- Database design theory and normalization
- File structures, hashing, indexing and physical database design
- Query processing and optimization
- Transaction processing, subscription control and recovery
- Distributed databases, NO SQL systems, big data
- Advanced database models, systems and applications
- Database security
Literature:
1. R. Elmasri, S.B. Navathe, "Fundamental Principles of Database Systems", DIAVLOS Publications, 2016, Book Code in Eudoxos: 50662846
2. H. Garcia-Molina, J. Ullman, J. Widom, "Database Systems (In one volume)" Publications: University Press of Crete, 2012, Eudox Book Code: 22690971
3. E. Kechris, "Relational databases - New revised edition", KRITIKI Publications, 2015, Book Code in Eudoxos: 41955665
4. J. Ullman, J. Widom, "Fundamentals of Database Systems", KLEIDARITMOS Publications, 2008, Eudoxus Book Code: 13619
