Corso Vittorio Emanuele II, 39 - Roma 0669207671

Computer engineering (Academic Year 2022/2023) - Information and communication technologies engineering (reserved for the students of Helwan University, Cairo, Egypt)

Databases


Credits: 6
Content language:English
Course description
Basic aspects of database design and management. Relational model for logic database design. Entity-relationship model for conceptual design.
Prerequisites
Good programming skills in C and knowledge of the main data structures.
Program
Fundamentals of databases • Information Systems and Databases • Database Management System Architecture • Conceptual and logic database design • Conceptual Models: • The Entity-Relationship Model (ER), The Extended-Entity-Relationship Model (EER) • The relational model: relations and tables, relational algebra, integrity constraints • SQL: DML and DDL in SQL • SQL queries • Integration of SQL in programming languages • Transaction optimization • Sample DBMS: MySQL, MS Access
Book
P.Atzeni, S. Ceri, S. Paraboschi, R. Torlone, "Database Systems", McGraw-Hill Database Systems: concepts, languages and architectures (P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone) McGraw-Hill, 1999. ISBN 0072353872.
Professor/Tutor responsible for teaching
Fernando Ferri
Video professors
Prof. Evangelia Kavakli - Aegean University (Mytilene, Lesvos - Greece)
Prof. George Tsekouras - Aegean University (Mytilene, Lesvos - Greece)
Prof. Christos Anagnostopoulos - Aegean University (Mytilene, Lesvos - Greece)
Prof. Damianos Gavalas - Aegean University (Mytilene, Lesvos - Greece)
List of lessons
Evangelia Kavakli
    •  Lesson n. 2: Basic concepts  Go to this lesson
Evangelia Kavakli
Evangelia Kavakli
Evangelia Kavakli
George Tsekouras
George Tsekouras
George Tsekouras
George Tsekouras
George Tsekouras
George Tsekouras
Christos Anagnostopoulos
Christos Anagnostopoulos
Christos Anagnostopoulos
Christos Anagnostopoulos
    •  Lesson n. 15: Advanced SQL  Go to this lesson
Christos Anagnostopoulos
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Evangelia Kavakli
George Tsekouras
    •  Lesson n. 23: SQL exercises  Go to this lesson
Christos Anagnostopoulos
Christos Anagnostopoulos
Damianos Gavalas