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!
This course is prepared for Beginners.
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 major books 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 the server developers.
Is computer science knowledge only for those who major in it?
Anyone can learn it, even non-majors! ✨
Database, RDBMS, SQL, normalization, ERD, Transaction... These are concepts that you absolutely must know if you want to become a web/app/server developer. Computer science majors basically have this knowledge.
Non-majors who have not studied computer science often think that majors already know something great. However, if they study step by step, non-majors can acquire specialized knowledge just as much as computer science majors. I will teach you only the core knowledge necessary for practical work.
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 contents 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 things like this 📚
Table design (ERD, normalization)
Introduction to using the workbench
Learning SQL such as CRUD, JOIN, Index, Stored Procedure, Trigger, View, etc.
Understand 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 revising our classes or updating and supplementing them through news to answer frequently asked questions from our students.
- Please study while freely asking questions related to the lecture. It will help you understand the content better!
Things to note before taking the class 📢
Practice environment
- Operating System and Version (OS): Based on Windows 11, but other operating systems are also fine.
- Tools used: MySQL 8.0.33 version, MySQL Workbench 8.0.33 version
Learning Materials
Player Knowledge and Notes
- 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 to be used. Is that true?
Yes. As long as you have space to store the data, we will teach you everything from DB installation to data manipulation.
Q. Will I really gain the same knowledge as a specialist?
You will know less than a specialist, but you can save time by not having to learn useless knowledge that a specialist learns in the field.
Q. Is it useful for backend aspirants as well?
Yes. You will use the concepts that come out here for the rest of your life. However, if you are going to specialize in DB, it is recommended that you study additional DB commands, performance tuning lectures, or books. I have summarized what you need to learn more in the last video of the lecture.
Reference) Complete roadmap for Zero Second Lecture
Q. Are there any programs I need to install in advance?
It would be a good idea to install MySQL and Excel. I will explain how to install MySQL in the course, but you can just look at 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
Students
60,866
Reviews
1,414
Rating
4.8
Courses
21
제 강의의 장점은 Q&A입니다(인프런 답변왕 2회 수상). 24시간 이내에 최대한 답변드립니다! 같이 고민한다는 느낌으로 답변 드릴게요!
https://www.zerocho.com/lecture
제로초 강의 전체 로드맵
– Node.js교과서, 코딩자율학습 제로초의 자바스크립트, Let's Get IT 자바스크립트, 타입스크립트 교과서 저자
– ZeroCho.com 운영자
– 현) 유튜브에서 ZeroCho TV로 개발 관련 방송중
– 현) 스모어톡 CTO
– 전) 오늘의픽업 CTO(카카오모빌리티에 엑싯 후 카카오모빌리티 최연소 개발파트장)
Curriculum
All
36 lectures ∙ (5hr 2min)