강의

멘토링

로드맵

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

2,377 learners

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

Reviews from Early Learners

What you will learn!

  • 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

Korea's #1 in cumulative students in the 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 wanted to create a database course that contains the fundamentals truly needed for practical work."

The practical database that makes the difference in skills

Many developers view databases as simple storage systems and only repeat create, update, read, and delete operations. Even though they know about JOINs and INDEXes, they often don't properly 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 when both coding abilities and database management skills are developed together.
Database design is especially important because if the structure is poorly designed, it becomes difficult to change later, making it crucial to build solid fundamentals from the start.

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

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

This basic course is the most important lecture that serves as the backbone of the roadmap, containing only the minimum essential database fundamentals that you must know.

This is a course for all job roles, 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 knowing the core functions covered in the course, anyone can read and interpret data and connect it to practical insights.

Kim Younghan'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 for practical work.

Introduction to Roadmap Structure Lectures and Guide Videos

Frame 66

Roadmap Series Part 2: Database Fundamentals

6 Essential SQL Topics for Practical Work

Join

In the basic section, we first dive deep into joins, which are called the flower of relational databases. Starting from why they are necessary, we cover inner, outer, and self joins, showing you through practical examples what to use in which 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

Gather scattered data through unions, and classify and process the necessary data according to conditions using case statements. Through views, you can save the complex SQL you created with a simple name.

Index

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

Transactions, 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 is.

Stored Procedures, Functions, Triggers

Finally, we'll take a brief look at how to utilize database logic such as stored procedures, functions, and triggers. We'll also explore why these features are rarely used in recent practical work and examine alternatives in modern application development.

Exceptional lectures 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 deep thinking from a beginner's perspective. Just as the current lectures have been for me, I hope you will continue to create lectures that can extend a helping hand to people who are lost and struggling like I was back then. Thank you!

"Spring Boot - Core Principles and Applications"
Course Reviews

⭐⭐⭐⭐⭐️

I only knew how to do CRUD, and when I occasionally encountered DB issues, even after googling, the knowledge was fragmented and seemed to have gaps somewhere, but this is a lecture that 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-nim.

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

⭐⭐⭐⭐⭐

It's really the best. While taking other lectures, I had questions like "Why do they use it this way?" and all those unresolved doubts and things I wondered about while self-studying like "Why does this part work this way??" are all explained clearly and comprehensively. ... If you've had the experience of not being able to cleanly resolve your questions while studying alone, I really highly recommend this. I'm really looking forward to the intermediate and advanced lectures too.

"Kim Younghan's Practical Java - Basic Edition"
Course Reviews

⭐⭐⭐⭐⭐

Showing how things actually work by keeping the web browser developer tools open throughout the lecture and demonstrating the actual operation was what made me think "Oh, so this is how the parts I'm actually studying work!" and became a catalyst for gaining more interest. ... Please continue uploading many lectures and spreading positive influence to many people. Thank you for the lecture, I enjoyed it very much. ^^

"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 previous topics once more. ... Due to the limitations of government-funded education, I couldn't collapse like this and found your lectures while searching, and I feel like my life is going to change thanks to them. 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, you naturally built it up from start to finish by showing how these technologies were introduced to solve inefficiencies or problems that arose while writing code, which allowed me to learn smoothly and effectively!

"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

560,359

Learners

37,067

Reviews

8,987

Answers

5.0

Rating

25

Courses

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

 

저의 개발 인생 이야기

EO 인터뷰 영상

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

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

 

Curriculum

All

84 lectures ∙ (13hr 40min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

163 reviews

5.0

163 reviews

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

    Reviews 50

    Average Rating 5.0

    5

    20% enrolled

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

    • 김영한
      Instructor

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

  • jjs270402님의 프로필 이미지
    jjs270402

    Reviews 25

    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님 열심히 준비한 보람이 있네요 :) 다음 설계편을 가장 기대해주셔도 좋을거에요^^ 고맙습니다.

  • 황용학님의 프로필 이미지
    황용학

    Reviews 14

    Average Rating 4.9

    5

    31% enrolled

    좋은 강의 감사합니다.

    • 김영한
      Instructor

      황용학님 감사합니다!

  • 송성희님의 프로필 이미지
    송성희

    Reviews 2

    Average Rating 5.0

    5

    31% enrolled

    예시도 많고 이해하기 너무 좋습니다. 감사합니다.

    • 김영한
      Instructor

      송성희님 열심히 들어주셔서 저도 감사합니다!

$68.20

yh's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!