강의

멘토링

커뮤니티

NEW
Programming

/

Database

[Lv0] Just 2 Hours! SQL/DB Core Concepts Crash Course

"I know I need to study SQL, but I don't know where to start." When you open a database book, terms like normalization, B-Tree, and clusters... it's daunting right from the start. This course strips away all those complex theories and includes only what you truly need. Where are KakaoTalk messages stored? Why is the MapleStory trade window secure? Starting with everyday examples like these, you can grasp the entire flow of SQL in just 2 hours by coding along through installation → creating tables → CRUD → JOIN → and indexes.

(4.8) 5 reviews

479 learners

Level Beginner

Course period Unlimited

  • dingcodingco
MySQL
MySQL
database
database
DBMS/RDBMS
DBMS/RDBMS
MySQL
MySQL
database
database
DBMS/RDBMS
DBMS/RDBMS
Thumbnail

What you will gain after the course

  • Interview confidence in "DB basics"

  • An environment where I can run SQL directly on my computer.

  • Fundamentals for using CRUD and JOIN fluently

"Where on earth are KakaoTalk messages stored?"

The alarm that went off this morning, the KakaoTalk messages shared with friends, the restaurant ratings searched for lunch. Today alone, you have created and used hundreds of pieces of data.
But can you explain where and how this data is stored?
When you open a book to study databases, it's all gibberish from the first page: normalization, B-Tree, clusters...
"Can't I just quickly learn what's actually used in the field?"


That's why I created this course.

🍜 What data makes up a Naver Maps restaurant page?

🎮 Why doesn't the MapleStory trade window have a bug where money is deducted from only one side?

📚 How to find the book you want from 500,000 books in just 0.1 seconds?


Skip the complex theories and start with the "Why?" of everyday life.
Installation → Table Creation → Data CRUD → JOIN → Transactions → Indexes
Master the entire flow of SQL by coding along in under 2 hours.
By the end of this course, databases will no longer feel like a black box.


What you will gain from this course

MySQL + DBeaver Environment Setup

Windows/Mac installation guides provided & how to execute SQL using GUI tools

Summary of Core Database Concepts

Relationships between tables, records, primary keys (PK), and foreign keys (FK)
1:1, 1:N, M:N relationships and utilizing JOINs
Transaction ACID (Easily understood with a MapleStory trade window example)

Hands-on performance optimization practice

Generating 500,000 mock data records
Performance comparison before and after applying indexes (274ms → 69ms)
Concepts of composite indexes and cardinality

Programmers SQL Problem Solving

Practice with types found in actual coding tests
Utilizing AVG, ROUND, GROUP BY, and HAVING

What you'll learn.

Learn Databases Easily with Real-World Examples

  • Understanding the nature of data through Naver restaurant pages

  • Relational vs. Non-relational DB, when to use which?

  • MySQL + DBeaver: From Installation to Connection


Solidifying Table and SQL Basics

  • Learning Table, Record, and Key Concepts with School Data

  • Creating a database and creating your first table

  • Inserting and retrieving data with INSERT and SELECT

Completing CRUD and Connecting Tables with JOIN

  • Updating and deleting data with UPDATE and DELETE

  • Learning 1:N and M:N relationships through teacher-class relationships

  • Joining tables with LEFT JOIN and INNER JOIN

  • Extracting desired data with GROUP BY and subqueries

Gaining practical experience with transactions and indexes

  • Understanding Transactions and ACID through the MapleStory Trade Window

  • The principle of indexing, which works like a thick book's index

  • Increasing search speed by 4x on 500,000 data entries

Recommended for:

🎯 Those learning SQL for the first time

Non-majors who haven't taken a database
course
Those who want to start from "what a table is" and "what a record is"

🎯 Those who have learned but need to organize their knowledge

Those who learned quickly at a bootcamp but haven't grasped the overall flow. Those who can perform CRUD but don't know what transactions or indexes are.

🎯 Those preparing for the next step

Those who want to build a solid SQL foundation before taking a JPA course; those who want to solve the Programmers SQL High Score Kit

The person who created this course

Sharing the behind-the-scenes stories of final interviews at Coupang and Yanolja - A 6th-year developer's 24-company job-hopping story [ep 5]

Dingcodingco(Main Instructor)

  • 2021 ~ 2022: S Coding Club Algorithm (data-structure) Tutor

  • 2022 ~ : Operating coding YouTube channel Dingco Dingco (Features various content related to developer employment)

  • 2022 ~ 2023 : Viva Republica Server Developer


  • Never give up on students 🦈

  • Managing a developer job-hunting community and organizing offline meetups


Things to know before taking the course

Learning Materials

  • Lecture notes are provided via a Notion link. Feel free to check them anytime for review!

Prerequisites and Important Notes

📌 Required: None

I'll teach you step-by-step starting from MySQL installation. You will learn about DBMS/RDBMS!
You can follow along even without any programming experience.

📌 Nice to have:

If you have experience with any programming language (Python, Java, JavaScript, etc.)
Basic concepts such as "variables" and "conditional statements"

Recommended for
these people

Who is this course right for?

  • For those who just started learning to code and don't know what SQL is

  • For those who bought an SQL book but are struggling to get past Chapter 3.

Need to know before starting?

  • No need! If you know how to turn on a computer and use a web browser, you're all set.

Hello
This is

13,660

Learners

1,412

Reviews

267

Answers

4.9

Rating

16

Courses

🚀 Ex-Toss, POSTECH Alumni | Backend 8 years
🎥 YouTuber with 20k subscribers | Development content creator
📚 Inflearn Instructor | 8,000+ cumulative students
👥 Running a developer career community (8,000+ members)
🧩 Contributor to various open source projects (Gradle, Spring AI, etc.)
📝 Passed 38 resume screenings & 100+ resume coaching sessions on Kmong (5.0 rating)

Flipping the way you code, DingcoDingco. Delivering knowledge that is easy and deductively understood.
Đảo ngược lập trình, Dingco Dingco. Truyền tải kiến thức một cách dễ hiểu và có tính suy luận.

Inflearn Interview Link!

Curriculum

All

11 lectures ∙ (2hr 25min)

Published: 
Last updated: 

Reviews

All

5 reviews

4.8

5 reviews

  • devkuka님의 프로필 이미지
    devkuka

    Reviews 289

    Average Rating 5.0

    5

    36% enrolled

    I learned a lot about databases! Thank you for the great lecture.

    • gkdldh님의 프로필 이미지
      gkdldh

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      Unlike other courses, this database lecture is concise and easy to understand!! I love it so much.

      • foxrose71857님의 프로필 이미지
        foxrose71857

        Reviews 10

        Average Rating 4.4

        4

        55% enrolled

        • sasas님의 프로필 이미지
          sasas

          Reviews 74

          Average Rating 4.9

          5

          36% enrolled

          • syhan75162629님의 프로필 이미지
            syhan75162629

            Reviews 16

            Average Rating 5.0

            5

            64% enrolled

            Free

            dingcodingco's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!