[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.
It was a very helpful lecture. I can't forget a single word the instructor said.
5.0
트림아재
60% enrolled
Even though it was a free lecture, it was very helpful. Thank you.
5.0
wonE
100% enrolled
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!
What you will gain after the course
Understanding Databases
SQL
Imagine a Netflix database
Imagine a carrot market database
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,191
Learners
261
Reviews
152
Answers
4.9
Rating
8
Courses
A 24-year software developer who wants to make a positive impact on the world through software technology. I love sharing knowledge and always enjoy learning new technologies.
I have worked as a consultant and developer building ERP systems for over 60 global companies both domestically and abroad, and I also have experience selling software I developed myself to leading companies worldwide. I am also the CEO of an IT startup.
Working not only as a developer but also as a UX consultant and business consultant, I have accumulated extensive experience across the entire process of application and service development, from planning to implementation. Now, based on over 20 years of practical experience, I am dedicated to sharing knowledge with a sense of mission to pass on the essential skills and authentic expertise that junior developers truly need.
I am providing over 200 useful lecture videos through the YouTube channel 'Quality of Developer'.
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!