Corso Vittorio Emanuele II, 39 - Roma 0669207671

Ingegneria Informatica/Information and communication technologies engineering (with Helwan University) (Academic Year 2006-2007)

Databases


CFU: 5
Content language:
Prerequisites
Fondamenti di informatica.
Program
  • Fundamentals of databases
  • The relational model: relations and tables, relational algebra, integrity constraints
  • Normal forms
  • SQL: data definition and queries in SQL
  • Resources and privileges in SQL
  • Integration of SQL in programming languages
  • Transaction optimization
  • Fault management
  • Conceptual and logic database design
  • The Entity-Relationship model.
Book
P.Atzeni, S. Ceri, S. Paraboschi, R. Torlone, "Database Systems", McGraw-Hill
Professor/Tutor responsible for teaching
Paolo Prinetto
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