강의

멘토링

커뮤니티

BEST
Programming

/

Database

Kim Younghwan's Practical Database - Basic Edition

Learn the essential SQL and database fundamentals needed for practical work. Not only developers, but also planners and data analysts can learn SQL in depth.

(5.0) 248 reviews

2,913 learners

  • yh
데이터베이스
DBMS/RDBMS
sql
mysql
SQLD
SQL
MySQL

Reviews from Early Learners

What you will gain after the course

  • Understanding the Basic Concepts and Structure of Relational Databases

  • Core SQL Syntax and Key Query Utilization (JOIN, Subquery, UNION, CASE, VIEW, etc.)

  • High-Performance Query Index Optimization (Covering & Composite Indexes)

  • Finding Optimal Index Structure and Design Principles Through Execution Plan Analysis

  • Stable Data Processing Through Transaction and Integrity Management

The #1 cumulative student enrollment in Korea's development field,
Kim Young-han's Practical Database

Trendy technology? What's more important is database fundamentals!

I'm Younghwan Kim, CTO of Woowa Brothers, with over 500,000 cumulative students
Why I Created a Database Course

I'm ready to translate Korean text to English following all the guidelines provided. Please share the

"I wanted to create a database course that contains the fundamentals truly needed in real-world practice."

The difference in skills comes from practical database experience

Many developers view databases as mere storage, repeatedly performing only create, read, update, and delete operations. While they know about JOINs and INDEXes, they often don't truly understand why they're necessary.

However, if JOIN configurations or INDEX settings are inadequate, the service gradually slows down and eventually leads to failures. In fact, since 90% of failures originate from database issues, databases are at the core of development.

Good design and queries
start with the fundamentals.

Ultimately, a developer's skills are complete only when both coding abilities and database management skills are developed together.
In particular, since a poorly designed database structure is difficult to change later, it's more important than anything to build a solid foundation from the start.

Therefore, this course doesn't just teach SQL syntax.

Beyond simply knowing SQL syntax, this course is designed to help you clearly understand the underlying principles of how SQL works, and develop the ability to independently judge and design optimal SQL queries that match your data structure and situation.

This foundational course is the most important course that serves as the backbone of the roadmap, containing only the minimum essential database fundamentals you need to know.

This course is for all job functions, not just developers.

For analysts, planners, and marketers, SQL is no longer optional. It's becoming increasingly important to improve services based on data, persuade organizations, and communicate smoothly with development teams. Just by knowing the core features covered in the course, anyone can read and interpret data and connect it to practical insights.

Kim Young-han's Practical Database Roadmap

This course is the second course in the Practical Database Roadmap, designed to help all IT professionals systematically learn the essential database fundamentals needed in real-world practice.

Introduction to Roadmap Structure Lectures and Guide Videos

Frame 66

Roadmap Series Part 2: Database Fundamentals

6 Core SQL Topics for Practical Work

Join

In the basics section, we first dive deep into joins, which are called the flower of relational databases. Starting from why they're needed, through inner, outer, and self joins, we'll show you through practical examples which one to use in what situations.

Subquery

Next, we'll organize subqueries, and clearly explain what many people find confusing: the differences between subqueries and joins, and when to use each for better performance.

UNION, CASE, VIEW

Using unions, we gather scattered data, and with case statements, we classify and process the necessary data according to conditions. Through views, we can save the complex SQL we've created under simple names.

Index

The key to service speed: indexes. Beyond simple syntax explanations, we cover the structure and principles of how indexes enable fast searches, along with practical optimization techniques such as covering indexes and composite indexes. Furthermore, we provide clear guidance on how to design and effectively utilize indexes.

Transaction, Data Integrity

We also cover in depth transactions that ensure data consistency and data integrity. We'll help you build a solid foundation by explaining why concurrency control is necessary and what ACID means.

Stored Procedures, Functions, and Triggers

Finally, we'll briefly explore how to utilize database logic such as stored procedures, functions, and triggers. We'll also examine why these features are less commonly used in modern practice and look at alternatives in contemporary application development.

Lectures that stand out from the basics
Proven by 500,000+ students.

⭐⭐⭐⭐⭐

I was often moved by the step-by-step sequences and materials that could only come from deeply thinking from a beginner's perspective. Just as your current courses did for me, I hope you'll continue to create courses that can reach out to people who are lost and struggling, just like I was back then. Thank you!

"Spring Boot - Core Principles and Practical Application"
Course Reviews

⭐⭐⭐⭐⭐️

I only knew how to do CRUD, and when I occasionally encountered DB issues, even after googling, the knowledge was fragmented and felt like there were gaps somewhere, but this lecture fills those gaps. ... I guess fundamentals are important after all. And I don't think there's anyone who can establish those fundamentals as well as Younghan does.

"Spring DB Part 1 - Core Principles of Data Access" Course Reviews

