강의

멘토링

로드맵

Inflearn brand logo image
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) 15 reviews

2,688 learners

  • realprogrammers
데이터베이스
dbms/rdbms
DBMS/RDBMS
MySQL
SQL
Thumbnail

Reviews from Early Learners

What you will learn!

  • 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

10,966

Learners

248

Reviews

152

Answers

4.9

Rating

8

Courses

소프트웨어 기술을 통해 세상에 선한 영향력을 주고 싶은 24년차 소프트웨어 개발자.
지식을 나누는 것을 좋아하고 항상 새로운 기술을 익히는 것을 즐겨요.

국내외 60개가 넘는 글로벌 기업 ERP 시스템을 구축하는 컨설턴트 및 개발자로 활동하였고, 직접 개발한 소프트웨어를 국내는 물론 해외 유수의 기업에 판매를 한 경험 또한 가지고 있어요. IT스타트업 대표이사 이기도 해요.

개발자 뿐만 아니라, UX 컨설턴트로, 때로는 비즈니스 컨설턴트로 일하면서 애플리케이션과 서비스 개발 시 기획에서 개발까지 전과정에 대한 수많은 경험을 쌓았고, 이제는 20년이 넘는 실무 경험을 바탕으로 후배들에게 정말 필요한 기술, 정말 제대로 된 지식을 전달하는 사명감을 갖고 지식 나눔에 일을 하고 있어요.

 

  • (현)주식회사 더그레잇 대표이사
  • (현)주식회사 썬슈어 CTO
  • (현)주식회사 리턴밸류 CTO
  • (현)팬임팩트코리아 유한회사 기술전문위원

 

이메일 - seungwon.go@gmail.com

Curriculum

All

5 lectures ∙ (6hr 34min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

15 reviews

5.0

15 reviews

  • 일코님의 프로필 이미지
    일코

    Reviews 22

    Average Rating 5.0

    5

    100% enrolled

    큰 도움이 되는 강의였습니다. 강사님의 한 마디 한 마디 버릴 것이 없습니다.

    • 트림아재님의 프로필 이미지
      트림아재

      Reviews 9

      Average Rating 5.0

      5

      60% enrolled

      무료강의임에도 너무 유익했습니다. 감사합니다

      • wonE님의 프로필 이미지
        wonE

        Reviews 37

        Average Rating 4.8

        5

        100% enrolled

        sql설계, 분석 강의가 잘 없는데 무료 강의라니 잘 봤습니다. 강의 내용도 알차고 좋았습니다!

        • 김승수님의 프로필 이미지
          김승수

          Reviews 3

          Average Rating 5.0

          5

          100% enrolled

          당근마켓 서비스 분석하기가 궁금해서 바로 수강을 했는데 짱이네요 꼭 보세요

          • 똘똘이스머프님의 프로필 이미지
            똘똘이스머프

            Reviews 868

            Average Rating 5.0

            5

            100% enrolled

            강의 감사합니다.

            Free

            realprogrammers's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!