Hands-on! Complete Database Mastery [Design Edition]

Learn practical strategies for designing efficient and scalable database structures that accurately reflect the complex requirements of real-world scenarios.

(4.9) 13 reviews

334 learners

Level Basic

Course period Unlimited

MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
database
database
modeling
modeling
db
db
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
database
database
modeling
modeling
db
db

Reviews from Early Learners

4.9

5.0

๋‹ญ์ด๋œ๊ธฐ์•„

100% enrolled

I completed the entire course and there were many parts about databases that I didn't know, but it was a great opportunity to learn a lot! I learned well!!

5.0

๋„์œค

100% enrolled

I've always relied on experience and intuition when designing tables, but this opportunity to encounter systematically organized content has been incredibly helpful!! As the vague concepts became clearer, I gained confidence and feel like I'll be able to approach actual design work with much more certainty in the future. Thank you for the great lecture!

5.0

์šฐ์ฃผ

33% enrolled

This was exactly the lecture I needed most right now. The explanations were thorough and detailed, yet easy to understand, and I was able to clearly grasp what aspects to carefully consider when designing databases and which areas require overhead considerations.

What you will gain after the course

  • Core Concepts and Practical Know-how of Database Design All at Once

  • Concrete Case-Based Database Design Methods

  • Efficient and Scalable Data Modeling Strategies

์‹ค๋ฌด์—์„œ ์ž์ฃผ ์‚ฌ์šฉ๋˜๋Š” ํ…Œ์ด๋ธ” ์„ค๊ณ„ ์ „๋žต๊ณผ ํŒจํ„ด ์ง‘์ค‘ ํ•™์Šต ๐Ÿš€
๊ฐ์ด ์•„๋‹ˆ๋ผ ๋…ผ๋ฆฌ์ ์ธ ์ด๋ก ์„ ๊ธฐ๋ฐ˜์œผ๋กœ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์„ค๊ณ„ํ•˜๋Š” ๋ฐฉ๋ฒ•
โญ
๋ฌด์ž‘์ • ๋”ฐ๋ผ ํ•˜๋Š” ๊ฒƒ์ด ์•„๋‹ˆ๋ผ, ์›๋ฆฌ๋ฅผ ์ดํ•ดํ•˜๋ฉฐ ๋ฐฐ์šฐ๋Š” ๊ฐ•์˜ โœ…

๐Ÿ”ฅ ์‹ค์ „์—์„œ ๋ฐ”๋กœ ์“ธ ์ˆ˜ ์žˆ๋Š” ์‹ค์ „ DB ์„ค๊ณ„ ์ „๋žต์„ ๋ฐฐ์›๋‹ˆ๋‹ค

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„์˜ ํ•ต์‹ฌ ๊ฐœ๋…๊ณผ ๋‹ค์–‘ํ•œ ์‹ค์ „ ์„ค๊ณ„ ์ „๋žต์„ ๋‹ค๋ฃน๋‹ˆ๋‹ค.

  • ๊ธฐ๋ณธํ‚ค, ์™ธ๋ž˜ํ‚ค, ์ •๊ทœํ™”/๋น„์ •๊ทœํ™”, ์ธ๋ฑ์Šค์— ๋Œ€ํ•œ ๊นŠ์ด ์žˆ๋Š” ์ƒ์„ธํ•œ ์„ค๋ช…


  • ์—”ํ„ฐํ‹ฐ ๊ฐ„์˜ ๋ณต์žกํ•˜๊ณ  ๋‹ค์–‘๊ด€ ๊ด€๊ณ„๋ฅผ ํ‘œํ˜„ํ•˜๋Š” ๋ฐฉ๋ฒ•

  • ์‹ค์ „์—์„œ ์ž์ฃผ ์‚ฌ์šฉ๋˜๋Š” ์„ค๊ณ„ ์ „๋žต์„ ์œ ํ˜• ๋ณ„๋กœ ์ •๋ฆฌํ•˜์—ฌ ์ฒด๊ณ„์ ์œผ๋กœ ํ•™์Šต

  • ๋งˆ๋ฌด๋ฆฌ๋กœ e-commerce ์„ค๊ณ„ ์‹ค์ „ ํ”„๋กœ์ ํŠธ๊นŒ์ง€!


โญ ๊ฐ•์˜ ํŠน์ง•

