Free database design course

ERMap Academy – 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.

Modules
8
Lessons available
21
Languages
IT · EN · ES · FR

The learning path

Every module follows the same sequence: from the informal description of a problem to a database that actually runs.

  1. 1

    Analysis of requirements

    Understand the problem before drawing anything.

  2. 2

    Conceptual design

    Model the reality with entities, attributes and relationships.

  3. 3

    Restructuring of the E-R schema

    Simplify the schema and make identifiers explicit.

  4. 4

    Logical design

    Translate the schema into relations, keys and foreign keys.

  5. 5

    Normalization

    Remove redundancy and update anomalies.

  6. 6

    Physical design

    Choose data types, indexes and constraints in MySQL.

  7. 7

    SQL implementation

    Create, populate and query the database.

The eight modules

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.

1 Beginner

Database Fundamentals

What a database is, why it exists and which problems it solves.

9 of 9 lessons published 240 min

2 Beginner

Requirements Analysis

Turn an informal description of a problem into a precise set of requirements.

9 of 9 lessons published 210 min

3 Intermediate

Conceptual Design

Build correct Entity-Relationship schemas from requirements.

3 of 22 lessons published 720 min

4 Advanced

Schema Restructuring

Transform a conceptual schema without losing information.

0 of 11 lessons published 330 min

5 Intermediate

Logical Design

Translate a restructured E-R schema into relations.

0 of 15 lessons published 420 min

6 Advanced

Normalization

Remove redundancy and anomalies from relations.

0 of 12 lessons published 360 min

7 Intermediate

Physical Design

Choose data types, indexes, constraints and storage for MySQL.

0 of 15 lessons published 420 min

8 Beginner

SQL and Database Usage

Query and modify the database you have designed.

0 of 20 lessons published 480 min

Learn by reading real diagrams

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.

Open the example library

Who the course is for

A path designed for anyone who studies, teaches or designs databases.

Students

Follow the lessons in order, practise on the diagrams and prepare for database and computer science exams.

Teachers

Use the lessons and examples as teaching material, in class or as homework.

Self-learners

Start from the fundamentals and reach SQL with a structured path and complete case studies.

Frequently asked questions

Is the course really free?

Yes: ERMap Academy is free and the public lessons can be read without any purchase.

Do I need an account to follow the lessons?

No: lessons and examples are public. An account is only needed to save projects in the editor.

Which languages is the course available in?

The course is published in Italian, English, Spanish and French; missing translations are indicated on the lesson page.

What is the ERMap editor for during the course?

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