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) 57 reviews

1,215 learners

Level Basic

Course period Unlimited

MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
backend
backend
query-tuning
query-tuning
mysql-query
mysql-query
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
backend
backend
query-tuning
query-tuning
mysql-query
mysql-query

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

nadir

100% enrolled

Best mysql tutorial

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 sungucklee2062

2,253

Learners

81

Reviews

43

Answers

4.8

Rating

2

Courses

Experience

  • Executed CRM/DW and SI projects

  • Worked in the Naver & LINE DB Team

  • Worked at Kakao DB Team

  • (Current) Head of DB Team, Infrastructure Department at Karrot (Daangn Market)

Publications

  • Real MySQL 8.0 Revised Edition Volume 1/Volume 2

  • Real MongoDB

  • Real MariaDB

  • Real MySQL

  • MySQL Performance Optimization

More

Co-instructor

Reviews

All

57 reviews

4.8

57 reviews

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

  • nadir님의 프로필 이미지
    nadir

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    Best mysql tutorial

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

      • tkaqkr1231706님의 프로필 이미지
        tkaqkr1231706

        Reviews 14

        Average Rating 5.0

        5

        77% enrolled

        • nataek2159님의 프로필 이미지
          nataek2159

          Reviews 15

          Average Rating 3.3

          3

          100% enrolled

          I wanted to write several times while listening..but I thought I should listen to it all and write it anyway, so I'm writing it after completing Season 1-Part 1. 1. The lecture description says "From beginners ~", but please think carefully about whether it is really possible for beginners. 1) For example, if it is for beginners, wouldn't it be more appropriate to teach how to write a Stored Function rather than what DETERMINISTIC is? If not, the explanation of the lecture is wrong. The part about "From beginners" should be omitted..I think you defined beginners too highly. 2. The lecture is conducted only with PPT from the beginning to the end..Is there not a single screen that actually practices SQL? Is there not a single content that prepares a database and table for practice and runs it together? If it is difficult to do it on the screen, wouldn't it be better to provide a database, table, data, etc. for later review? I've been listening to many lectures on Inflearn, but this is the first time I've been to a lecture that only uses the PPT screen. It's not a free lecture, so I think this is too much. There must be a big difference between actually doing it and just watching and listening. This part seems too much. 3. I think both of you need to practice your lectures. The woman reads the script so fast. Even if someone were to read the manuscript for you, you wouldn't know. It's so fast that it doesn't feel awkward even if you slow it down to 0.9. So I don't understand it well and I think, "What is this?" and it feels so insincere. The man...I think he said, "Right?," 20,000 times if you look at the entire lecture. I really don't want to listen to it. I don't understand it and it's the first time I'm hearing it, but it keeps saying, "Right?," and it really annoys me. I listened to the whole first part, but it felt like I ate 10 sweet potatoes. I've already applied for the second part..so I'm worried. If it were up to me, I'd give it 2 stars.. But I got some tips and I have to listen to the second part, so I'd give it 3 stars.

          • sungucklee2062
            Instructor

            Thank you for your good feedback. Next season, I will try to provide more satisfactory lectures with more preparation and practice.

        Similar courses

        Explore other courses in the same field!