Inflearn brand logo image
Inflearn brand logo image

N

Inflearn brand logo image
Programming

/

Database

Let's draw a data map ERD, MySQL workbench

Learn how to draw an ERD and convert it to a database and tables using MySQL Workbench.

(5.0) 5 reviews

97 learners

  • swa
3시간 만에 완강할 수 있는 강의 ⏰
ERD
데이터베이스
mysql
workbench
mysql-workbench

Reviews from Early Learners

What you will learn!

  • Basic knowledge and examples for drawing ER models using a workbench

  • Detailed usage of I/E notation and modeling tools provided by Workbench

  • Forward Engineer feature to create tables from models

  • Deploying a model with data

Drawing an ERD with Workbench
Closer to practice! 🐬

MySQL Workbench?

MySQL Workbench is an application that has the ability to create ERDs that define tables and relationships between tables in a database. It is used in the database design phase when implementing user services and defines sets of data (tables) and relationships between them (foreign keys).

Lecture Topics 📖

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

In this analysis/design stage, one of the tools that allows you to view data from the perspective of sets and relationships is ERD, and I would like to introduce Workbench, an ER modeling tool provided by MySQL. In this lecture, I will provide you with the general knowledge and information required for the process of drawing an ERD based on MySQL and creating a physical table .

Expand your horizons to other fields by applying data sets, relationships, etc. through lectures. You will be able to communicate with colleagues or customers through ERDs with sufficient design time. Also, you will be able to predict and prepare countermeasures in advance even if data occurs in exceptional situations or there are errors in field data.

Have you ever thought about this?

🥲 I thought the design was complete, but I keep getting requests for changes.

🧐 The data of the service I run is frequently modified. I don't know where to start looking for the cause.

🥺 I'm trying to get started in the data field, but I don't know what to study first.

Join MySQL Workbench!

  • The process of drawing an ERD with a workbench emphasizes the importance of ‘data sets’ and ‘relationships’ rather than data.
  • Let's draw ERD more easily by following basic examples and systematic procedures.
  • We provide an environment that allows easy transition to practical use by selecting a MySQL database with a large user base.
  • Explore the relationships between different data sets through one practical service ERD and six case-by-case examples .

📢 Please make sure to check!

  • All videos of the course are available for free on YouTube ("SQL Bank"). (After April 24th)

  • If you watch on Inflearn, you will receive an ad-free environment + lecture files with available sources + practice scripts, etc. Please keep this in mind when purchasing a course.

I recommend this to these people 🙋

Anyone who needs to draw and implement ERD using MySQL Workbench

Students who want to learn ERD concepts and databases together

Those who dream of a new challenge using IT and data as a stepping stone

Lecture Features ✨

Theory and practice
Composed of 5:5 ratio

In mind map format
Use of lesson materials

Easy to apply in practice
MySQL Select

What you'll learn 📚

It consists of a total of six lectures and explains in detail the ER modeling functions provided by MySQL Workbench as shown in the figure.

The simplest is to create two entities, emp employee: dept department, and draw a relationship line between them.

At this time, define the relationship in detail by defining 1) Referencing and Referenced, 2) Cardinality, and 3) Identifying Relationship through the relationship line details window. Draw it step by step according to the systematic order provided in the figure below.

We will look at the screen design of the 'Pet Diary' app system (written with Daum Kakao UI/UX tool OVEN Oven) and the ERD written with MySQL Workbench.

We will also take a closer look at the models divided into six other cases.

📢 Please check before taking the class!

  • The lecture volume may feel low. Please check the volume by previewing the lecture before registering for the course.
  • Practice environment
    • Windows environment, minimum 4G memory/recommended 6G memory
  • Learning Materials
    • See PDF and workbench sample files provided for each course

Expected Questions Q&A 💬

Q. Why should I learn?

Because you can view and read the ERD, the data design diagram that forms the basis of the system.

Q. What can I do after learning it?

You can make better use of your time communicating with customers and easily identify gaps or exceptions in data.

Q. Is this a lecture that non-majors can also take?

If you want to work in data, you absolutely must know this.

Q. Is there anything I need to prepare before attending the lecture?

Basic knowledge of databases and ERD is required.

Q. What level of content is covered in the class?

We will take a closer look at the ER modeling feature of MySQL Workbench. We will cover ERD examples written as simply as possible.

Q. Are there any notes regarding taking the course (environment required, other things to keep in mind, etc.)?

For additional information that is not covered due to space limitations (error resolution, troubleshooting, etc.), please refer to my personal YouTube channel (Software Notification Center).

Recommended for
these people

