Let's draw a data map ERD, MySQL workbench

Drawing ERDs with Workbench
Getting closer to real-world practice! 🐬

Lecture Topic 📖

The data field should be approached from the perspective of 'sets' and 'relationships'. It is often said that 'the data field is something you only become interested in after experiencing several failures through projects such as building external systems'. This also means that the data analysis/design stage related to initial work is that important.

One of the tools that helps us view data from the perspective of sets and relationships during these analysis/design phases is ERD, and I happened to discover Workbench, an ER modeling tool provided by MySQL, which I'd like to introduce. In this course, we will teach you the overall knowledge and information needed for the process of drawing ERDs based on MySQL and then creating physical tables.

Broaden your perspective on other fields by applying data sets and relationships through the course. You'll be able to communicate with colleagues or clients through ERDs with sufficient design time. Additionally, you'll be able to predict and prepare countermeasures in advance even when data occurs in exceptional situations or there are errors in field data.

Join us with MySQL Workbench!

• Through the process of drawing ERDs with Workbench, we emphasize the importance of 'data sets' and 'relationships' rather than just data.
• Draw ERDs more easily with basic examples and systematic steps.
• We chose MySQL database, which has a large user base, to provide an environment where you can easily transition to practical work.
• You can explore the relationships between various data sets through one practical service ERD and six case-specific examples.

📢 Please make sure to check!

• Some videos from the course can be watched for free on Youtube ("SQL Bank"). (After November 2025)

• If you watch on Inflearn, you'll get an ad-free environment + course materials with usable source code + practice scripts, etc. Please keep this in mind when purchasing the course.

Recommended for these people 🙋

Someone who needs to draw and implement an ERD using MySQL Workbench

A student who wants to learn ERD concepts and databases together

Those who dream of new challenges using IT and data fields as stepping stones

Course Features ✨

Learning Content 📚

It consists of a total of six lectures and provides detailed explanations of the ER modeling features provided by MySQL Workbench, as shown in the diagram.

Create the simplest emp employee : dept department entities respectively and draw the relationship line between them.

At this time, through the relationship line's detailed information window, you define the relationship in detail by defining 1) the Referencing side and the Referenced side, 2) Cardinality, and 3) Identifying Relationship. You draw step by step according to the systematic order provided in the figure below.

We will examine the screen design of the 'Pet Diary' app system (created with Kakao's UI/UX tool OVEN) and the ERD created with MySQL Workbench.

We also examine in detail the models divided into six other cases.

Expected Questions Q&A 💬