Corso Vittorio Emanuele II, 39 - Roma 0669207671

UNINETTUNO OpenupEd

University without boundaries

Beta

  • What are Uninettuno Massive Open Online Courses (MOOC)
    mooc-close

    Thanks to the UNINETTUNO MOOCs you will be able to freely follow the lectures of the best Italian and international lecturers drawn from a selection of the best courses of UNINETTUNO, in Italian, English and Arabic; you will have at your disposal digitised and indexed on-demand video lectures, usable on a PC as well as on smart phone and tablet, including hypertextual links to more-in-depth study materials (books and articles, practice work, slides, bibliographical references, lists of websites). You will also have at your disposal a collaborative discussion environment, a thematic forum by means of which you will be able to exchange views with your colleagues on the issues dealt with in the lectures, discuss the practice work done, cooperatively create new knowledge in a process that will see you active players of your own learning process.

  • How to get Credits (European Credits Transfer System) with Uninettuno MOOC
    mooc-close

    If you have enjoyed the MOOCs experience, you can transform it into an actual asset for your academic and professional career: by enrolling in the corresponding UNINETTUNO university course, you will be included into a class and have the support of a tutor who will guide you along your learning path; you will be able to participate in a course delivery cycle, interact with professors and tutors in real time in UNINETTUNO virtual classrooms on the Web (on live streaming) or in UNINETTUNO Island of Knowledge on Second Life; the tracking of your activities on the MOOCs will be recorded and you will be acknowledged as an attending student and will be able to sit for the exam that will allow UNINETTUNO to officially assign you – in case of success – the university study credits corresponding to the selected courses, based on the Credits (European Credits Transfer System) - European Credit Transfer System, recognised by the Italian and by EU universities.

The course # of Uninettuno allows you to get # university credits according with the European System ECTS (European Credits Transfer System) and legally recognized by European and International Universities.
In order to get credits you need to study online following the Uninettuno model until the final exam.
The certification fee of the course # is # Euros that you can pay by Bank transfer to:

Università Telematica Internazionale UNINETTUNO
IBAN: IT46 G030 6905 0201 0000 0070 068
BIC BCITITMM (only for bank transfers from abroad)
(Istituto Bancario: IntesaSanPaolo SpA
Via del Corso, n. 226 00186 Roma)

Once you have paid the registration fee for the single course you will be contacted by our student secretariat to arrange your online studies.
If you prefer you can contact our student secretariat by email at info@uninettunouniversity.net to be driven into the path of registration.

mooc-close

Ingegneria Informatica/Information and communication technologies engineering (with Helwan University) (Academic Year 2010/2011)

Databases


Credits: 5
Available languages: AR, EN, IT
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
Paolo Prinetto
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