⭐⭐⭐⭐⭐

It's truly the best. While taking other courses, I had questions like "Why is it used this way?" and things that left me wondering were never resolved, and all those moments when I was self-studying and thought "Why does this part work like this??" are all explained clearly. ... If you've had the experience of not being able to cleanly resolve your questions while studying alone, I highly recommend this. I'm really looking forward to the intermediate and advanced courses as well.

"Kim Young-han's Practical Java - Basic Edition"
Course Reviews

⭐⭐⭐⭐⭐

Showing how things actually work by opening the browser developer tools throughout the lecture became a catalyst for me to become more interested, realizing "Oh, this is how the parts I'm actually studying work". ... Please continue to upload many lectures and spread positive influence to many people. Thank you for the great lecture. ^^

"HTTP Web Basics for All Developers" Course Reviews

⭐⭐⭐⭐⭐

I was truly grateful for the practical lectures and detailed explanations you provided, as well as your thoughtfulness in explaining things again that you had covered before. ... Due to the limitations of government-funded education, I couldn't let myself fall apart, and while searching, I found your lectures, which I believe will change my life. With the goal of working at the same company as you as a developer, I will strive to become a competent developer. I sincerely thank you.

"Spring Core Principles - Basic Edition" Course Reviews

⭐⭐⭐⭐⭐

I was able to get a big picture of what I could build with Spring, and instead of just teaching the technology indiscriminately, when inefficiencies or problems arose while writing code, you naturally built up from start to finish how these technologies were introduced to solve them, so I was able to learn smoothly!

"Introduction to Spring - Learn Spring Boot, Web MVC, and DB Access Technologies through Code"Course Reviews

Recommended for
these people

Who is this course right for?

  • Developer job seekers

  • Developers who have studied databases but want to properly solidify their fundamentals

  • Planners, marketers, and data analysts who want to learn SQL

  • Everyone in the IT industry

Need to know before starting?

  • Kim Young-han's Practical Database Introduction - Starting from SQL Step by Step

  • Basic SQL Usage Including SELECT, GROUP BY, and HAVING

Hello
This is

568,650

Learners

38,411

Reviews

9,021

Answers

5.0

Rating

25

Courses

진짜 실무에 필요한 제대로 된 개발자가 될 수 있도록, 교육하는 것이 저의 목표입니다.

 

저의 개발 인생 이야기

EO 인터뷰 영상

개발바닥 - 시골 청년 개발왕 되다

취업과 이직에 대한 고민 해결

 

Curriculum

All

84 lectures ∙ (13hr 40min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

248 reviews

5.0

248 reviews

  • 개foot님의 프로필 이미지
    개foot

    Reviews 50

    Average Rating 5.0

    5

    20% enrolled

    와.... 현직 개발자 입니다. 빨리 그다음편 한달안으로 올려주십쇼..... 안그러면 삐질꼬얌 강의 보고 너무 미치겠습니다 너무 좋아서...... 안그래도 요즘 sql 의 중요성? 성능, 튜닝이 중요하겠다 싶었는데 기본편 부터 실무적인 팁과 단계적으로 설명해주시는 깊이 대한민국에서 좋은 강의를 듣고 있어서 영광입니다. 다른분들도 추천합니드아!!

    • 김영한
      Instructor

      개foot님 감사합니다 :) 모든 것을 설명하기 보다는 실무에 꼭 필요한 내용 위주로 설명하기 위해 많이 고민했는데, 이런 부분들을 알아주셔서 고맙습니다. 즐겁게 공부하시고 크게 성장하시길 응원합니다!

  • jjs270402님의 프로필 이미지
    jjs270402

    Reviews 27

    Average Rating 5.0

    5

    7% enrolled

    취준생으로써, 선생님의 강의가 정말 많은 도움이 되고 있습니다. 이번 데이터베이스 편도 그렇구요. 하루빨리 다음 강의도 열심히 배우고 싶습니다. 항상 열정적인 강의 감사합니다 :)

    • 김영한
      Instructor

      jjs270402님 열심히 공부하시고 또 원하시는 목표를 이루시길 응원합니다!

  • Seung Min Liang님의 프로필 이미지
    Seung Min Liang

    Reviews 3

    Average Rating 5.0

    5

    43% enrolled

    자바를 안해서, 처음 강의를 들어봅니다. 왜 인기강사이신줄 알겠네요. 다음편 가능한 빨리 부탁드립니다...

    • 김영한
      Instructor

      Seung Min Liang님 열심히 준비한 보람이 있네요 :) 다음 설계편을 가장 기대해주셔도 좋을거에요^^ 고맙습니다.

  • 1324224님의 프로필 이미지
    1324224

    Reviews 14

    Average Rating 5.0

    5

    86% enrolled

    • 김찬우님의 프로필 이미지
      김찬우

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      $68.20

      yh's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!