인프런 영문 브랜드 로고
인프런 영문 브랜드 로고
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.

(5.0) 4 reviews

57 students

MySQL
SQL
MariaDB
query-tuning
DBMS/RDBMS
Thumbnail

This course is prepared for Basic 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 hesitant about how to tune (optimize) slow SQL, we share knowledge and know-how to help you take a step forward.

  • Anyone can easily start tuning SQL if 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 Right Away’!


Learn about these things

Difficult tuning terms explained with easy metaphors!

Difficult IT terms can be understood through words encountered in everyday life. The entry barrier to query tuning can be lowered through analogies and easy examples from everyday life.
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 class

Practice environment

  • Operating System and Version (OS): Windows

  • Target DBMS: MySQL

  • Practice Area: Query Tuning for SQL Targets

  • Other: Guides for other OSes such as Mac, MariaDB similar to MySQL is also possible

Player Knowledge and Notes

  • 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 main curriculum, individual difficulty levels, and practice 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

57

Students

4

Reviews

5.0

Rating

1

Course

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

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

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

  • IT 현업 경력 15년차

Curriculum

All

57 lectures ∙ (7hr 11min)

Published: 
Last updated: 

Reviews

Not enough reviews.
Become the author of a review that helps everyone!