강의

멘토링

로드맵

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

2,211 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

558,507

Learners

36,608

Reviews

8,965

Answers

5.0

Rating

25

Courses

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

 

저의 개발 인생 이야기

EO 인터뷰 영상

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

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

 

Curriculum

All

84 lectures ∙ (13hr 40min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

110 reviews

5.0

110 reviews

  • dirend79555님의 프로필 이미지
    dirend79555

    Reviews 50

    Average Rating 5.0

    5

    20% enrolled

    わ.... 現職開発者です。 早く次の編を1ヶ月以内にアップしてください..... そうでないと拗ねちゃいますよ 講義を見て本当に気が狂いそうです 良すぎて...... そうでなくても最近sqlの重要性? 性能、チューニングが重要だと思っていたのですが、基本編から実務的なTIPと段階的に説明してくださる深さ、大韓民国で良い講義を聞いていて光栄です。 他の方々にもお勧めします!!

    • yh
      Instructor

      개foot様、ありがとうございます :) 網羅的な説明はせず、実務に必要な内容に絞り解説しようと腐心しましたが、その意図を汲んでいただき、感謝申し上げます。 楽しく学んで、大きく成長されることを応援しています!

  • jjs2704023067님의 프로필 이미지
    jjs2704023067

    Reviews 6

    Average Rating 5.0

    5

    7% enrolled

    就活生として、先生の講義が本当にとても役に立っています。今回のデータベース編もそうです。一日も早く次の講義も一生懸命学びたいです。いつも情熱的な講義をありがとうございます :)

    • yh
      Instructor

      jjs270402さん、一生懸命勉強されて、また望まれる目標を達成されることを応援しています!

  • liang님의 프로필 이미지
    liang

    Reviews 3

    Average Rating 5.0

    5

    43% enrolled

    Javaをやったことがないので、初めて講義を聞いてみます。なぜ人気講師でいらっしゃるのかわかりますね。次回できるだけ早くお願いします...

    • yh
      Instructor

      Seung Min Liangさん、一生懸命準備した甲斐がありますね :) 次の設計編を最も期待していただいても良いと思います^^ ありがとうございます。

  • godkkoo5758님의 프로필 이미지
    godkkoo5758

    Reviews 55

    Average Rating 5.0

    Edited

    5

    100% enrolled

    良い講義をありがとうございます。

    • yh
      Instructor

      godkkoo2さん、ファイティング!

  • gonasooc님의 프로필 이미지
    gonasooc

    Reviews 8

    Average Rating 5.0

    5

    31% enrolled

    Limited time deal

    $7,832.00

    24%

    $68.20

    yh's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!