강의

멘토링

로드맵

BEST
Programming

/

Database

Non-majors catching up with majors - Database, SQL

If you are already a developer or want to become a developer but did not major in computer science and are weak in databases, gain lifelong knowledge with this one course!

(4.9) 27 reviews

605 learners

  • zerocho
데이터베이스
이론 중심
DBMS/RDBMS
SQL
MySQL
mysql-workbench

Reviews from Early Learners

What you will learn!

  • Database theory

  • MySQL

  • ERD

  • Normalization

  • How to use the workbench

Is there knowledge that only developers with a computer science background know?
Even non-majors can learn with this course 😎

If you've ever had these concerns, pay attention!

🫠

I want to learn the basics of databases, but the textbooks are too thick.

🤔

Even if I learn all the specialized knowledge, I don't know how to use it in practice.

🥲

Sometimes I feel embarrassed because I don't communicate well with server developers.

Is computer science knowledge only for those who majored in it?

Anyone can learn it, even non-majors! ✨

Databases, RDBMS, SQL, normalization, ERD, Transactions... These are essential concepts for anyone aspiring to become a web/app/server developer. Computer science majors are equipped with this fundamental knowledge.

Non-majors who haven't studied computer science often assume that majors already know something amazing. However, with careful study, even non-majors can acquire the same level of specialized knowledge as computer science majors. I'll teach you the essentials, focusing on practical knowledge.

If you can't answer "yes" to any of the three questions below, then join this course!

  • Do you know how member information is stored in the database?
  • Can I add/remove/modify/query data in the database?
  • Can you please ask your backend developer for a cursor-style pagination API?

I recommend this to these people 🙆‍♀️

People who are not majoring in the field but want to become web, app, or server developers

Front-end developer who doesn't know much about back-end

People who want to know only the major topics that are frequently used in practice


Lecture Features ✨

We provide lecture notes .

Questions will be answered within 48 hours !

We use MySQL , a popular database.

Learn SQL statements by visually examining the database through the workbench .

I will condense and explain only the frequently used parts from thick database books.


Learn this 📚

Table design (ERD, normalization)

Introduction to Using the Workbench

Learning SQL such as CRUD, JOIN, Index, Stored Procedure, Trigger, View, etc.

Understanding terms such as Transaction, Isolation, Replication, Sharding, and NoSQL


With two-way communication
So that you can understand better.

The great thing about my lectures is the Q&A.

  • We aim for active learning through questions and answers .
  • If you have any questions, we will respond within 48 hours.
  • We are constantly updating and supplementing our lessons with updates and news to address frequently asked questions from our students.
  • Feel free to ask questions about the lecture content while studying. This will help you understand the material better!

Things to note before taking the course 📢

Practice environment

  • Operating System and Version (OS): Based on Windows 11, but other operating systems are also acceptable.
  • Tools used: MySQL 8.0.33 version, MySQL Workbench 8.0.33 version

Learning Materials

Player Knowledge and Precautions

  • All you need is a large SSD/hard disk drive to store your data.

Expected Questions Q&A 💬

Q. I heard that the player's knowledge is sufficient for the hard drive. Is that true?

Yes. As long as you have space to store your data, we'll teach you everything from database installation to data manipulation.

Q. Will I really gain the same knowledge as a specialist?

You will know less than a major, but you will save time by not having to learn useless knowledge that a major learns.

Q. Is it useful for backend aspirants as well?

Yes. You'll use the concepts presented here for the rest of your life. However, if you plan to specialize in databases, it's recommended that you study additional DB commands and performance tuning courses or books. The final video of the course summarizes the key points you should learn.

Reference material) Complete roadmap for Zero Seconds lectures

Q. Are there any programs I need to install in advance?

It's a good idea to install MySQL and Excel. I'll explain how to install MySQL in the course, but you can just follow along with the Excel part.


Recommended for
these people

Who is this course right for?

  • For those who are not majoring in databases and want to learn database theory

  • I'm a front-end developer, but I get stuck whenever I talk about DB with a back-end developer.

  • I feel sorry for always having to ask backend developers about DB-related things.

Need to know before starting?

  • Spacious SSD/hard disk to store data

Hello
This is

65,894

Learners

1,646

Reviews

9,722

Answers

4.8

Rating

22

Courses

제 강의의 장점은 Q&A입니다(인프런 답변왕 2회 수상). 24시간 이내에 최대한 답변드립니다! 같이 고민한다는 느낌으로 답변 드릴게요!

One of the key strengths of my courses is the Q&A support. (Winner of the Inflearn Q&A King award twice) I respond to your questions within 24 hours, doing my best to help you out! You’ll feel like we’re solving the problems together.

👉ZeroCho Lectures
제로초 강의 전체 로드맵. A complete roadmap of all my courses is available here.

– Node.js교과서, 코딩자율학습 제로초의 자바스크립트, Let's Get IT 자바스크립트, 타입스크립트 교과서 저자 
ZeroCho.com 운영자
– 현) 유튜브에서 ZeroCho TV로 개발 관련 방송중 
– 현) 스모어톡 CTO 
– 전) 오늘의픽업 CTO(카카오모빌리티에 엑싯 후 카카오모빌리티 최연소 개발파트장)

  • Author of Node.js Textbook, Self-Guided JavaScript by ZeroCho, Let's Get IT JavaScript, and TypeScript Textbook

  • Operator of ZeroCho.com

  • Currently running a YouTube channel ZeroCho TV, covering development topics

  • CTO at SmoreTalk

  • Former CTO at Today Pickup (acquired by Kakao Mobility, where I became the youngest lead developer)

Curriculum

All

36 lectures ∙ (5hr 2min)

Published: 
Last updated: 

Reviews

All

27 reviews

4.9

27 reviews

  • dmsgk2323님의 프로필 이미지
    dmsgk2323

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    비전공자인데 너무 좋은 강의네요 감사합니다!

    • 제로마운틴님의 프로필 이미지
      제로마운틴

      Reviews 13

      Average Rating 5.0

      5

      100% enrolled

      저는 백엔드 개발자분들과 협업할때, DB 용어로 설명하시는 경우가 많았습니다. 그때마다 이해했다고 말은 하지만 뒤에서 다시 구글링해서 그 의미를 찾아서 확인한 경험이 많았죠. 하지만, 이 강의를 듣고 백엔드 개발자 분들과 DB 용어로 무리없이 커뮤니케이션 할 수 있게 되었습니다. 저와 같은 경험을 하신 프론트엔드 개발자 혹은 비전공자 개발자 분이시라면 이 강의를 적극 추천합니다. 좋은 강의 만들어주셔서 감사합니다!

      • 레몬트리님의 프로필 이미지
        레몬트리

        Reviews 5

        Average Rating 5.0

        5

        100% enrolled

        현재 프로젝트에서 데이터베이스 맡게 되어서 주말동안 급하게 들었는데 도움이 많이 되었어요!! 감사합니다. 중간 중간에 실제로 따라쳐보니 손에도 많이 익었고 이제는 mysql은 자신감 가지고 데이터베이스 생성할 수 있을 것 같아요

        • 박한일님의 프로필 이미지
          박한일

          Reviews 3

          Average Rating 5.0

          5

          31% enrolled

          • nonoa846님의 프로필 이미지
            nonoa846

            Reviews 29

            Average Rating 5.0

            5

            100% enrolled

            너무 좋았던 강의 엿습니다 명불허전 이름값을 하네요 자료구조도 들어보겟습니다 ^^

            $34.10

            zerocho's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!