강의

멘토링

커뮤니티

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

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

569,431

Learners

38,502

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

255 reviews

5.0

255 reviews

  • dirend79555님의 프로필 이미지
    dirend79555

    Reviews 50

    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!

  • jjs2704023067님의 프로필 이미지
    jjs2704023067

    Reviews 27

    Average Rating 5.0

    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!

  • 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.

  • 13242248168님의 프로필 이미지
    13242248168

    Reviews 14

    Average Rating 5.0

    5

    86% enrolled

    • ericluv986430님의 프로필 이미지
      ericluv986430

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      Limited time deal ends in 8 days

      $48.40

      29%

      $68.20

      yh's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!