All courses

Développement

Model a Database With UML

Learn to model your databases with UML class diagrams and develop your conceptual model into a relational model.
DifficultyMedium8 hours
Interested in this free-access course?

All IT systems use a database, including mobile, web, and desktop applications. In this course, you will:

  • Discover the concept of a database, its purpose, and how to use it. 

  • Learn to recognize different types of data, some of which are very structured and some less so.

  • Model a database by creating your very first UML class diagram.

  • Learn how to translate your UML diagram into a relational model. 

Throughout the course, you will use the following scenario: you are part of a team of mobile application developers. One of the app’s original features is that you can visit filming locations used in your favorite films or television series. Your role on the team is to design the database structure. Your colleagues will be programming the application functionality.

There are no prerequisites for this course. You won’t be learning to write computer programs here. However, if you’d like to increase your knowledge after this course, SQL coding will be part of the next step.

When structured data needs to be modeled, the professional world widely uses relational data modeling. Sign up!

Learning outcomes

  • Analyze your data and choose the appropriate type of database
  • Create a UML class diagram for your database
  • Determine the relational model for your database using your UML diagram

Requirements

Prerequisites: If you want to learn about databases, follow part 1 of the Apply a Domain-Driven Design Approach to Development course. This will provide you with the basic logical and analytical approach needed for data modeling.

Contributors

Instructors

Nicolas Rangeon

Nicolas Rangeon, Data scientist, instructor & Computer engineer (Université de Technologie de Compiègne)

Kurt Schuepfer

PhD from Miami University. Data Scientist. Founder and Chief Strategist at Accelerate Data Academy.

Created by

OpenClassrooms

Last updated: 1/23/2025

License

Développement

Model a Database With UML

DifficultyMedium8 hours
Free-access course