강의

멘토링

로드맵

BEST
Programming

/

Database

DB Design Introduction/Practice That Even Non-Majors Can Understand

I've made a 'DB Design Introduction/Practice' lecture that's easy for non-majors to understand and immediately applicable in practice!

(4.9) 170 reviews

1,359 learners

  • jscode
이론 실습 모두
db설계
비전공자
DBMS/RDBMS
database
MySQL
dba

Reviews from Early Learners

What you will learn!

  • 6 Magical DB Design Rules Applicable Even Without Complex Concepts

  • How Working Developers Design DBs

  • DB Design Core Principles and Overall Process


🤬 Oh my, I can't eat this!

My name is Jaeseong Park , and I started out as a developer without a major, worked as a CTO at several companies, and am currently working as an educator. There was a time when I also started as a developer without a major and studied DB design.

I bought and studied related books to study DB design. The books contained many difficult terms and concepts, such as conceptual design, logical design, anomalies, normalization, and transitive functional dependency. It was difficult to understand at first, but I didn't give up and worked hard until I understood all of those concepts. However, when I actually tried to design a DB for a project, I couldn't move a finger. That's when I realized it.

"I only learned DB design theories that I can't even apply to real life..."

I realized that there was a huge difference between the theory and the actual DB design method. So, since I also had a time when I had such difficulties, I thought that I should create a DB design lecture that even non-majors could apply in practice.

In this lecture , I will teach you how developers in the field actually design databases. If you follow the method I teach you, you will be able to design accurately like a developer in the field without having to know unnecessary and difficult theories.

Four points I paid attention to while creating the lecture

I thought that if you can't apply what you've learned in class, then it's a bad class. I tried to structure the class so that it's practical and can be applied directly to the field, rather than an academic style that focuses on learning theories in depth .

I will teach you only the core concepts that are necessary when designing a DB . If you know only a few frequently used concepts, it is enough to design a DB. I will not teach you useless concepts. If you learn this way, you will learn really quickly and can apply it right away in the field.

Rather than just explaining the theory, I will show you the DB design process step by step using a sample project. By showing you the design process, you can easily learn what process goes into designing a DB in practice.

After learning the concepts, we need to actually design a DB using those concepts. So, I prepared four projects so that you can practice in a way that is most similar to the actual work .

👍 People like this will like it!

By watching YouTube or blogs
To learn DB design
For those who are having difficulties

Because I am not a major
Difficult concepts and terms
People who are slow to understand Korea

In the project
Design your own DB
Anyone who wants to try it

🙊 After listening to this lecture?

You will be able to design your own DB from start to finish in an actual project . You will learn in the way actual developers design DBs, not just for learning purposes.

🍡 Taste

'[Practice] Designing a DB by looking at the screen UI design - JSCODE To-do List' class


'[Practice] Designing a DB by looking at requirements - JSCODE Community (2)' class


In the class 'Identifying data to save / Classifying by grouping'

Note

If you come across any part you don't understand while studying, please use the Q&A board or 1:1 open chat room to ask questions right away 😊 We will try to answer within 24 hours if possible!

🚨 Be sure to check who is teaching you!

If you meet the wrong doctor, you may die at that moment because you cannot cure your illness. However, death ends with the pain of that moment. However, if you meet the wrong teacher and receive the wrong education, you will suffer throughout your life.

Due to wrong education, you may end up going to a company you don't want to work for, receiving a salary that is lower than you expected, and living a life of suffering because of it. Not only that, but because of the wrong education, your children will also inherit the wrong education.

I think that education can really change a person's life in a positive way, but on the other hand, it can also completely destroy a person's life. I think that's why education is such a heavy responsibility.

Therefore, please check who the person teaching you is, what kind of person they are, and what path they have taken, and then make a careful decision.

👋 Hello!
Now I introduce myself ( ⸝⸝•ᴗ•⸝⸝ )੭⁾⁾

hello!

I started studying development as a non-major . I have already been a developer for 6 years! Recently, I have been working as a developer while serving as CTO at two companies . Whenever I have free time, I have been giving coding lectures, consulting on company development, and giving lectures.

The number of students I have taught so far has already exceeded 24,000 (as of July 25th) ! I feel this every time I teach many students, but I cannot forget the sense of pride I feel in education, so I will continue to provide education at Inflearn.
(* Among the students, there are those who passed the exams at Kakao Pay, Yanolja, and Woowa Brothers)

Just as I have received a lot of help when I was going through hard times, I wanted to become someone who could help many other people. And I feel most proud and happy when the value I created through development has had a positive impact on others.

For these reasons , I hope that by sharing what I have worked hard to obtain, I can help those people live a slightly better life.

thank you!

🏆 Best Reviews of Lectures

