inflearn logo
inflearn logo

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

636 learners

Level Beginner

Course period Unlimited

DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
MySQL
MySQL
mysql-workbench
mysql-workbench
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
MySQL
MySQL
mysql-workbench
mysql-workbench

Reviews from Early Learners

Reviews from Early Learners

4.9

5.0

dmsgk2323

100% enrolled

I'm not a major, but this is a great lecture. Thank you!

5.0

제로마운틴

100% enrolled

When I worked with backend developers, they often explained things using DB terms. Every time, I said I understood, but I would go back and Google the meaning to make sure. However, after taking this course, I was able to communicate with backend developers using DB terms without any problems. If you are a frontend developer or non-major developer who has had a similar experience, I highly recommend this course. Thank you for creating such a great course!

5.0

레몬트리

100% enrolled

I was in charge of the database for my current project, so I listened to it in a hurry over the weekend, and it was very helpful!! Thank you. I actually followed along here and there, and it became more familiar to my hands, and now I think I can create a database with confidence in MySQL.

What you will gain after the course

  • 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 zerocho

67,539

Learners

1,733

Reviews

9,764

Answers

4.8

Rating

25

Courses

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! I’ll answer your questions with the mindset that we are tackling the problems together!

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
ZeroCho's full lecture roadmap. A complete roadmap of all my courses is available here.

– Author of Node.js Textbook, Self-Guided JavaScript by ZeroCho, Let's Get IT JavaScript, and TypeScript Textbook
ZeroCho.com Operator
– Currently) Broadcasting development-related content on ZeroCho TV via YouTube
– Formerly) Smoretalk CTO
– Formerly) CTO of Today's Pickup (Youngest Development Team Lead at Kakao Mobility after exit to Kakao Mobility)

  • 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

  • Former CTO at SmoreTalk

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

More

Reviews

All

27 reviews

4.9

27 reviews

  • dmsgk23234260님의 프로필 이미지
    dmsgk23234260

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    I'm not a major, but this is a great lecture. Thank you!

    • han122037님의 프로필 이미지
      han122037

      Reviews 3

      Average Rating 5.0

      5

      31% enrolled

      • nonoa8467519님의 프로필 이미지
        nonoa8467519

        Reviews 31

        Average Rating 5.0

        5

        100% enrolled

        I just saw a really good lecture. It lives up to its reputation. I'll also look into data structures ^^

        • dev0mountain님의 프로필 이미지
          dev0mountain

          Reviews 13

          Average Rating 5.0

          5

          100% enrolled

          When I worked with backend developers, they often explained things using DB terms. Every time, I said I understood, but I would go back and Google the meaning to make sure. However, after taking this course, I was able to communicate with backend developers using DB terms without any problems. If you are a frontend developer or non-major developer who has had a similar experience, I highly recommend this course. Thank you for creating such a great course!

          • lemontree님의 프로필 이미지
            lemontree

            Reviews 5

            Average Rating 5.0

            5

            100% enrolled

            I was in charge of the database for my current project, so I listened to it in a hurry over the weekend, and it was very helpful!! Thank you. I actually followed along here and there, and it became more familiar to my hands, and now I think I can create a database with confidence in MySQL.

            zerocho's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            $34.10