Università telematica internazionale UNINETTUNO

MOOC Massive Open Online Courses (Academic Year 2018/2019)

Databases

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
Professor not available
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 video lessons
Evangelia Kavakli
    •  Lesson n. 2: Basic concepts 
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 
Christos Anagnostopoulos
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Evangelia Kavakli
George Tsekouras
    •  Lesson n. 23: SQL exercises 
Christos Anagnostopoulos
Christos Anagnostopoulos
Damianos Gavalas

Headquarter

Corso Vittorio Emanuele II, 39
00186 Roma - ITALIA
Tax code number: 97394340588
P.IVA: 13937651001

Certified mail

info@pec.uninettunouniversity.net

Student Secretariat

tel: +39 06 692076.70
tel: +39 06 692076.71
e-mail: info@uninettunouniversity.net

Videoconferencing

Library 1st floor: 90.147.90.157
Meeting Room 5th floor: 90.147.90.158

Do you need further information?

Give us your contact details


Ask for information