Hands-on! Introduction to FastAPI
qu3vipon
Learn how to use FastAPI that can be applied directly to real-world practice!
Basic
Python, SQLAlchemy, ORM
Learn practical strategies for designing efficient and scalable database structures that accurately reflect the complex requirements of real-world scenarios.
331 learners
Level Basic
Course period Unlimited
Reviews from Early Learners
5.0
닭이된기아
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
도윤
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
우주
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.
Core Concepts and Practical Know-how of Database Design All at Once
Concrete Case-Based Database Design Methods
Efficient and Scalable Data Modeling Strategies
실무에서 자주 사용되는 테이블 설계 전략과 패턴 집중 학습 🚀
감이 아니라 논리적인 이론을 기반으로 데이터베이스를 설계하는 방법 ⭐
무작정 따라 하는 것이 아니라, 원리를 이해하며 배우는 강의 ✅
데이터베이스 설계의 핵심 개념과 다양한 실전 설계 전략을 다룹니다.
기본키, 외래키, 정규화/비정규화, 인덱스에 대한 깊이 있는 상세한 설명
엔터티 간의 복잡하고 다양관 관계를 표현하는 방법
실전에서 자주 사용되는 설계 전략을 유형 별로 정리하여 체계적으로 학습
마무리로 e-commerce 설계 실전 프로젝트까지!
초보자도 쉽게 이해할 수 있도록 다양한 자료를 활용해 배경지식과 심화 개념까지 폭넓게 다룹니다. 온/오프라인 부트캠프 강의 경험을 통해 아직 프로그래밍이 낯선 초보자들에게 눈높이 강의와 설명을 제공합니다.
다양한 실무 예제를 활용해 단순히 이론만 학습하지 않고, MySQL과 MySQL Workbench를 사용하여 이론으로 배운 내용을 곧바로 실습하여 실전 감각을 끌어올립니다.
자주 사용되는 핵심 설계 전략을 유형 별로 자세하게 정리하여 학습합니다.
삭제 전략(hard delete / soft delete), 블랙리스트 기반 차단, 상태 관리 전략, 멀티 테넌시 설계, 이력 관리 전략(SCD Type 1/2/4), 동시성 제어 전략(비관적 락 / 낙관적 락) 등
데이터베이스 설계의 중요성과 주요 과정에 대해 학습합니다.
기본키, 외래키, 정규화/비정규화, 인덱스, UNIQUE 제약 등
데이터베이스 설계에 필요한 핵심 개념을 자세하게 학습합니다.
기본 관계(일대일, 다대일, 다대다), 자기참조 관계, 관계 엔터티, 슈퍼타입/서브타입 등
엔터티 간의 복잡하고 다양관 관계를 표현하는 방법을 학습합니다.
삭제 전략(hard delete / soft delete), 블랙리스트 기반 차단, 상태 관리 전략, 멀티 테넌시 설계, 이력 관리 전략(SCD Type 1/2/4), 동시성 제어 전략(비관적 락 / 낙관적 락) 등
자주 사용되는 핵심 설계 전략을 유형 별로 자세하게 정리하여 학습합니다.
데이터베이스 설계 꿀팁과 실무에서 사용하는 다양한 테크닉을 집중적으로 배웁니다.
e-commerce 데이터베이스를 설계하며, 배운 내용을 총정리합니다.
다양한 이론을 녹여낸 실습 프로젝트를 통해 실전 감각을 끌어올립니다.
운영 체제 및 버전(OS): Windows, macOS 모두 실습이 가능합니다.
사용 도구: MySQL, MySQL Workbench
1000 페이지 분량의 상세한 PPT 제공
강의 코드 제공(SQL)
SQL 언어에 대한 기초 지식이 필요합니다.
질문에 대한 빠른 답변(평균 3시간 이내)을 제공합니다.
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
2,983
Learners
235
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
All
58 lectures ∙ (7hr 4min)
12. Normalization
12:17
13. Denormalization
08:25
15. Foreign Key
14:03
18. Index Scan
06:49
22. Selectivity
05:50
24. Covering Index
03:22
All
13 reviews
4.9
13 reviews
Reviews 20
∙
Average Rating 5.0
5
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.
I'm glad I could help! Thank you for the kind review. Have a great year~!!!
Reviews 3
∙
Average Rating 5.0
5
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!!
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!!
Reviews 15
∙
Average Rating 4.7
5
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!!
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
Reviews 7
∙
Average Rating 5.0
5
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!
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!
Reviews 2
∙
Average Rating 5.0
5
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.
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
Check out other courses by the instructor!
Explore other courses in the same field!