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

221 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

s_jaemin

100% enrolled

I think this will be very helpful in practice; I should take some time to review it.

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

221

Learners

34

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

34 reviews

4.9

34 reviews

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

  • sjaemin1838님의 프로필 이미지
    sjaemin1838

    Reviews 3

    Average Rating 4.3

    5

    100% enrolled

    I think this will be very helpful in practice; I should take some time to review it.

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

      • beholder160588님의 프로필 이미지
        beholder160588

        Reviews 5

        Average Rating 5.0

        5

        61% enrolled

        • 7e7ey
          Instructor

          Thank you :)

      Similar courses

      Explore other courses in the same field!