Database Fundamentals
What a database is, why it exists and which problems it solves.
9 of 9 lessons published 240 min
Free database design course
From requirements analysis to SQL, with interactive E-R diagrams
A complete, free course on database design: requirements analysis, conceptual design with the Entity-Relationship model, schema restructuring, logical design, normalization, physical design and SQL. Every step uses the same running case study and can be practised in the ERMap editor.
Every module follows the same sequence: from the informal description of a problem to a database that actually runs.
Understand the problem before drawing anything.
Model the reality with entities, attributes and relationships.
Simplify the schema and make identifiers explicit.
Translate the schema into relations, keys and foreign keys.
Remove redundancy and update anomalies.
Choose data types, indexes and constraints in MySQL.
Create, populate and query the database.
Modules are published one lesson at a time. A module is listed as soon as its syllabus is fixed, and each lesson becomes available when it is finished and reviewed.
What a database is, why it exists and which problems it solves.
9 of 9 lessons published 240 min
Turn an informal description of a problem into a precise set of requirements.
9 of 9 lessons published 210 min
Build correct Entity-Relationship schemas from requirements.
3 of 22 lessons published 720 min
Transform a conceptual schema without losing information.
0 of 11 lessons published 330 min
Translate a restructured E-R schema into relations.
0 of 15 lessons published 420 min
Remove redundancy and anomalies from relations.
0 of 12 lessons published 360 min
Choose data types, indexes, constraints and storage for MySQL.
0 of 15 lessons published 420 min
Query and modify the database you have designed.
0 of 20 lessons published 480 min
Every concept is paired with a complete E-R diagram you can open in the editor, inspect attribute by attribute, and copy into your own projects.
A path designed for anyone who studies, teaches or designs databases.
Follow the lessons in order, practise on the diagrams and prepare for database and computer science exams.
Use the lessons and examples as teaching material, in class or as homework.
Start from the fundamentals and reach SQL with a structured path and complete case studies.
Yes: ERMap Academy is free and the public lessons can be read without any purchase.
No: lessons and examples are public. An account is only needed to save projects in the editor.
The course is published in Italian, English, Spanish and French; missing translations are indicated on the lesson page.
Every lesson links to diagrams you can open in the editor to change entities, attributes and cardinalities and check your design choices.
Need help using the editor or the site? Read the Help guide to the site features. Help guide to the site features