[Web Development Full Stack Course] Learn Database Basics through Netflix and Carrot Market Analysis
This lecture is a lecture on database basics in the [Web Development Full Stack Course] lecture series for training full-stack web developers.
This lecture is a process of understanding database design while analyzing Netflix and Carrot Market. It is a basic lecture where you can learn basic database design principles and SQL.
What about a database of successful services? Learn from Netflix and Carrot Market Analysis ✨
✅ This lecture is part of the [Full-Stack Web Developer Roadmap] series.
This lecture is part of the [Web Development Full Stack Course] lecture series, which is designed to train full-stack web developers. It covers the basics of databases.
The Web Development Full Stack Course covers the entire process of full stack web development, from HTML&CSS → Vanilla JavaScript → Bootstrap → Vue.js → Database → Node.js → Portfolio.
By completing this full-stack web development course, you'll learn not only the fundamentals of web development, but also practical skills that can be applied immediately in the workplace.
Before taking this course, we recommend taking the following courses in order: [Web Development Full Stack Course] HTML&CSS → [Web Development Full Stack Course] Vanilla JavaScript → [Web Development Full Stack Course] Bootstrap → [Web Development Full Stack Course] Vue.js.
Database, how should I learn it?
The best way to understand databases is to analyze successful services you already use.
The best way to learn about databases (DB) is to carefully examine the services we already know and use. Imagine what data is visible on each screen, and what data might be collected behind the scenes.
This lecture will analyze the main screens of Netflix and Carrot Market, services you are all too familiar with, one by one, and analyze what data is visible and what hidden data is invisible. By doing so, you will think about what kind of data a good service should contain and how to contain it .
After completing this course, you will be able to design a database for the application you want to develop .
Netflix ERD designed by a novice developer who took this course
What do you learn?
✅ Install MySQL and learn how to use MySQLWorkbench.
✅ Learn what a database is.
✅ Learn basic SQL syntax .
✅ Understand database design principles by analyzing Netflix .
✅ Understand database design principles by analyzing Carrot Market .
Understanding the DB structure based on analysis of Carrot Market services
Understanding the DB structure based on Netflix service analysis
Check your player knowledge!
Before taking this course, we recommend taking [Web Development Full Stack Course] HTML&CSS → [Web Development Full Stack Course] Vanilla JavaScript → [Web Development Full Stack Course] Bootstrap → [Web Development Full Stack Course] Vue.js.
The person who created this course is Who could it be?
Developer's Dignity
A 24-year software developer who wants to make a positive impact on the world through software technology. I love sharing my knowledge and always enjoy learning new skills.
I've worked as a consultant and developer, building ERP systems for over 60 global companies, both domestically and internationally. I also have experience selling software I developed myself to leading companies both domestically and internationally. I'm also the CEO of an IT startup.
Working not only as a developer, but also as a UX consultant and occasionally as a business consultant, I've gained extensive experience in all aspects of application and service development, from planning to development. Now, with over 20 years of practical experience, I'm dedicated to sharing my knowledge with my juniors, with a strong sense of mission to impart truly essential skills and truly relevant knowledge.
Want to know more?
We provide over 200 useful lecture videos through the YouTube channel ' Developer's Dignity '.
[Web Development Full-Stack Course] Series Collection
Recommended for these people
Who is this course right for?
Anyone who wants to increase their understanding of databases
People who want to design their own database
People who want to learn basic SQL
Hello This is
11,041
Learners
256
Reviews
152
Answers
4.9
Rating
8
Courses
소프트웨어 기술을 통해 세상에 선한 영향력을 주고 싶은 24년차 소프트웨어 개발자. 지식을 나누는 것을 좋아하고 항상 새로운 기술을 익히는 것을 즐겨요.
국내외 60개가 넘는 글로벌 기업 ERP 시스템을 구축하는 컨설턴트 및 개발자로 활동하였고, 직접 개발한 소프트웨어를 국내는 물론 해외 유수의 기업에 판매를 한 경험 또한 가지고 있어요. IT스타트업 대표이사 이기도 해요.
개발자 뿐만 아니라, UX 컨설턴트로, 때로는 비즈니스 컨설턴트로 일하면서 애플리케이션과 서비스 개발 시 기획에서 개발까지 전과정에 대한 수많은 경험을 쌓았고, 이제는 20년이 넘는 실무 경험을 바탕으로 후배들에게 정말 필요한 기술, 정말 제대로 된 지식을 전달하는 사명감을 갖고 지식 나눔에 일을 하고 있어요.
There aren't many lectures on SQL design and analysis, but this was a free lecture, so I enjoyed it. The lecture content was also informative and good!