강의

멘토링

커뮤니티

BEST
Programming

/

Database

Database Design Introduction/Practice for Non-Majors

I've created a 'DB Design Beginner/Practical' course that even non-majors can easily understand and apply directly in real-world situations!

(4.9) 204 reviews

1,486 learners

Level Beginner

Course period Unlimited

  • jscode
  • JSCODE
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 developers in the field design databases

  • DB Design Core Principles and Overall Process


🤬 Ugh, I can't do this anymore!

I started as a non-major in development, worked as CTO at several companies, and am currently working as an educator. My name is Park Jaesung. I also started development as a non-major and had a time when I was studying DB design.

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

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

I realized that there's a huge difference between theory and the actual method of designing 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'll show you how developers in the field actually design databases. If you just follow the methods I teach you, you'll be able to design accurately like a professional developer without needing to know unnecessary and difficult theory..

✨ 4 Points I Focused on While Creating This Course

I thought it would be a bad course if you couldn't apply it in practice even after finishing the entire course. I tried to structure it as a practical course that can be immediately applied to real work, rather than an academic approach that deeply studies theory.

We've carefully selected only the essential core concepts you need for DB design to teach you. Just knowing a few frequently used concepts is enough to design databases. We won't teach you unnecessary concepts. By learning this way, you can learn really quickly and apply it directly in real-world situations.

I won't just explain theory, I'll show you every step of the DB design process using sample projects. By showing you the design process, you can easily learn what steps to follow when designing a DB in real-world situations.

Once you've learned the concepts, we need to actually design a DB using those concepts. So I've prepared 4 projects that allow you to practice in a way most similar to real-world work.

👍 This course is great for:

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

Those who come from a non-technical background
and are slower to understand
difficult concepts and terminology

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

🙊 What will you gain after completing this course?

You will be able to design databases from start to finish on your own in real projects. You can learn not just for study purposes, but in the way actual working developers design databases.

🍡 Preview

'[Practice] Designing a DB Based on Screen UI Design - JSCODE To-Do List' lesson


'[Practice] Designing a DB Based on Requirements - JSCODE Community (2)' lesson


During the 'Identifying Data to Store / Grouping and Categorizing' lesson

Reference Notes

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

🚨 Make sure to check who is providing the education!

If you meet the wrong doctor, you could die from not being able to cure your illness at that moment. However, death ends with that moment's suffering. But if you meet the wrong teacher and receive poor education, you will suffer throughout your entire life.

Due to wrong education, you may end up at an unwanted company, receive a smaller salary than expected, and suffer for the rest of your life because of it. Not only that, but the wrong education you received gets passed down to your children as well.

I believe that education can truly change a person's life in a positive way, but on the other hand, it can also completely ruin a person's life. That's how much I believe education carries a heavy responsibility.

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

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

Hello!

I started studying development as someone from a non-technical background. Before I knew it, I've become a 6-year developer! Recently, I worked as a developer while serving as CTO at 2 companies. Whenever I had time, I've been doing coding lectures, company development consulting, and speaking engagements.

The number of students I've taught has now exceeded 24,000 (as of July 2025)! Every time I teach my students, I feel it again - I can't forget the sense of fulfillment from education, so I plan to continue teaching consistently on Inflearn.
(* Among students, successful admissions to Kakao Pay, Yanolja, and Woowa Brothers)

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

For these reasons, I hope that by sharing and giving what I've 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 course .


🚌 Not sure what order to take the courses in?

'[2026] Essential Curriculum to Get Hired as a Backend Developer (IT Service Companies)' for reference!

Recommended for
these people

Who is this course right for?

  • Someone learning DB design for the first time

  • For those who find it difficult to apply the concept of normal forms in practice

  • Those who want to learn database design methods commonly used by professional developers

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

Need to know before starting?

  • Basic SQL Statements

Hello
This is

30,294

Learners

2,219

Reviews

744

Answers

4.9

Rating

17

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

Curriculum

All

44 lectures ∙ (5hr 1min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

204 reviews

4.9

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

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

$59.40

jscode's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!