Young-han Kim's Practical Database - Basic Course

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

(5.0) 397 reviews

3,907 learners

Level Basic

Course period Unlimited

SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
SQLD
SQLD
SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
SQLD
SQLD

Reviews from Early Learners

5.0

5.0

개foot

20% enrolled

Wow.... I'm a current developer. Please upload the next episode within a month..... Otherwise I'll get sulky I'm going crazy watching the lectures because they're so good...... I was already thinking that the importance of SQL? Performance and tuning would be important these days, but starting from the basics with practical tips and step-by-step explanations at such depth, it's an honor to be taking such a good lecture in Korea. I recommend it to others too!!

5.0

광교js

7% enrolled

As a job seeker, your lectures are really helping me a lot. This database series is no exception. I can't wait to eagerly learn the next lecture as soon as possible. Thank you always for your passionate lectures :)

5.0

Seung Min Liang

43% enrolled

Since I haven't done Java before, this is my first time taking a lecture. Now I understand why you're such a popular instructor. Please release the next episode as soon as possible...

What you will gain after the course

  • Understanding the basic concepts and structure of relational databases

  • Core SQL Syntax and Key Query Applications (Joins, Subqueries, UNION, CASE, VIEW, etc.)

  • Index Optimization for High-Performance Queries (Covering and Composite Indexes)

  • Optimal Index Structures and Design Principles Found Through Execution Plan Analysis

  • Transaction and Integrity Management for Stable Data Processing

The #1 most-enrolled instructor in the domestic development field,
Young-han Kim's Practical Database

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

Former Technical Director at Woowa Brothers, surpassing 500,000 cumulative students
The reason why Young-han Kim created the database course

...

"I wanted to create a database course that covers the fundamental skills truly needed in practice."

Practical Database: Making the Difference in Skill

Many developers treat databases as simple storage units, repeating only registration, modification, retrieval, and deletion. While they may know about JOINs or INDEXes, they often do not properly understand why they are necessary.

However, if JOIN configurations or INDEX settings are inadequate, the service will gradually slow down and eventually lead to failures. In fact, since 90% of failures stem from database issues, the database is the core of development.

Good design and queries
start from the basics.

Ultimately, a developer's skill is complete only when the two pillars of coding and database management are both established.
In particular, since it is difficult to change a database later if the structure is poorly designed, it is more important than anything else to build a solid foundation from the start.

That is why this course does not just teach SQL syntax.

Beyond simply knowing SQL syntax, this course is designed to help you clearly understand the underlying principles of how it works and develop the ability to independently judge and design the optimal SQL for specific data structures and situations.

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

This lecture is not just for developers, but for all job roles.

SQL is no longer optional for analysts, planners, and marketers. It is becoming increasingly important to improve services based on data, persuade organizations, and communicate smoothly with development teams. By knowing just the core functions covered in this lecture, anyone can read and interpret data and connect it to practical insights.

Young-han Kim's Practical Database Roadmap

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

Introduction to Roadmap Courses and Guide Videos

Frame 66

The second in the roadmap series, Database Basics

6 core SQL topics for practical application

Join

In the basic course, we first dive deep into Joins, which are often called the flower of relational databases. Starting from why they are necessary to inner, outer, and self-joins, I will show you which one to use in what situation through practical examples.

Subquery

Next, we will organize subqueries and clearly explain the differences between subqueries and joins—which many people find confusing—as well as when to use each for better performance.

UNION, CASE, VIEW

Gather scattered data through UNION, and classify and process the necessary data according to conditions using CASE statements. Through VIEW, you can save the complex SQL you've created under a simple name.

Index

Indexes, the key to service speed. Beyond simple syntax explanations, we will understand the structures and principles of how indexes enable fast searches, and cover practical optimization techniques such as covering indexes and composite indexes. Furthermore, we provide a clear guide on how to design and effectively utilize indexes.

Transactions, Data Integrity

We also cover in depth transactions and data integrity, which ensure data consistency. We will establish the fundamentals of why concurrency control is necessary and what ACID is.

Stored procedures, functions, and triggers

Finally, we will briefly look at how to utilize logic within the database, such as stored procedures, functions, and triggers. We will also explore why these features are not commonly used in recent practical work and discuss alternatives in modern application development.

A course that stands out from the basics
Proven by 500,000+ students.

⭐⭐⭐⭐⭐

I have often been moved by the step-by-step sequences and materials that could only come from thinking deeply from a beginner's perspective. Just as your current lectures have been for me, I hope you continue to create courses that reach out to those who, like I once was, are lost and struggling. Thank you!

"Spring Boot - Core Principles and Application"
Course Review

⭐⭐⭐⭐⭐

