강의

멘토링

커뮤니티

Programming

/

Database

[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.

(5.0) 18 reviews

2,749 learners

Level Beginner

Course period Unlimited

  • realprogrammers
DBMS/RDBMS
DBMS/RDBMS
MySQL
MySQL
SQL
SQL
DBMS/RDBMS
DBMS/RDBMS
MySQL
MySQL
SQL
SQL
Thumbnail

Reviews from Early Learners

Reviews from Early Learners

5.0

5.0

일코

100% enrolled

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?

[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.

  • (Current) CEO of The Great Co., Ltd.
  • (Current) CTO of SunSure Co., Ltd.
  • (Current) CTO of ReturnValue Co., Ltd.
  • (Current) Technical Advisory Committee Member at Pan-Impact Korea

 

Email - seungwon.go@gmail.com

Curriculum

All

5 lectures ∙ (6hr 34min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

18 reviews

5.0

18 reviews

  • ilco님의 프로필 이미지
    ilco

    Reviews 22

    Average Rating 5.0

    5

    100% enrolled

    It was a very helpful lecture. I can't forget a single word the instructor said.

    • dnqkr18님의 프로필 이미지
      dnqkr18

      Reviews 10

      Average Rating 5.0

      5

      60% enrolled

      Even though it was a free lecture, it was very helpful. Thank you.

      • yuiky3216701님의 프로필 이미지
        yuiky3216701

        Reviews 40

        Average Rating 4.8

        5

        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!

        • seungsu8848님의 프로필 이미지
          seungsu8848

          Reviews 4

          Average Rating 5.0

          5

          100% enrolled

          I was curious about analyzing the Carrot Market service, so I immediately took the course. It's awesome. You should definitely watch it.

          • hyongsu44님의 프로필 이미지
            hyongsu44

            Reviews 868

            Average Rating 5.0

            5

            100% enrolled

            Thank you for the lecture.

            Free

            realprogrammers's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!