inflearn logo
inflearn logo

Introduction and Practice of DB Design for Non-Majors

I have created a 'DB Design: Introduction & Practice' course that is easy for non-majors to understand and can be applied immediately in the real world!

(4.9) 205 reviews

1,491 learners

Level Beginner

Course period Unlimited

DBMS/RDBMS
DBMS/RDBMS
database
database
MySQL
MySQL
dba
dba
DBMS/RDBMS
DBMS/RDBMS
database
database
MySQL
MySQL
dba
dba

Reviews from Early Learners

Reviews from Early Learners

4.9

5.0

HanKyul Kim

64% enrolled

I believe this is the highest quality lecture for DB design beginners, regardless of whether you're a major or non-major. I can say with certainty that as someone who has experience solving concurrency and transaction issues in practice, you could listen to just this one lecture and move straight to advanced topics.

5.0

선진

100% enrolled

Each lecture was short, and I was able to concentrate and listen well because it only taught the key points. I'm so touched that even I, who can't finish the course every time, was able to finish it in 3 days.. DB design has always felt like an ambiguous area, but this lecture scratched the itchy parts exactly. Thank you for teaching so easily. I'll practice a lot on my own while listening to the lecture!!!!! (P.S. If you release beginner, intermediate, and advanced lectures, I definitely want to take them!!!!..!)

5.0

yeonjin1939

98% enrolled

First, like other classes, the instructor explains things in an easy-to-understand way. When I listen and think a little bit outside the box, thinking, ‘So, is it like this?’ the instructor points out that part as well, which I thought was a delicate class. I was especially impressed by the requirements expressed in writing and the UI-based requirements materials. Since there were reference materials, I was more motivated to try it out myself and was able to concentrate better. When I designed a database myself based on the requirements, it took a long time at first, but as I continued the next practice, I saw myself getting better and better, so I studied really happily. As the instructor said at the end, I think I can try more practices myself by referring to other services and the erd site. If I have any questions while trying it out, I will leave them. Thank you for the great class!

What you will gain after the course

  • 6 Magic DB Design Rules You Can Apply Without Knowing Complex Concepts

  • How professional developers design databases

  • Core Principles and the Entire Process of DB Design


🤬 Dammit, I can't do this anymore!

My name is Jaeseong Park, and I started my career in development as a non-major, served as a CTO at several companies, and am currently active as an educator. I also had a time when I started development as a non-major and studied DB design.

I bought several books to study DB design. The books were filled with difficult terms and concepts like conceptual design, logical design, anomalies, normalization, and transitive functional dependency. It was hard to understand at first, but I didn't give up and worked hard until I understood all those concepts. However, when I actually tried to design a database for a project, I couldn't even get started. That's when I realized:

"I only learned DB design theories that I can't even apply in practice..."

I realized there is a huge gap between theory and actual DB design methods. Since I once struggled with these same difficulties, I thought, "I should create a DB design course that even non-majors can fully apply in practice."

In this course, I will show you how working developers actually design databases. If you just follow the methods I teach, you will be able to design as accurately as a professional developer without needing to know unnecessary and difficult theories.

✨ 4 Key Points I Focused on While Creating This Course

I believed that if you cannot apply what you've learned in practice even after finishing the course, it is a flawed course. I tried to structure it as a practical course that can be applied immediately in the field, rather than an academic approach of studying theory in depth.

I have selected only the core concepts strictly necessary for DB design to teach you. Knowing just a few frequently used concepts is enough to design a database. I won't teach you any useless concepts. By learning this way, you can learn very quickly and apply it immediately in practice.

I won't just explain the theory; I will show you the entire DB design process step-by-step using sample projects. By demonstrating the design process, you can easily learn what steps are taken to design a database in a real-world setting.

Once you have learned the concepts, you need to apply them to actual DB design. Therefore, I have prepared 4 projects so that you can practice in a way that most closely resembles real-world work.

👍 This course is perfect for people like this!

Those who are having
difficulty learning DB design
by watching YouTube or blogs

Those who are non-majors and
slow to understand difficult
concepts and terminology

Those who want to
design a DB on their own
for a project