I only knew how to do basic CRUD, and whenever I encountered DB issues, searching on Google only gave me fragmented knowledge that felt like there were gaps, but this lecture fills those gaps. ... I guess the basics really are important. And I don't think anyone can establish those basics as well as Young-han.

"Spring DB Part 1 - Core Data Access Principles" Course Review

⭐⭐⭐⭐⭐

It's truly the best. He clearly explains all the things that left me wondering "Why is it used this way?" while taking other courses, and the parts where I thought "Why does this work like this??" while self-studying. ... If you've ever had the experience of not being able to clearly resolve your doubts 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 Review

⭐⭐⭐⭐⭐

I think the way you open the web browser developer tools during the lecture to show how things actually work served as an opportunity for me to become more interested, seeing that the parts I'm studying actually operate that way. ... Please continue to upload many lectures and spread a positive influence to many people. I truly enjoyed the lecture. ^^ house

"HTTP Web Fundamentals for All Developers" Course Review

⭐⭐⭐⭐⭐

I am truly grateful for your practical lectures, detailed explanations, and the thoughtfulness of explaining previous concepts once more. ... Due to the limitations of government-funded education, I felt like I couldn't go on like this, but thanks to your lectures that I discovered, I feel like my life is going to change. With the goal of working at the same company as you as a developer, I will strive to become a competent developer. Thank you sincerely.

"Spring Core Principles - Basic" Course Review

⭐⭐⭐⭐⭐

I was able to draw a big picture of what can be created with Spring, and rather than just teaching the technology blindly, you showed how certain technologies were introduced to solve inefficiencies or problems that arise while writing code, naturally building it up from start to finish, which allowed me to learn smoothly!

"Spring Introduction - Learning Spring Boot, Web MVC, and DB Access Technologies through Code"Course Review

Recommended for
these people

Who is this course right for?

  • Aspiring developer

  • Developers who have studied databases but want to solidify their foundational skills.

  • Product managers, marketers, and data analysts who want to learn SQL

  • Everyone in the IT industry

Need to know before starting?

  • Young-han Kim's Introduction to Practical Databases - Step by Step from SQL

  • Basic SQL usage including SELECT, GROUP BY, and HAVING

Hello
This is yh

586,885

Learners

41,172

Reviews

9,091

Answers

5.0

Rating

26

Courses

My goal is to provide education so that you can become a truly practical and competent developer.

 

The story of my life as a developer

EO Interview Video

Gaebalbadak - A Country Youth Becomes the King of Development

Solving concerns about employment and career changes

 

More

Curriculum

All

84 lectures ∙ (13hr 40min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

397 reviews

5.0

397 reviews

  • jjs2704023067님의 프로필 이미지
    jjs2704023067

    Reviews 35

    Average Rating 4.9

    5

    7% enrolled

    As a job seeker, your lectures are really helping me a lot. This database series is no exception. I can't wait to eagerly learn the next lecture as soon as possible. Thank you always for your passionate lectures :)

    • yh
      Instructor

      I'm cheering for jjs270402 to study hard and achieve the goals you're aiming for!

  • dirend79555님의 프로필 이미지
    dirend79555

    Reviews 55

    Average Rating 5.0

    5

    20% enrolled

    Wow.... I'm a current developer. Please upload the next episode within a month..... Otherwise I'll get sulky I'm going crazy watching the lectures because they're so good...... I was already thinking that the importance of SQL? Performance and tuning would be important these days, but starting from the basics with practical tips and step-by-step explanations at such depth, it's an honor to be taking such a good lecture in Korea. I recommend it to others too!!

    • yh
      Instructor

      Thank you, 개foot :) I put a lot of thought into focusing on explanations of content essential for practical work rather than covering everything, and I appreciate you recognizing these aspects. I wish you joyful studies and significant growth! I cheer you on!

  • liang님의 프로필 이미지
    liang

    Reviews 3

    Average Rating 5.0

    5

    43% enrolled

    Since I haven't done Java before, this is my first time taking a lecture. Now I understand why you're such a popular instructor. Please release the next episode as soon as possible...

    • yh
      Instructor

      It was worth all the hard work you put into preparing this, Seung Min Liang :) You can look forward to the next design section the most^^ Thank you.

  • 0607kmh0559님의 프로필 이미지
    0607kmh0559

    Reviews 7

    Average Rating 5.0

    5

    100% enrolled

    I am a frontend developer. This was very helpful for my server development studies. I've watched several other SQL lectures, but I really liked being able to get a glimpse into the perspective of a web server developer.

    • yh
      Instructor

      Thank you, Blackhwan! Have a great day!!

  • kimwoobin님의 프로필 이미지
    kimwoobin

    Reviews 10

    Average Rating 5.0

    5

    31% enrolled

    I'm always enjoying your content.

    • yh
      Instructor

      woodol4540, it's very rewarding for me to see you listening so hard^^ Thank you :)

yh's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!