강의

멘토링

로드맵

Programming

/

Database

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.8) 13 reviews

156 learners

  • 7e7ey
mysql
query
MySQL
SQL
MariaDB
query-tuning
DBMS/RDBMS

Reviews from Early Learners

What you will learn!

  • 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

156

Learners

13

Reviews

4.8

Rating

1

Course

어려운 IT를 쉽게 설명하는 가이더(Guider)

  • 국가 차원의 시험문제 출제/채점/검토 위원

  • IT 관련 도서 집필 3권 외 기고문 등재

  • IT 현업 경력 15년차

Curriculum

All

57 lectures ∙ (7hr 11min)

Published: 
Last updated: 

Reviews

All

13 reviews

4.8

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

  • beholder160588님의 프로필 이미지
    beholder160588

    Reviews 5

    Average Rating 5.0

    5

    61% enrolled

    • 7e7ey
      Instructor

      Thank you :)

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

  • shinje2412님의 프로필 이미지
    shinje2412

    Reviews 1

    Average Rating 5.0

    5

    32% enrolled

    • hyunwookoh5748님의 프로필 이미지
      hyunwookoh5748

      Reviews 1

      Average Rating 5.0

      5

      61% enrolled

      $46.20

      Similar courses

      Explore other courses in the same field!