1. ์ƒ์„ธํ•˜๊ณ  ์‰ฌ์šด ์„ค๋ช… ๐Ÿ™‹โ€โ™‚

์ดˆ๋ณด์ž๋„ ์‰ฝ๊ฒŒ ์ดํ•ดํ•  ์ˆ˜ ์žˆ๋„๋ก ๋‹ค์–‘ํ•œ ์ž๋ฃŒ๋ฅผ ํ™œ์šฉํ•ด ๋ฐฐ๊ฒฝ์ง€์‹๊ณผ ์‹ฌํ™” ๊ฐœ๋…๊นŒ์ง€ ํญ๋„“๊ฒŒ ๋‹ค๋ฃน๋‹ˆ๋‹ค. ์˜จ/์˜คํ”„๋ผ์ธ ๋ถ€ํŠธ์บ ํ”„ ๊ฐ•์˜ ๊ฒฝํ—˜์„ ํ†ตํ•ด ์•„์ง ํ”„๋กœ๊ทธ๋ž˜๋ฐ์ด ๋‚ฏ์„  ์ดˆ๋ณด์ž๋“ค์—๊ฒŒ ๋ˆˆ๋†’์ด ๊ฐ•์˜์™€ ์„ค๋ช…์„ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค.

2. ์‹ค์ „ ์˜ˆ์ œ ๐Ÿ’ช

๋‹ค์–‘ํ•œ ์‹ค๋ฌด ์˜ˆ์ œ๋ฅผ ํ™œ์šฉํ•ด ๋‹จ์ˆœํžˆ ์ด๋ก ๋งŒ ํ•™์Šตํ•˜์ง€ ์•Š๊ณ , MySQL๊ณผ MySQL Workbench๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ด๋ก ์œผ๋กœ ๋ฐฐ์šด ๋‚ด์šฉ์„ ๊ณง๋ฐ”๋กœ ์‹ค์Šตํ•˜์—ฌ ์‹ค์ „ ๊ฐ๊ฐ์„ ๋Œ์–ด์˜ฌ๋ฆฝ๋‹ˆ๋‹ค.

3. ์ฃผ์ œ๋ณ„ ์‹ฌํ™” ํ•™์Šต ๐Ÿ“Œ

์ž์ฃผ ์‚ฌ์šฉ๋˜๋Š” ํ•ต์‹ฌ ์„ค๊ณ„ ์ „๋žต์„ ์œ ํ˜• ๋ณ„๋กœ ์ž์„ธํ•˜๊ฒŒ ์ •๋ฆฌํ•˜์—ฌ ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

์‚ญ์ œ ์ „๋žต(hard delete / soft delete), ๋ธ”๋ž™๋ฆฌ์ŠคํŠธ ๊ธฐ๋ฐ˜ ์ฐจ๋‹จ, ์ƒํƒœ ๊ด€๋ฆฌ ์ „๋žต, ๋ฉ€ํ‹ฐ ํ…Œ๋„Œ์‹œ ์„ค๊ณ„, ์ด๋ ฅ ๊ด€๋ฆฌ ์ „๋žต(SCD Type 1/2/4), ๋™์‹œ์„ฑ ์ œ์–ด ์ „๋žต(๋น„๊ด€์  ๋ฝ / ๋‚™๊ด€์  ๋ฝ) ๋“ฑ

๐Ÿ’โ€โ™‚ ๋ชฉ์ฐจ ์†Œ๊ฐœ

1. ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„์— ๋Œ€ํ•œ ์ดํ•ด

  • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„์˜ ์ค‘์š”์„ฑ๊ณผ ์ฃผ์š” ๊ณผ์ •์— ๋Œ€ํ•ด ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

2. ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„ ๊ธฐ๋ณธ

  • ๊ธฐ๋ณธํ‚ค, ์™ธ๋ž˜ํ‚ค, ์ •๊ทœํ™”/๋น„์ •๊ทœํ™”, ์ธ๋ฑ์Šค, UNIQUE ์ œ์•ฝ ๋“ฑ

  • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„์— ํ•„์š”ํ•œ ํ•ต์‹ฌ ๊ฐœ๋…์„ ์ž์„ธํ•˜๊ฒŒ ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

