SQL tuning for immediate use in business

In this lecture, you will learn the basic terms and principles of query tuning for MySQL/MariaDB, and then improve your tuning skills by analyzing dozens of malicious queries.

(4.9) 32 reviews

209 learners

Level Basic

Course period 12 months

MySQL
MySQL
SQL
SQL
MariaDB
MariaDB
query-tuning
query-tuning
DBMS/RDBMS
DBMS/RDBMS
MySQL
MySQL
SQL
SQL
MariaDB
MariaDB
query-tuning
query-tuning
DBMS/RDBMS
DBMS/RDBMS

Reviews from Early Learners

4.9

5.0

리나

32% enrolled

I think it's really great that you explained in an easy-to-understand way how to optimize the index search. The only thing I'm disappointed about is that the course duration is 12 months 😭,😭 I wish you could let me take the course for life even if I have to pay more. :)

5.0

우디

32% enrolled

I read the book well, so I bought the lecture. Thank you for making a good book. I am watching the lecture.

5.0

김민규

100% enrolled

It was great to learn and understand through examples.

What you will gain after the course

  • How to write queries in RDBMS

  • Query Optimization (Tuning) in MySQL/MariaDB

  • Terminology and knowledge about query tuning

SQL Tuning for Work (MySQL/MariaDB Edition)

For those who are new to query tuning or are unsure how to tune (optimize) slow SQL, we share knowledge and know-how that will help you take the next step forward.

  • Anyone can easily start tuning SQL as long as they can write SQL statements.


  • After understanding the basic principles and terminology, take it to the next level with some common bad SQL statements you see in the field.

  • Improve your basic skills with learning content directly taught by the author of the book, "SQL Tuning for Work"!


Learn about these things

Difficult tuning terms explained with easy analogies!

Difficult IT terms can be understood through everyday vocabulary. Using everyday analogies and easy-to-understand examples, query tuning becomes less of a barrier to entry.
Example) Similarity between navigation and optimizer makes it easy to understand the optimizer, the brain of the DB.

Navigation vs. DB Optimizer

Optimizing queries while thinking together

After learning about tuning, we will tune dozens of problematic queries that are frequently seen in the field.
Let's take some time to think together about where and how to start and what to think about.

Tuning queries together

Things to note before taking the course

Practice environment

  • Operating System and Version (OS): Windows

  • Target DBMS: MySQL

  • Practice Area: Query Tuning for SQL Targets

  • Other: Guides for other OSes, including Mac, and MariaDB, similar to MySQL.

Player Knowledge and Precautions

  • Those who can write SQL can take the course smoothly.


  • Practice materials are shared through GitHub.


Learning Materials

  • Providing raw data and ERD for performing the main curriculum, individual difficulty levels, and practical exercises through Git.

  • Provides all practical SQL included in the course content

Recommended for
these people

Who is this course right for?

  • For those who are just starting out with SQL tuning

  • For those who want to transform slow queries into fast queries

  • For those who want to determine whether the query I wrote is fast or slow

Need to know before starting?

  • SQL

Hello
This is 7e7ey

209

Learners

32

Reviews

4.9

Rating

1

Course

A guider who explains complex IT in simple terms.

  • National-level exam question developer, grader, and reviewer

  • Author of 3 IT-related books and contributor of various published articles

  • 15 years of experience in the IT industry

More

Curriculum

All

57 lectures ∙ (7hr 11min)

Published: 
Last updated: 

Reviews

All

32 reviews

4.9

32 reviews

  • roel님의 프로필 이미지
    roel

    Reviews 17

    Average Rating 5.0

    5

    100% enrolled

    Every time I looked at an execution plan, I found it difficult and didn't know how to interpret it, but through this lecture, I was able to clearly understand, thinking, "Ah! So that's what it is!" The terminology is well-organized, and the lecture serves as a great guide by explaining the approach and what needs to be done step-by-step.

    • qqwewew님의 프로필 이미지
      qqwewew

      Reviews 14

      Average Rating 5.0

      5

      32% enrolled

      I read the book well, so I bought the lecture. Thank you for making a good book. I am watching the lecture.

      • 7e7ey
        Instructor

        Thank you for listening to the lecture along with the book. I hope it was helpful.

    • mkkim2103님의 프로필 이미지
      mkkim2103

      Reviews 2

      Average Rating 5.0

      5

      100% enrolled

      It was great to learn and understand through examples.

      • syh8088님의 프로필 이미지
        syh8088

        Reviews 7

        Average Rating 5.0

        5

        32% enrolled

        I think it's really great that you explained in an easy-to-understand way how to optimize the index search. The only thing I'm disappointed about is that the course duration is 12 months 😭,😭 I wish you could let me take the course for life even if I have to pay more. :)

        • 7e7ey
          Instructor

          I am even more grateful that it helped you understand. I will try harder to make it a useful lecture. :)

      • beholder160588님의 프로필 이미지
        beholder160588

        Reviews 5

        Average Rating 5.0

        5

        61% enrolled

        • 7e7ey
          Instructor

          Thank you :)

      Similar courses

      Explore other courses in the same field!