강의

멘토링

커뮤니티

BEST
Programming

/

Database

Real MySQL Season 1 - Part 1

You can learn about the core functions of MySQL and how to effectively use them in your work. You can also gain a new understanding of important parts that you have been using for a long time and have overlooked, and gain in-depth database knowledge.

(4.8) 53 reviews

1,182 learners

Level Basic

Course period Unlimited

쿼리최적화
쿼리최적화
DBA
DBA
개발도서
개발도서
고급쿼리
고급쿼리
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
backend
backend
query-tuning
query-tuning
mysql-query
mysql-query
쿼리최적화
쿼리최적화
DBA
DBA
개발도서
개발도서
고급쿼리
고급쿼리
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
backend
backend
query-tuning
query-tuning
mysql-query
mysql-query

Reviews from Early Learners

Reviews from Early Learners

4.8

5.0

이영준

62% enrolled

I recommend this course to those who have some knowledge of MySQL, and for them, this is a course that can make the basics and advanced courses even more solid. I was impressed by this, so I will leave a review of the course in the form of a 6-line poem by MySQL. Ma: This is a course that finally allows you to understand the database. E: Even if an error occurs, it is explained in detail so that you can solve it well. Q: QNA is also kind, L: This course gave me the confidence to become a lit developer. Thank you~~

5.0

lucas

100% enrolled

It says from beginner to advanced.. It seems to be advanced.. ----------------------------------- I left the comment vaguely.. The content says 'MySQL Utilization Guide from Basics to Advanced for Developers', but I omitted the 'For Developers' part and took the course thinking it was from Basics to Advanced~, and as you said, I think developers know. I left the comment strangely for no reason because I thought that if a non-developer like me and a MySQL beginner took the course after reading the article from Basics to Advanced, they might have difficulty. I will try to build up some basics and take the course again. Thank you!

5.0

asd1324 asd

100% enrolled

It's a bit monotonous, but the content of the class is so rich and useful that it was fun to listen to. You can take the class even if you haven't read Real MySQL 8.0.

What you will gain after the course

  • How to use MySQL 8.0 new features

  • Data Model and Query Optimization

  • How to use a database that can be applied directly to your work

  • Acquire basic database concepts and in-depth knowledge

Korea's No. 1 MySQL book
The first lecture from the authors of ⟪Real MySQL 8.0⟫!

Real MySQL Lecture Season 1 - Part 1
Real MySQL Lecture Season 1 - Part 2

The Real MySQL series is a steady-selling MySQL DBMS book series with over 30,000 copies sold. The book ⟪Real MySQL 8.0⟫ contains in-depth information about the internal structure, optimization, and management methods of the MySQL database.

The ⟪Real MySQL Season 1⟫ lecture presented this time provides practical content that will help developers and DBAs using MySQL solve various concerns and problems they face by condensing the field experience and know-how that cannot be fully included in the book.

Contains practical experience and expert insight ,
Selected lecture topics

❝ 24 MySQL Essential Knowledge Every Developer Should Know ❞

⟪Real MySQL Season 1⟫ consists of Part 1 and Part 2, which can be taken together through the roadmap.

Detail page banner (960x200) (2)

Part 1 (Current Lecture)

  1. CHAR vs. VARCHAR

  2. VARCHAR vs. TEXT

  3. COUNT(*) & COUNT(DISTINCT) tuning

  4. Writing a paging query

  5. Stored Function

  6. Lateral Derived Table

  7. SELECT ... FOR UPDATE

  8. Generated columns and function-based indexes

  9. Error handling

  10. LEFT JOIN Precautions and Tuning

  11. Prepared Statement


  12. Improved readability of SQL statements

Part 2

  1. Collation

  2. Precautions for using UUID


  3. Full-Scan Query Patterns and Tuning

  4. COUNT(*) vs COUNT(column)

  5. SELECT ... FOR UPDATE
    [ NOWAIT | SKIP LOCKED ]

  6. UNION vs. UNION ALL

  7. Using JSON type

  8. deadlock

  9. JOIN UPDATE & JOIN DELETE

  10. Connection Management

  11. Table Partitioning

  12. DBMS Utilization (Batch Processing Precautions)


From beginners to experienced professionals ,
In-depth lecture content for everyone

❝ Focus on ⟪Why⟫ rather than ❞

Many developers ask questions like, "How did you make it?" or "How should I make it?"
"How" solutions only provide solutions for specific use cases, and any slight variation in those use cases often leads to a repeat of the "How" question. In other words, "How" often provides only a fragmented solution, not fundamental knowledge or principles applicable to a wide range of scenarios.
So, even though most problems are solved with a "how" question, they eventually lead us to the question "why."

The "Real MySQL Season 1" course provides a deeper understanding by analyzing the root cause of problems as well as providing solutions. Rather than simply explaining the "how," we strive to convey the "why" behind the "how." This will help you acquire fundamental knowledge and principles applicable to a variety of situations. This course will help you find better solutions and effectively address a variety of issues.

People like this, please pay attention!

📌
MySQL core features
How to best use it and
Anyone interested in improving performance

📌
Occurring in the field
Those who want to find solutions to various problem situations

📌
In-depth knowledge of using and operating MySQL
Those who want to get it

"We provide valuable learning experiences through differentiated lectures."

Comprehensive guide to key features

  • This comprehensive guide covers MySQL's key features and the new features in Version 8.0, from overviews to usage methods and precautions. You'll gain a thorough understanding of MySQL's features and be able to effectively apply them in your work.

Practical problem-solving strategies

  • We provide detailed explanations and effective solutions for various problem situations you may encounter while using MySQL. You'll learn practical strategies that can be applied immediately in your work.

