Introduction to DB Design for Non-Majors: From Basics to Practice

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) 213 reviews

1,523 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 Magical 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 pushed through 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 that there's a huge difference between theory and how to actually design a database. Since I also went through those difficult times, I thought I should create a DB design course that even non-majors can fully apply in real-world situations.

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 a course, then it is a flawed course. I tried to structure it as a practical course that can be applied immediately to real-world tasks, rather than an academic approach of studying theory deeply.

I will teach you by selecting only the core concepts essential for DB design. Knowing just a few frequently used concepts is enough to design a database. I won't teach you unnecessary concepts. By learning this way, you can learn very quickly and apply it to real-world practice immediately.

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 actually 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. That's why I have prepared 4 projects so 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 from a non-major background and
are slow to understand difficult
concepts and terminology

Those who want to try
designing a DB on their own
in a project

🙊 What will you achieve after completing this course?

You will be able to design a DB from scratch by yourself in a real project. You can learn the way actual professional developers design databases, rather than just for simple learning purposes.. Bạn sẽ được học theo cách mà các nhà phát triển thực thụ thiết kế DB trong công việc thực tế, chứ không chỉ đơn thuần là để học tập.

🍡 Preview

'[Practice] Designing a DB by looking at the screen UI - JSCODE Todo List' during class


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


During the 'Identifying Data to Store / Classifying by Grouping' class

Notes

If you encounter any parts you don't understand while studying, please ask questions immediately 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 poor education, you may end up at a company you don't want, receive a lower salary than expected, and suffer for the rest of your life as a result. Not only that, but the poor education you received can even be passed down to your children.

I believe that education can change a person's life in a truly positive way, 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 decision.

👋 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've taught has already exceeded 24,000 (as of July 2025)! As I feel every time I teach my many students, I can never forget the sense of fulfillment that comes from education, so I plan to continue providing education here on Inflearn.
(* Produced successful applicants 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 produced <AWS Introduction/Practice for Non-Majors>.


🚌 Feeling overwhelmed 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 widely used by professional 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

32,982

Learners

2,500

Reviews

788

Answers

4.9

Rating

20

Courses

 

[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 Introduction to AWS』, Easys Publishing (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

213 reviews

4.9

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

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

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

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

jscode's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

$59.40