3. ๋‹ค์–‘ํ•œ ๊ด€๊ณ„ ํ‘œํ˜„

  • ๊ธฐ๋ณธ ๊ด€๊ณ„(์ผ๋Œ€์ผ, ๋‹ค๋Œ€์ผ, ๋‹ค๋Œ€๋‹ค), ์ž๊ธฐ์ฐธ์กฐ ๊ด€๊ณ„, ๊ด€๊ณ„ ์—”ํ„ฐํ‹ฐ, ์Šˆํผํƒ€์ž…/์„œ๋ธŒํƒ€์ž… ๋“ฑ

  • ์—”ํ„ฐํ‹ฐ ๊ฐ„์˜ ๋ณต์žกํ•˜๊ณ  ๋‹ค์–‘๊ด€ ๊ด€๊ณ„๋ฅผ ํ‘œํ˜„ํ•˜๋Š” ๋ฐฉ๋ฒ•์„ ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

4. ์‹ค์ „! ์„ค๊ณ„ ์ „๋žต โญ

  • ์‚ญ์ œ ์ „๋žต(hard delete / soft delete), ๋ธ”๋ž™๋ฆฌ์ŠคํŠธ ๊ธฐ๋ฐ˜ ์ฐจ๋‹จ, ์ƒํƒœ ๊ด€๋ฆฌ ์ „๋žต, ๋ฉ€ํ‹ฐ ํ…Œ๋„Œ์‹œ ์„ค๊ณ„, ์ด๋ ฅ ๊ด€๋ฆฌ ์ „๋žต(SCD Type 1/2/4), ๋™์‹œ์„ฑ ์ œ์–ด ์ „๋žต(๋น„๊ด€์  ๋ฝ / ๋‚™๊ด€์  ๋ฝ) ๋“ฑ

  • ์ž์ฃผ ์‚ฌ์šฉ๋˜๋Š” ํ•ต์‹ฌ ์„ค๊ณ„ ์ „๋žต์„ ์œ ํ˜• ๋ณ„๋กœ ์ž์„ธํ•˜๊ฒŒ ์ •๋ฆฌํ•˜์—ฌ ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

  • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„ ๊ฟ€ํŒ๊ณผ ์‹ค๋ฌด์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๋‹ค์–‘ํ•œ ํ…Œํฌ๋‹‰์„ ์ง‘์ค‘์ ์œผ๋กœ ๋ฐฐ์›๋‹ˆ๋‹ค.

5. ํ…Œ์ด๋ธ” ์„ค๊ณ„ ์‹ค์Šต

  • e-commerce ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์„ค๊ณ„ํ•˜๋ฉฐ, ๋ฐฐ์šด ๋‚ด์šฉ์„ ์ด์ •๋ฆฌํ•ฉ๋‹ˆ๋‹ค.

  • ๋‹ค์–‘ํ•œ ์ด๋ก ์„ ๋…น์—ฌ๋‚ธ ์‹ค์Šต ํ”„๋กœ์ ํŠธ๋ฅผ ํ†ตํ•ด ์‹ค์ „ ๊ฐ๊ฐ์„ ๋Œ์–ด์˜ฌ๋ฆฝ๋‹ˆ๋‹ค.

์ˆ˜๊ฐ• ์ „ ์ฐธ๊ณ  ์‚ฌํ•ญ

์‹ค์Šต ํ™˜๊ฒฝ

  • ์šด์˜ ์ฒด์ œ ๋ฐ ๋ฒ„์ „(OS): Windows, macOS ๋ชจ๋‘ ์‹ค์Šต์ด ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค.

  • ์‚ฌ์šฉ ๋„๊ตฌ: MySQL, MySQL Workbench


ํ•™์Šต ์ž๋ฃŒ

  • 1000 ํŽ˜์ด์ง€ ๋ถ„๋Ÿ‰์˜ ์ƒ์„ธํ•œ PPT ์ œ๊ณต

  • ๊ฐ•์˜ ์ฝ”๋“œ ์ œ๊ณต(SQL)

์„ ์ˆ˜ ์ง€์‹ ๋ฐ ์œ ์˜์‚ฌํ•ญ

  • SQL ์–ธ์–ด์— ๋Œ€ํ•œ ๊ธฐ์ดˆ ์ง€์‹์ด ํ•„์š”ํ•ฉ๋‹ˆ๋‹ค.

  • ์งˆ๋ฌธ์— ๋Œ€ํ•œ ๋น ๋ฅธ ๋‹ต๋ณ€(ํ‰๊ท  3์‹œ๊ฐ„ ์ด๋‚ด)์„ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค.

Recommended for
these people

