
Kim Younghan's Practical Java - Basics
yh
Learn practical core Java object-oriented concepts easily via example code.
Basic
Java, oop
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.
4,685 learners
Level Basic
Course period Unlimited
Reviews from Early Learners
5.0
개foot
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
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
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...
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
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."
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.
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.
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.
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.
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.
Young-han Kim's Practical Database Introduction - Step by step from SQL
Young-han Kim's Practical Database - Basic Edition
Young-han Kim's Practical Database - Performance Optimization and Advanced Features (Scheduled for release in the first half of 2026)
The second in the roadmap series, Database Basics
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.
⭐⭐⭐⭐⭐
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
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
Inflearn Verified
600,923
Learners
42,031
Reviews
9,109
Answers
5.0
Rating
26
Courses
Educator
Former: Technical Director at Woowa Bros, Kakao, SK Planet
Author: Java ORM Standard JPA Programming
My goal is to provide education so that you can become a truly practical and competent developer.
EO Interview Video
The Life of Young-han Kim, Korea's Top Developer Instructor [Part 1]
The Life of Younghan Kim, Korea's Top Developer Instructor [Part 2]
Gaebalbadak - A Country Youth Becomes the King of Development
All
84 lectures ∙ (13hr 40min)
Course Materials:
All
451 reviews
5.0
451 reviews
Reviews 3
∙
Average Rating 5.0
5
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...
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.
Reviews 58
∙
Average Rating 5.0
5
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!!
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!
Reviews 36
∙
Average Rating 4.9
5
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 :)
I'm cheering for jjs270402 to study hard and achieve the goals you're aiming for!
Reviews 11
∙
Average Rating 4.9
5
I enjoyed the lecture. Thank you.
It's rewarding for me to see you listening so attentively, Ryuhoi. Thank you.
Reviews 7
∙
Average Rating 4.4
Check out other courses by the instructor!
Explore other courses in the same field!
Limited time deal ends in 7 days
$1,312,852.00
29%
$68.20