Databases

 Introduction to Database Management Systems (DBMS). Architecture of a DBMS. Data modeling data with the Entity-Relationship Model. Relational Model. Relational Algebra and Relational Calculus. SQL Language. Design of a Database. Physical organization of a DBMS. Storage media. File organizations and indexes. Tree indexes and files (B-trees, B+trees). Random static and dynamic files (hashing). Processing and optimization of queries. Transaction processing and concurrency techniques. Recovery techniques. Techniques of security and authorization.

After the successful course attendance a student will:

• Be able to design the ER diagram matching specifications and transform it into tables.
• Be able to form queries in relational algebra.
• Be able to create a schema, create and manage tables, insert/update/delete rows, write SQL queries matching the basic operations in relational algebra.
• Be able to write aggregation queries and use subqueries.
• Be able to create views, write stored procedures and triggers in MySQL.
• Be able to normalize a DB schema.
• Acquire basic background regarding transactions and concurrency control protocols.
• Be able to write transactions in MySQL.
• Acquire basic background regarding table storage, primary indexing, multilevel indexing, B and B+ trees, hashing.
• Be able to create indices in MySQL.

• Συστήματα Βάσεων Δεδομένων, Θεωρία & Πρακτική Εφαρμογή Ιωάννης Μανωλόπουλος – Απόστολος Ν. Παπαδόπουλος, ΕΚΔΟΣΕΙΣ ΝΕΩΝ ΤΕΧΝΟΛΟΓΙΩΝ ΜΟΝ. ΕΠΕ,  1η/2006, ΑΘΗΝΑ, 3488
• Συστήματα Βάσεων Δεδομένων 6η Έκδοση, Abraham Silberschatz,Henry F. Korth,S. Sudarshan, Χ. ΓΚΙΟΥΡΔΑ & ΣΙΑ ΕΕ, 6η έκδ./2011, ΑΘΗΝΑ, 12535833
• Θεμελιώδεις αρχές συστημάτων βάσεων δεδομένων, Elmasri Ramez,Navathe Shamkant B., ΔΙΑΥΛΟΣ Α.Ε. ΕΚΔΟΣΕΙΣ ΒΙΒΛΙΩΝ, 6η Έκδοση Αναθεωρημένη/2012, ΑΘΗΝΑ, 22683637
• Εισαγωγή στην SQL, ΘΑΝΑΣΗΣ ΛΟΥΚΟΠΟΥΛΟΣ, “Ελληνικά Ακαδημαϊκά Ηλεκτρονικά Συγγράμματα και Βοηθήματα – Αποθετήριο “”Κάλλιπος”””, 1η/2016, ΑΘΗΝΑ, 59303653