Who is this course right for?

  • Those who need to draw and implement ERD using MySQL workbench

  • Students who want to learn about ERD concepts and databases together

  • Those who dream of new challenges using IT and data as a stepping stone

Need to know before starting?

  • Concepts of Database and ERD

  • Between MySQL beginner and intermediate

Hello
This is

2,605

Learners

64

Reviews

27

Answers

4.8

Rating

10

Courses

안녕하세요 『소프트웨어알림장』입니다. 데이터베이스 및 미들웨어 애플리케이션 개발, 응용 분야의 경험을 쌓아왔으며 MySQL과 MariaDB를 바탕으로 SQL을 활용한 강좌들을 제작하고 있습니다. 유튜브 채널 "SQL뱅크" 를 운영하고 있습니다.

Hello, this is "SQL BANK". I have accumulated experience in developing database and middleware applications and in various application fields. I create tutorials utilizing SQL based on MySQL and MariaDB. I also run a YouTube channel called "SQL BANK".

Curriculum

All

13 lectures ∙ (2hr 15min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

5.0

5 reviews

  • transmission님의 프로필 이미지
    transmission

    Reviews 27

    ∙

    Average Rating 5.0

    5

    100% enrolled

    If you want to know ERD, this seems like a good course. It briefly explains how to use the workbench with examples. I think it would be good if you think of it as a beginner level course.

    • jang2jg2958님의 프로필 이미지
      jang2jg2958

      Reviews 23

      ∙

      Average Rating 5.0

      5

      100% enrolled

      • a5001525796님의 프로필 이미지
        a5001525796

        Reviews 1

        ∙

        Average Rating 5.0

        5

        100% enrolled

        It was a useful lecture

        • swa
          Instructor

          Thank you, Itaegon.

      • pink321ryu님의 프로필 이미지
        pink321ryu

        Reviews 21

        ∙

        Average Rating 5.0

        5

        100% enrolled

        Thank you for your hard work. These are the contents I really wanted to hear. The view part in DB is something I've never seen before, so I'll have to look it up later. I'm trying to implement a web app, but there aren't many lectures on DB design, so it's not easy to do it alone. Is there anything else I should listen to?

        • swa
          Instructor

          I'm glad it was helpful. Thank you for your hard work studying. I also appreciate it. You're trying to implement a web app, and you're doing it alone. It's not easy, but I think it's a big challenge. If I talk about DB, I think design, implementation, and the test data environment that is the target during development are important. When developing, creating 'plausible' development data is also a very important part, and the more diverse the development data that can be tested, the less additional modifications and supplements will occur in the business logic part such as HTML, Java, and Node.js later. Likewise, when developing by team, the integration test or deadline schedule is significantly affected depending on how many sufficient and diverse cases (expected user input format, data consistency check upon input, appropriateness of time or date, etc.) are included in the development data. Please visit my YouTube channel or Infraon, where related courses are registered, so it would be good to refer to them. I'll leave the URL below. https://www.youtube.com/playlist?list=PL_RECGqDS3icOhnWgOTFF5-CBto3OXj4l Thank you for asking many questions and cross-checking, which is not easy for a student.

      • ws06018158님의 프로필 이미지
        ws06018158

        Reviews 8

        ∙

        Average Rating 4.3

        5

        100% enrolled

        I felt that the lecture pace was appropriate and the lecture materials were sufficient. I think it covers almost everything that juniors need to know to read and write ERD.

        $26.40

        swa's other courses

        Check out other courses by the instructor!

        Freeplane for presenters강의 썸네일

        Freeplane for presenters

        swa

        If you are good at using mind maps, try expanding the areas of application. It can be used in various fields such as presentation materials, weekly reports, chronological timelines, agile scrum and to-do lists, storyboards, etc.

        초급

        초급

        presentation PT, Freeplane, mindmap

        Freeplane for presenters강의 썸네일

        Freeplane for presenters

        swa

        SQL Survival Kit for Data Beginners강의 썸네일

        SQL Survival Kit for Data Beginners

        swa

        Through a hands-on curriculum using MariaDB and HeidiSQL, you can learn the core concepts of SQL and how to use it in practice while collecting, preprocessing, and analyzing data.

        초급

        초급

        MariaDB, MySQL, SQL

        SQL Survival Kit for Data Beginners강의 썸네일

        SQL Survival Kit for Data Beginners

        swa

        Creating a Remote Development Environment Using VS Code강의 썸네일

        Creating a Remote Development Environment Using VS Code

        swa

        We will create a remote development environment using VS Code and extensions, and learn about WSL and code-server, a VS Code used on the web.

        초급

        초급

        wsl, VSCode, code-server

        Creating a Remote Development Environment Using VS Code강의 썸네일

        Creating a Remote Development Environment Using VS Code

        swa

        SQL Query Book to Find and Use When You Need It, Part I강의 썸네일

        SQL Query Book to Find and Use When You Need It, Part I

        swa

        Sometimes, data processing is blocked and frustrating. If you are not a professional programmer or developer, learning unfamiliar fields such as Python or Java is not easy and there is not enough time. This is for those who only know Excel and SQL basics when it comes to frequently used things. This is the first part of the SQL query book that you can find and use when you need it.

        초급

        초급

        SQL, MariaDB, HeidiSQL

        SQL Query Book to Find and Use When You Need It, Part I강의 썸네일

        SQL Query Book to Find and Use When You Need It, Part I

        swa

        MariaDB client development, internal functions강의 썸네일

        MariaDB client development, internal functions

        swa

        We will look at usage and examples of the 108 main internal functions provided by MariaDB using the HeidiSQL development tool.

        초급

        초급

        MariaDB

        MariaDB client development, internal functions강의 썸네일

        MariaDB client development, internal functions

        swa

        A more convenient Windows file manager, Total Commander!강의 썸네일

        A more convenient Windows file manager, Total Commander!

        swa

        We will study Total Commander, which allows you to manage folders and files in Windows more conveniently.

        입문

        입문

        total-commander, Microsoft Windows

        A more convenient Windows file manager, Total Commander!강의 썸네일

        A more convenient Windows file manager, Total Commander!

        swa

        Creating a table using public data CSV file강의 썸네일

        Creating a table using public data CSV file

        swa

        Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

        중급이상

        중급이상

        SQL, HeidiSQL, MariaDB

        Creating a table using public data CSV file강의 썸네일

        Creating a table using public data CSV file

        swa

        Organize your thoughts, mind maps and Freeplane!강의 썸네일

        Organize your thoughts, mind maps and Freeplane!

        swa

        For those of you who often forget how far you've thought and organized, here's how to create and use a mind map using Freeplane!

        입문

        입문

        Freeplane

        Organize your thoughts, mind maps and Freeplane!강의 썸네일

        Organize your thoughts, mind maps and Freeplane!

        swa

        MariaDB client development, HeidiSQL강의 썸네일

        MariaDB client development, HeidiSQL

        swa

        Learn how to write SQL queries and work with databases using the MariaDB client development tool HeidiSQL.

        중급이상

        중급이상

        SQL, MariaDB, HeidiSQL

        MariaDB client development, HeidiSQL강의 썸네일

        MariaDB client development, HeidiSQL

        swa

        Similar courses

        Explore other courses in the same field!

        [7-day completion] Thinking database modeling강의 썸네일

        [7-day completion] Thinking database modeling

        bitcocom

        [TPC DB!] A course that allows you to learn database modeling while thinking, learn database modeling step by step, and master everything from database modeling to web programming implementation all at once.

        초급

        초급

        DBMS/RDBMS, SQL, ERD

        [7-day completion] Thinking database modeling강의 썸네일

        [7-day completion] Thinking database modeling

        bitcocom

        Concepts and tuning methods considered when migrating 20 billion data to MySQL강의 썸네일

        Concepts and tuning methods considered when migrating 20 billion data to MySQL

        july

        We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

        초급

        초급

        MySQL, mysql-workbench, mysql-query

        Concepts and tuning methods considered when migrating 20 billion data to MySQL강의 썸네일

        Concepts and tuning methods considered when migrating 20 billion data to MySQL

        july

        Project Structure and Database Handling for Backend Employment [MySQL, Mongo]강의 썸네일

        Project Structure and Database Handling for Backend Employment [MySQL, Mongo]

        july

        This is a content about backend development using two databases, MySQL and Mongo, for job seekers preparing for backend employment.

        초급

        초급

        MySQL, MongoDB, ERD

        Project Structure and Database Handling for Backend Employment [MySQL, Mongo]강의 썸네일

        Project Structure and Database Handling for Backend Employment [MySQL, Mongo]

        july

        [Management Course #2] DBA (ERD, Database Design)강의 썸네일

        [Management Course #2] DBA (ERD, Database Design)

        vmproductor0202

        In this lecture, you will learn how to create an ERD. You will learn database design. (The only big data design lecture in Korea)

        초급

        초급

        Big Data, ERD, olap

        [Management Course #2] DBA (ERD, Database Design)강의 썸네일

        [Management Course #2] DBA (ERD, Database Design)

        vmproductor0202