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

Databases

Filter by academic year:

Material related to the whole subject. n. 26.1 - BIbliografy (A.Y. 2011/2012)

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