Ingegneria informatica (Ακαδημαϊκό έτος 2019/2020) - Information and communication technologies engineering (riservato agli studenti della Helwan University, Cairo, Egitto)

Databases

Πιστώσεις: 6

Γλώσσα περιεχομένου:Αγγλικά

Προϋποθέσεις

Fondamenti di informatica.

Πρόγραμμα

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.

Βιβλίο

P.Atzeni, S. Ceri, S. Paraboschi, R. Torlone, "Database Systems", McGraw-Hill

Περιοχή Καθηγητή

Fernando Ferri

Λίστα μαγνητοσκοπημένων παραδόσεων

• Μάθημα αρ. 1: Characteristics of DB Approach		Evangelia Kavakli
• Μάθημα αρ. 2: Basic concepts		Evangelia Kavakli
• Μάθημα αρ. 3: Implications of DB Approach		Evangelia Kavakli
• Μάθημα αρ. 4: Database System Architecture		Evangelia Kavakli
• Μάθημα αρ. 5: The Entity-Relationship (ER) Model . Part I		George Tsekouras
• Μάθημα αρ. 6: The Entity-Relationship (ER) Model . Part II		George Tsekouras
• Μάθημα αρ. 7: The Extended-Entity-Relationship (EER) Model		George Tsekouras
• Μάθημα αρ. 8: The Relational Model . Part I		George Tsekouras
• Μάθημα αρ. 9: The Relational Model . Part II		George Tsekouras
• Μάθημα αρ. 10: ER-To-Relational Mapping; File Organization		George Tsekouras
• Μάθημα αρ. 11: Introduction to SQL		Christos Anagnostopoulos
• Μάθημα αρ. 12: Table Basics in SQL		Christos Anagnostopoulos
• Μάθημα αρ. 13: Data manipulation in SQL. Part I		Christos Anagnostopoulos
• Μάθημα αρ. 14: Data manipulation in SQL. Part II		Christos Anagnostopoulos
• Μάθημα αρ. 15: Advanced SQL		Christos Anagnostopoulos
• Μάθημα αρ. 16: Optimizing database transactions - Web Database Concepts - Introduction to MySQL		Damianos Gavalas
• Μάθημα αρ. 17: Introduction to MySQL: command-line, administration tools and user rights system		Damianos Gavalas
• Μάθημα αρ. 18: MySQL: Practice with MySQL Monitor, Creation of tables & indexes, data types		Damianos Gavalas
• Μάθημα αρ. 19: Managing MySQL databases with the phpMyAdmin administration tool		Damianos Gavalas
• Μάθημα αρ. 20: Web applications enabled by PHP-MySQL interaction		Damianos Gavalas
• Μάθημα αρ. 21: The Microsoft Access DBMS		Evangelia Kavakli
• Μάθημα αρ. 22: Exercises on the ER Model and the EER Model		George Tsekouras
• Μάθημα αρ. 23: SQL exercises		Christos Anagnostopoulos
• Μάθημα αρ. 24: Advanced SQL exercises		Christos Anagnostopoulos
• Μάθημα αρ. 25: Forms and reports in MS Access		Damianos Gavalas

Please login

Please login

Menu secondario

Ingegneria informatica (Ακαδημαϊκό έτος 2019/2020) - Information and communication technologies engineering (riservato agli studenti della Helwan University, Cairo, Egitto)

Databases