강의

멘토링

커뮤니티

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

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

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

567,223

Learners

38,091

Reviews

9,013

Answers

5.0

Rating

25

Courses

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

 

저의 개발 인생 이야기

EO 인터뷰 영상

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

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

 

Curriculum

All

84 lectures ∙ (13hr 40min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

233 reviews

5.0

233 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 26

    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.

  • jongchichi12님의 프로필 이미지
    jongchichi12

    Reviews 5

    Average Rating 5.0

    5

    61% enrolled

    I truly love instructor Kim Young-han I will definitely become a successful backend developer

    • yh
      Instructor

      I'll support you too, Kim Jong-hwan! Love you :)

  • yanolja22320님의 프로필 이미지
    yanolja22320

    Reviews 3

    Average Rating 5.0

    5

    31% enrolled

    Limited time deal ends in 00:57:11

    $51.70

    24%

    $68.20

    yh's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!