강의

멘토링

커뮤니티

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.

213 learners are taking this course

Level Beginner

Course period Unlimited

  • dingcodingco
실습 중심
실습 중심
데이터베이스
데이터베이스
DBMS/RDBMS
DBMS/RDBMS
데이터베이스설계
데이터베이스설계
MySQL
MySQL
database
database
실습 중심
실습 중심
데이터베이스
데이터베이스
DBMS/RDBMS
DBMS/RDBMS
데이터베이스설계
데이터베이스설계
MySQL
MySQL
database
database
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,215

Learners

1,380

Reviews

260

Answers

4.9

Rating

16

Courses

🚀 토스, 포항공대 출신 | 백엔드 8
🎥2만 유튜버 | 개발 콘텐츠 제작
📚 인프런 강사 | 누적 수강생 8,000+
👥 개발자 취업 커뮤니티 운영 중 (8,000+)
🧩 오픈소스 (Gradle, Spring AI 등) 다수 Contributor
📝38개 서류 합격 및 크몽 이력서 첨삭 100+회 이상 경험 (평점 5.0점)

코딩을 뒤집다, 딩코딩코. 쉽고, 연역적으로 이해되는 지식을 전달합니다.

인프런 인터뷰 링크!

Curriculum

All

11 lectures ∙ (2hr 25min)

Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

Free

dingcodingco's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!