In-depth analysis by experts

  • We provide expert, in-depth insights into areas often overlooked. We'll open a new perspective on database management and optimization.

Instructor Introduction

Lee Seong-wook

Baek Eun Bin

  • personal history

    • Naver & Line & Kakao DB Team

    • (Current) Carrot Market Infrastructure Room DB Team

  • Books

    • Real MySQL 8.0 Revised Edition Volumes 1 and 2

    • Real MongoDB

    • Real MariaDB

    • Real MySQL

  • personal history

    • Kakao DB Team

    • (Current) Carrot Market Infrastructure Room DB Team

  • Books

    • Real MySQL 8.0 Revised Edition Volumes 1 and 2



Q&A

Q. When taking the ⟪Real MySQL Season 1⟫ course, do I need to purchase the ⟪Real MySQL 8.0⟫ book in advance?

No. ⟪Real MySQL 8.0⟫ There is no particular problem in taking this course even if you do not have the book.
Just ⟪Real MySQL 8.0⟫ If you purchase the book and study it alongside the lectures, I expect it will be of great help in broadening your understanding of the lecture content. 🙂

Q. Do I have to take Part 1 and Part 2 of the ⟪Real MySQL Season 1⟫ course in order?

No. In the ⟪Real MySQL Season 1⟫ lecture, the 24 episodes are divided into Part 1 and Part 2 to divide them into 12 each, but there is no separate order or difference in importance.

As you can see from the course curriculum, each lecture is comprised of independent topics. Therefore, you can select the lecture topic of your choice and take it first, without any particular order.

I highly recommend taking both Parts 1 and 2, as they cover essential techniques and considerations for projects using MySQL. 🙌

Q. Can the content learned in this lecture be applied to AWS Aurora MySQL?

AWS's Aurora MySQL server is a DBMS server built on the MySQL community version, so many features are compatible.
However, you should be aware that there are significant differences between AWS Aurora MySQL and the community version of MySQL Server in some features, including storage architecture.
This lecture doesn't cover much about how MySQL Community Edition and AWS Aurora MySQL Server work differently, but we've mentioned the differences separately, so please keep those differences in mind when using them. 👍

Detail page banner (960x200)

Recommended for
these people

Who is this course right for?

  • For those who want to use MySQL's core features in practice

  • For those who want to deeply understand database structure and performance

  • For those interested in writing and optimizing advanced queries.

  • For those of you who are curious about how MySQL is used in the field

Need to know before starting?

  • SQL

Hello
This is

2,194

Learners

75

Reviews

43

Answers

4.8

Rating

2

Courses

경력

  • CRM/DW 및 SI 프로젝트 수행

  • 네이버 & 라인 DB팀 근무

  • 카카오 DB팀 근무

  • (현) 당근마켓 인프라실 DB팀 팀장

 

저서

  • Real MySQL 8.0 개정판 1권/2권

  • Real MongoDB

  • Real MariaDB

  • Real MySQL

  • MySQL 성능 최적화

Curriculum

All

13 lectures ∙ (3hr 29min)

Published: 
Last updated: 

Reviews

All

53 reviews

4.8

53 reviews

  • dldudwns720806님의 프로필 이미지
    dldudwns720806

    Reviews 14

    Average Rating 4.9

    5

    62% enrolled

    I recommend this course to those who have some knowledge of MySQL, and for them, this is a course that can make the basics and advanced courses even more solid. I was impressed by this, so I will leave a review of the course in the form of a 6-line poem by MySQL. Ma: This is a course that finally allows you to understand the database. E: Even if an error occurs, it is explained in detail so that you can solve it well. Q: QNA is also kind, L: This course gave me the confidence to become a lit developer. Thank you~~

    • lucas6996님의 프로필 이미지
      lucas6996

      Reviews 4

      Average Rating 5.0

      5

      100% enrolled

      It says from beginner to advanced.. It seems to be advanced.. ----------------------------------- I left the comment vaguely.. The content says 'MySQL Utilization Guide from Basics to Advanced for Developers', but I omitted the 'For Developers' part and took the course thinking it was from Basics to Advanced~, and as you said, I think developers know. I left the comment strangely for no reason because I thought that if a non-developer like me and a MySQL beginner took the course after reading the article from Basics to Advanced, they might have difficulty. I will try to build up some basics and take the course again. Thank you!

      • sungucklee2062
        Instructor

        Hello Lucas. Thank you for taking the video lecture. (As I mentioned in the lecture introduction) As you can see from the video lecture content, I think you will agree that the actual lecture topics are all things that developers should know basically. Each episode of the Real MySQL video lecture does not simply explain "How to avoid problems", but also explains "Why is this method problematic?" Although it is an excuse, the explanation of "Why is this method problematic?" often requires an explanation of the characteristics of the MySQL server or some internal content. Although it is an excuse, in conclusion, the topics covered in each episode are beginner-level content, but I think Lucas may have found the content difficult because of the internal explanations. When I produce the next video lecture, I will try to explain the internal content more carefully. Thank you for your valuable feedback.

    • tkaqkr1231706님의 프로필 이미지
      tkaqkr1231706

      Reviews 14

      Average Rating 5.0

      5

      77% enrolled

      • snicorpdev4037님의 프로필 이미지
        snicorpdev4037

        Reviews 3

        Average Rating 4.7

        4

        92% enrolled

        Thank you for giving me good examples of parts I didn't know about, so I understood them better.

        • seo님의 프로필 이미지
          seo

          Reviews 37

          Average Rating 5.0

          5

          92% enrolled

          $34.10

          Similar courses

          Explore other courses in the same field!