Who is this course right for?

  • Those who want to solidly learn the fundamental concepts of databases

  • Those who want to learn database design methods that can be immediately applied to practical work

  • Those who are curious about database design methods based on logical theory

Need to know before starting?

  • Basic SQL

Hello
This is qu3vipon

3,002

Learners

236

Reviews

142

Answers

4.8

Rating

7

Courses

  • Backend Developer

     

    • (Former) Toss Securities NoOps Team

    • (Former) Asleep Sleep Routine Development

    • (Former) ABLY Ad Business Team

    • PyCon Korea 21/22/23 Speaker

  • Lectures

    • Oz Coding School Bootcamp Instructor

      (Python, Django, FastAPI, Database, AWS)

    • Sparta Coding Club Online Tutor (AI Track)

    • Multicampus Instructor (SQL, Database)

  • Certifications and Awards

    • AWS 2023 StartUp Security GameDay Korea 1st Place

    • 3x AWS Certified

      • AWS Certified Database โ€“ Specialty

      • AWS Certified Solutions Architect - Associate

      • AWS Certified Developer - Associate

    • CKAD(Certified Kubernetes Application Developer)

  • Blog: qu3vipon.com

  • GitHub: github.com/qu3vipon

  • Publications

More

Curriculum

All

58 lectures โˆ™ (7hr 4min)

Published: 
Last updated: 

Reviews

All

13 reviews

4.9

13 reviews

  • jh558920023696๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    jh558920023696

    Reviews 2

    โˆ™

    Average Rating 5.0

    5

    33% enrolled

    This was exactly the lecture I needed most right now. The explanations were thorough and detailed, yet easy to understand, and I was able to clearly grasp what aspects to carefully consider when designing databases and which areas require overhead considerations.

    • qu3vipon
      Instructor

      I'm glad the course was helpful for you! As you mentioned, DB design is particularly important in balancing structural consistency and performance. If you have any questions or difficulties during your learning process in the future, please feel free to ask. Thank you for the review :D

  • kisty๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    kisty

    Reviews 15

    โˆ™

    Average Rating 4.7

    5

    100% enrolled

    I completed the entire course and there were many parts about databases that I didn't know, but it was a great opportunity to learn a lot! I learned well!!

    • qu3vipon
      Instructor

      Thank you for your hard work completing the course all the way to the end! I'm really happy to hear that you learned new content through the lectures. I hope this course will be a great help when you work with databases in the future. Thank you for the review :D

  • damuri15065๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    damuri15065

    Reviews 20

    โˆ™

    Average Rating 5.0

    5

    86% enrolled

    The course content is substantial and excellent. I thought it would be a modeling course since it's called database design, but I think this is the first time I've studied practical design techniques. The explanations of indexes and concurrency control from a DB perspective seem to have been very helpful. Thank you, and I hope you have a happy new year.

    • qu3vipon
      Instructor

      I'm glad I could help! Thank you for the kind review. Have a great year~!!!

  • kwondy743910๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    kwondy743910

    Reviews 7

    โˆ™

    Average Rating 5.0

    5

    100% enrolled

    I've always relied on experience and intuition when designing tables, but this opportunity to encounter systematically organized content has been incredibly helpful!! As the vague concepts became clearer, I gained confidence and feel like I'll be able to approach actual design work with much more certainty in the future. Thank you for the great lecture!

    • qu3vipon
      Instructor

      I'm so proud to hear that the lecture content was helpful to you. I'll be cheering you on so you can continue developing with confidence!

  • dt100027440๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    dt100027440

    Reviews 3

    โˆ™

    Average Rating 5.0

    5

    100% enrolled

    I took the lectures for about an hour a day and completed the entire course after 7 days of immersive study. First of all, the instructor's voice and pronunciation are so good that it felt like being taught comfortably right by my side, which made the learning experience great. The responses to questions were very fast, and I was able to learn various ways to handle databases in practice. Above all, I loved that the review happened naturally because there was time for hands-on practice together after the theory! I'll be waiting for the next part on performance! Please produce it quickly!!

    • qu3vipon
      Instructor

      Hello. Thank you so much for your kind and detailed review. I am truly happy to see that you studied consistently and completed the entire course. Hearing that you found the lectures easy to follow makes all the preparation feel very rewarding. I will try to prepare the follow-up course as quickly as possible. Thank you once again!!

Similar courses

Explore other courses in the same field!