강의

멘토링

커뮤니티

Programming

/

Database

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

303 learners

Level Basic

Course period Unlimited

  • qu3vipon
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

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

2,809

Learners

198

Reviews

140

Answers

4.8

Rating

6

Courses

  • Backend Developer

    (Former) Toss Securities NoOps Team (Former) Asleep Sleep Routine Development (Former) ABLY Ad Business Team PyCon Korea 21/22/23 Speaker Lecturer at Oz Coding School Bootcamp (Python, Django, FastAPI, Database,

    • (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)

  • Tech Blog: qu3vipon.com

  • GitHub: github.com/qu3vipon

Curriculum

All

58 lectures ∙ (7hr 4min)

Published: 
Last updated: 

Reviews

All

9 reviews

4.9

9 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

  • mindoli님의 프로필 이미지
    mindoli

    Reviews 10

    Average Rating 5.0

    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

  • 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!

  • damuri15065님의 프로필 이미지
    damuri15065

    Reviews 16

    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~!!!

  • paulmoon008308님의 프로필 이미지
    paulmoon008308

    Reviews 111

    Average Rating 4.9

    5

    9% enrolled

    $59.40

    qu3vipon's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!