Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
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) 159 reviews

1,286 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

26,111

Learners

1,436

Reviews

582

Answers

4.9

Rating

15

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

159 reviews

4.9

159 reviews

  • 아무도_모를_아이디님의 프로필 이미지
    아무도_모를_아이디

    Reviews 43

    Average Rating 4.8

    5

    49% enrolled

    제가 2년만 더 빨리 접했다라면,,, 현업에서 운영을 오래 하다보니 작은 모듈 단위의 기능은 그럭저럭 했습니다만 시스템 DB 전체를 설계할 때는 느낌으로 하다보니 확신이 없더라고요. 그래서 코딩을 할 때도 비지니스나 데이터 구조가 이게 맞나 시스템에 데이터가 정합한가 고민이 많았고 그 당시에도 설계 관련 책, 동영상 강의를 2개 이상 봤는데 이론에 대해선 알겠지만 막상 설계할 때는 시작이 잘 안되더라고요. 결국 다른 분께 설계를 넘겼습니다만 크게 다르진 않더라고요. DB설계가 약할 경우 서비스 자체가 불안정할 수 있다는 경험을 했습니다. 지금 40% 정도 수강했는데 마저 듣고나면 저 정말 잘 할 수 있을 것 같아요. 완전 쪽집게 과외네요. 다른 과목도 수강신청 해보겠습니다...

    • JSCODE 박재성
      Instructor

      아무도_모를_아이디님~ 현업 실무자시군요! 비록 2년이 흘렀지만 앞으로의 시간은 더 창창하니깐요! 이제서라도 자신감을 얻으신 점에 대해 무한 칭찬드리고 싶습니다 ㅎㅎ! 쪽집게라고 극찬해주셔서 너무 감사드립니다! 다른 과목까지 수강하셔서 더더욱 발전된 모습으로 찾아뵐 수 있길 응원하겠습니다~!

  • 수박님의 프로필 이미지
    수박

    Reviews 24

    Average Rating 5.0

    5

    100% enrolled

    선생님의 mysql 강의에 이어 DB설계 강의까지 들었습니다. 강의 시간 대비 학습효과가 뛰어나고 어려운 용어나 개념없이 너무 쉽게 설명해주셔서 이게 이렇게 쉬운 내용이었나 싶을 정도로 쉽게 설명해주셔서 감사합니다. 비전공자, 전공자 구분 없이 도움이 되는 강의 입니다. 잘할때까지 선생님께서 알려주신대로 6가지 규칙으로 실습해보겠습니다!!!

    • 수민님~ 수강평 남겨주셔서 너무 감사드려요! 오픈한 지 얼마 되지 않았는데 벌써 완강하셨다니 넘 축하드립니다 👍 알려드린 6가지 규칙들을 꼭 자신의 것으로 만들어서 응용해보시길 바랍니다 :)

  • technocratist님의 프로필 이미지
    technocratist

    Reviews 14

    Average Rating 5.0

    5

    91% enrolled

    DB 설계시 필수적으로 행해야 하는 부분들을 순차적으로 쉽게 알려주십니다. 만약 DB 설계가 처음이라면 이 강의를 먼저 이수하고, 좀 더 이론적으로 디테일한 부분을 공부하는게 효율적인 학습법이라 생각되네요. 급하게 DB 설계를 공부해야 할 일이 생겨서 빠르고 효율적으로 실무에 바로 적용 가능한 강의를 찾던중 딱 맞는 강의를 찾아 일을 마무리했습니다 감사합니다.

    • technocratist님 수강후기 너무 감사드립니다~! 남은 강의도 꾸준히 수강하셔서 완강까지 해내시길 응원하겠습니다 :)

  • 당황한 노새님의 프로필 이미지
    당황한 노새

    Reviews 13

    Average Rating 5.0

    5

    95% enrolled

    지나가던 FE입니다.. 최근에 백엔드쪽도 공부하고 찍먹중인데 (라고쓰고 1년 넘게 핥짝 거리는 중)... 관련 강의 구매도 꽤 했는데 가장 좋았고, 효율적인 강의 방식이었다고 생각합니다.

    • 당황한 노새님~ 들으신 강의 중에 가장 좋았다니 극찬을 해주셔서 너무 감사드려요 ㅠㅠ! 앞으로 더 효율적인 강의를 보여드려야겠다는 마음이 더 생깁니다. 좋은 평가 넘 감사드려요 :)

  • suuupanov님의 프로필 이미지
    suuupanov

    Reviews 7

    Average Rating 5.0

    5

    98% enrolled

    시간 가는 줄 모르고 듣다 보니까 다 들었어요~ ㅋㅋㅋ 정말 쉽게 알려주시고 비록 인터넷 강의지만 어려울 수 있는 부분들을 반복적으로 알려주셔서 이해가 잘 된 것 같습니다. 혼자서 실습해서 마무리 잘하겠습니다~! 감사합니다!

    • suuupanov님~ 시간 가는 줄 모르고 들으셨다니 넘 기쁘고 뿌듯하네요~! 혼자서도 잘 해내실 수 있으실 거라 생각이 듭니다! 좋은 수강평 감사드립니다 완강 축하드려요 :)

$51.70

jscode's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!