** This is a review written for the previously produced <AWS Introduction/Practice that Non-Majors Can Understand>.


🚌 What if you don’t know what order to take the lectures in?

Please refer to ' [2025] Essential Curriculum for Employment as a Backend Developer (IT Service Company) ' !

Recommended for
these people

Who is this course right for?

  • For those learning DB design for the first time

  • Those who find it difficult to apply Normal Form concepts in practice

  • Learn DB design used by active developers.

  • Those who want to design their own DB from start to finish

Need to know before starting?

  • Basic SQL statements

Hello
This is

27,685

Learners

1,699

Reviews

642

Answers

4.9

Rating

16

Courses

 

[Sites]
Youtube 바로가기
LinkedIn 바로가기

 

[Career]
現) JSCODE - 대표 멘토, CEO
前) (주)트라이포드랩 - CTO
前) (주)온리원유니버스 - CTO
前) 달리(DALY) - CTO
前) 팀메이트(Teammate) - CEO

 

[Books]

『Do it! JSCODE의 AWS 입문』, 이지스퍼블리싱 (2025.05)

 

[ETC]
- 기업 대상 개발 컨설팅 및 코딩 교육 활동

Curriculum

All

44 lectures ∙ (5hr 1min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

170 reviews

4.9

170 reviews

  • whybwhy3576님의 프로필 이미지
    whybwhy3576

    Reviews 45

    Average Rating 4.8

    5

    49% enrolled

    If I had been exposed to it 2 years earlier,,, Since I have been operating in the field for a long time, I was able to do the functions of small modules, but when designing the entire system DB, I was not sure because I did it by feeling. So when I was coding, I had a lot of concerns about whether the business or data structure was right or whether the data was aligned with the system. At that time, I watched more than 2 design-related books and video lectures, but I knew the theory, but when it came to designing, I had a hard time getting started. In the end, I handed over the design to someone else, but it wasn't much different. I experienced that if the DB design is weak, the service itself can be unstable. I've taken about 40% of the course, but I think I can do really well after I finish it. It's really a one-on-one tutoring. I'll try to sign up for other courses...

    • jscode
      Instructor

      Nobody_Knows_ID~ You're a professional in the field! Although two years have passed, the future will be brighter! I want to give you endless praise for gaining confidence even now. Haha! Thank you so much for praising me as a person with great skills! I hope you will take other classes and come back with an even more developed appearance~!

  • parksoopark님의 프로필 이미지
    parksoopark

    Reviews 27

    Average Rating 5.0

    5

    100% enrolled

    I took the teacher's MySQL lecture and then the DB design lecture. The learning effect is excellent compared to the lecture time, and it is explained so easily without difficult terms or concepts that it makes me wonder if it was this easy. Thank you for explaining it so easily. This lecture is helpful for both non-majors and majors. I will practice with the 6 rules as the teacher taught me until I get good at it!!!

    • jscode
      Instructor

      Sumin-nim~ Thank you so much for leaving a review! Congratulations on completing the course even though it hasn't been open for long 👍 I hope you make the 6 rules I taught you your own and apply them :)

  • technocratist666님의 프로필 이미지
    technocratist666

    Reviews 14

    Average Rating 5.0

    5

    91% enrolled

    It explains the essential parts of DB design in an easy and sequential manner. If you are new to DB design, I think it would be an efficient way to learn to complete this course first and study more theoretical and detailed parts. I had to study DB design urgently, so I was looking for a course that could be applied quickly and efficiently to my work, and I found the perfect course and finished it. Thank you.

    • jscode
      Instructor

      Thank you so much for your review, technocratist! I hope you continue to take the remaining lectures and complete them :)

  • trantper님의 프로필 이미지
    trantper

    Reviews 13

    Average Rating 5.0

    5

    95% enrolled

    This is a passing FE.. I've been studying and learning about backend recently (I've been studying it for over a year)... I've purchased quite a few related lectures, and I think this was the best and most efficient lecture method.

    • jscode
      Instructor

      Embarrassed Mule~ Thank you so much for praising me and saying that it was the best lecture you've ever heard ㅠㅠ! It makes me want to show you more efficient lectures in the future. Thank you so much for the good evaluation :)

  • suuupanov님의 프로필 이미지
    suuupanov

    Reviews 7

    Average Rating 5.0

    5

    98% enrolled

    Before I knew it, I had listened to everything~ ㅋㅋㅋ You explained it really easily, and although it was an online lecture, you repeatedly explained the parts that could be difficult, so I think I understood it well. I will practice on my own and finish it well~! Thank you!

    • jscode
      Instructor

      suuupanov~ I'm so happy and proud that you listened without realizing the time passing~! I think you can do well on your own! Thank you for the good review. Congratulations on completing the course :)

$51.70

jscode's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!