🙊 What will you achieve after completing this course?

You will be able to design a database from scratch on your own for an actual project. You will learn the same methods professional developers use to design databases, rather than just learning for academic purposes.

🍡 Preview

'[Practice] Designing a DB based on the Screen UI Design - JSCODE Todo List' From the class


'[Practice] Designing a DB based on requirements - JSCODE Community (2)' during class


'Identifying Data to Store / Classifying by Grouping' during the lesson

Notes

If there are any parts you don't understand while studying, please ask right away using the Q&A board or the 1:1 open chat room😊 I try to respond within 24 hours whenever possible!

🚨 Be sure to check what kind of person the educator is!

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

Due to wrong education, you may end up at a company you don't want, receive a smaller salary than expected, and live in pain for the rest of your life because of it. Not only that, but the wrong education you received can even be passed down to your children.

I believe that education can truly change a person's life for the better, but on the other hand, it can also completely ruin a person's life. That is why I believe education carries such a heavy responsibility.

Therefore, please check who the educator is, what kind of person they are, and what path they have taken, and make a careful judgment.

👋 Hello!
I'm finally introducing myself ( ⸝⸝•ᴗ•⸝⸝ )੭⁾⁾

Hello!

I started studying development as a non-major. Somehow, I've already become a developer in my 6th year! Recently, I served as CTO at two companies while working as a developer. Whenever I had spare time, I've been conducting coding lectures, corporate development consulting, and speaking engagements.. Bất cứ khi nào có thời gian rảnh, tôi đều thực hiện các bài giảng lập trình, tư vấn phát triển cho công ty và diễn thuyết.

The number of students I have taught has already exceeded 24,000 (as of July '25)! As I feel every time I teach my students, I can never forget the sense of fulfillment that comes from education, so I plan to continue providing courses on Inflearn.
(* Produced successful candidates for Kakao Pay, Yanolja, and Woowa Bros among students)

Just as I received a lot of help when I was going through difficult and challenging times, I wanted to become someone who could also help many others. Furthermore, I felt the most proud and happy when the value I created through development had a positive impact on other people.

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

Thank you!

🏆 Course Best Review

** This is a review written for the previously created .


🚌 Feeling lost about which order to take the courses in?

'[2026] Essential Curriculum for Getting a Job as a Backend Developer (IT Service Companies)' Please refer to this!!

Recommended for
these people

Who is this course right for?

  • Those who are learning DB design for the first time

  • Those who find it difficult to apply normalization concepts in practice

  • Those who want to learn DB design methods frequently used by working developers

  • Those who want to design a database by themselves from start to finish

Need to know before starting?

  • Basic SQL statements

Hello
This is jscode

31,221

Learners

2,295

Reviews

759

Answers

4.9

Rating

19

Courses

[Sites] Shortcut to YouTube, Shortcut to LinkedIn [Career] Current) JSCODE - Lead Mentor, CEO / Former) Tripod Lab Co., Ltd. - CTO / Former) Only One Universe Co., Ltd. - CTO / Former) DALY - CTO / Former) Teammate

[Sites]
Go to Youtube
Go to LinkedIn

[Career] Current) JSCODE - Lead Mentor, CEO Former) Tripod Lab Co., Ltd. - CTO Former) Only One Universe Co., Ltd. - CTO Former) DALY - CTO Former) Teammate - CEO [Books] 『Do it! JSCODE's AWS

[Career]
Present) JSCODE - Lead Mentor, CEO
Former) Tripod Lab Co., Ltd. - CTO
Former) Only One Universe Co., Ltd. - CTO
Former) DALY - CTO
Former) Teammate - CEO

[Books]

『Do it! JSCODE's Introduction to AWS』, EasysPublishing (2025.05)

[ETC]
- Corporate development consulting and coding education activities

More

Co-instructor

Curriculum

All

45 lectures ∙ (5hr 1min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

205 reviews

4.9

205 reviews

  • 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 :)

  • 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~!

  • 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 :)

  • parksoopark님의 프로필 이미지
    parksoopark

    Reviews 34

    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 :)

jscode's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal ends in 5 days

$53,900.00

30%

$59.40