Inflearn brand logo image
Inflearn brand logo image

N

Inflearn brand logo image
Programming

/

Database

仕事に直接書き込むSQLチューニング

この講義を通じてMySQL/MariaDBに関するクエリチューニングの基礎用語と原理を学習した後、数十の悪性クエリを一緒に分析しながらチューニングのスキルを向上してみましょう。

（4.8）受講レビュー 13件

受講生 140名

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

学習した受講者のレビュー

こんなことが学べます

  • RDBMSでクエリを作成する方法

  • MySQL / MariaDBでのクエリの最適化（チューニング）

  • クエリのチューニングに関する用語と知識

業務に直接書き込むSQLチューニング（MySQL/MariaDB編）

クエリチューニングが初めての方、遅いSQLに出会ったらどのようにチューニング（最適化）するか迷っている方に一歩進むことができる知識とノウハウを共有します。

  • SQLステートメントのみを書くことができれば、誰でもSQLチューニングを簡単に始めることができます。


  • 基本的な原理と用語を理解したら、現業によく見られる悪いSQL文で一歩進んでください。

  • 『業務にすぐ書くSQLチューニング』図書の著者が直接講義する学習内容で基礎実力よもぎ！


このようなことを学びます。

難しいチューニング用語は簡単なたとえ話で！

理解しにくいIT用語は、日常生活に触れる単語で概念を理解できます。日常的に斜めのたとえ話と簡単な例を通して、クエリチューニングの進入障壁を下げることができます。
例）ナビゲーションとオプティマイザの類似性により、DBの脳であるオプティマイザを簡単に理解する

car

ナビゲーション対DBオプティマイザ

一緒に悩みながらクエリを最適化する

チューニングに関連する学習を一緒に実行したら、現業でよく見られる問題のある数十のクエリをチューニングします。
どこからどのように始めるべきか、どのように考えるべきかを一緒に悩む時間を持ってみましょう。

a

一緒にクエリをチューニングする

受講前の注意

練習環境

  • オペレーティングシステムとバージョン（OS）：Windows

  • ターゲットDBMS：MySQL

  • 練習領域：SQLターゲットで実行するクエリのチューニング

  • その他：Macなど他のOS関連ガイド、MySQLに似たMariaDBも可能

選手の知識と注意事項

  • SQL作成が可能な方は円滑な講義受講可能


  • 練習資料はFetHut（github）で共有


学習資料

  • Gitを介して主要なカリキュラムと個々の難易度、実践を行うためのRaw DataとERDを提供

  • クラスの内容に含まれるすべての実践SQLを提供

こんな方に
おすすめです

学習対象は
誰でしょう？

  • SQLチューニングを開始したい人

  • 遅いクエリをクイッククエリに変身したい方

  • 私が書いたクエリが速いか遅いかを判断したい人

前提知識、
必要でしょうか？

  • SQL

こんにちは
です。

140

受講生

13

受講レビュー

4.8

講座評価

1

講座

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

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

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

  • IT 현업 경력 15년차

カリキュラム

全体

57件 ∙ (7時間 11分)

講座掲載日: 
最終更新日: 

受講レビュー

全体

13件

4.8

13件の受講レビュー

  • syh8088님의 프로필 이미지
    syh8088

    受講レビュー 7

    ∙

    平均評価 5.0

    5

    32% 受講後に作成

    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
      知識共有者

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

  • beholder160588님의 프로필 이미지
    beholder160588

    受講レビュー 5

    ∙

    平均評価 5.0

    5

    61% 受講後に作成

    • 7e7ey
      知識共有者

      Thank you :)

  • qqwewew님의 프로필 이미지
    qqwewew

    受講レビュー 13

    ∙

    平均評価 5.0

    5

    32% 受講後に作成

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

    • 7e7ey
      知識共有者

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

  • shinje2412님의 프로필 이미지
    shinje2412

    受講レビュー 1

    ∙

    平均評価 5.0

    5

    32% 受講後に作成

    • hyunwookoh5748님의 프로필 이미지
      hyunwookoh5748

      受講レビュー 1

      ∙

      平均評価 5.0

      5

      61% 受講後に作成

      ￥7,064

      似ている講座

      同じ分野の他の講座を見てみましょう！

      First steps to SQL coding test강의 썸네일

      First steps to SQL coding test

      gemmadata

      By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.

      초급

      초급

      Coding Test, SQL, MySQL

      First steps to SQL coding test강의 썸네일

      First steps to SQL coding test

      gemmadata

      @Sico - Learn MySQL Properly (Perfect Basics)강의 썸네일

      @Sico - Learn MySQL Properly (Perfect Basics)

      seniorcoding

      The importance of MySQL is constantly being highlighted in various aspects. Through this lecture, you will learn step by step and through this, you will jump to the intermediate level in one go.

      초급

      초급

      MySQL

      @Sico - Learn MySQL Properly (Perfect Basics)강의 썸네일

      @Sico - Learn MySQL Properly (Perfect Basics)

      seniorcoding

      High-Performance SQL for JPA (ORM) Developers강의 썸네일

      High-Performance SQL for JPA (ORM) Developers

      vladmihalcea

      Make the most of relational database systems!

      중급이상

      중급이상

      SQL, performance-tuning, sql-query

      High-Performance SQL for JPA (ORM) Developers강의 썸네일

      High-Performance SQL for JPA (ORM) Developers

      vladmihalcea

      [A hundred words are not as good as seeing once] Basic SQL for data analysis강의 썸네일

      [A hundred words are not as good as seeing once] Basic SQL for data analysis

      datarian

      Datalian's SQL basics lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn SQL basics theory and solve 10 HackerRank problems together.

      입문

      입문

      SQL, MySQL

      [A hundred words are not as good as seeing once] Basic SQL for data analysis강의 썸네일

      [A hundred words are not as good as seeing once] Basic SQL for data analysis

      datarian

      6-Week Complete! 4 Backend Resume Differentiation Strategies - How to Stand Out Among Identical Resumes

      dingcodingco

      When resumes look similar, 'differentiation' secures acceptance. For 6 weeks, learn 4 practical resume strategies directly from a backend practitioner.

      초급

      초급

      Resume, Spring, Java

      6-Week Complete! 4 Backend Resume Differentiation Strategies - How to Stand Out Among Identical Resumes

      dingcodingco

      Learning Large-Scale System Design by Building Directly with Spring Boot - Bulletin Board강의 썸네일

      Learning Large-Scale System Design by Building Directly with Spring Boot - Bulletin Board

      kuke

      We will learn how to create a system to support large amounts of data and traffic by creating it directly with Spring Boot.

      중급이상

      중급이상

      Spring Boot, MySQL, Redis

      Learning Large-Scale System Design by Building Directly with Spring Boot - Bulletin Board강의 썸네일

      Learning Large-Scale System Design by Building Directly with Spring Boot - Bulletin Board

      kuke

      Creating a table using public data CSV file강의 썸네일

      Creating a table using public data CSV file

      swa

      Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

      중급이상

      중급이상

      SQL, HeidiSQL, MariaDB

      Creating a table using public data CSV file강의 썸네일

      Creating a table using public data CSV file

      swa

      SQL data analysis learned through various cases강의 썸네일

      SQL data analysis learned through various cases

      dooleyz3525

      By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

      중급이상

      중급이상

      SQL, PostgreSQL, DBMS/RDBMS

      SQL data analysis learned through various cases강의 썸네일

      SQL data analysis learned through various cases

      dooleyz3525

      Complete mastery of PHP programming practices! with MySQL강의 썸네일

      Complete mastery of PHP programming practices! with MySQL

      usefulit

      This course is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

      입문

      입문

      PHP, phpmyadmin, MySQL

      Complete mastery of PHP programming practices! with MySQL강의 썸네일

      Complete mastery of PHP programming practices! with MySQL

      usefulit

      SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions강의 썸네일

      SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

      masocampus

      From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

      입문

      입문

      SQL, SQLD

      SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions강의 썸네일

      SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

      masocampus

      Complete Mastery of Character Encoding That Makes You Work Overtime If You Don't Know It강의 썸네일

      Complete Mastery of Character Encoding That Makes You Work Overtime If You Don't Know It

      nullnull8537

      We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.

      초급

      초급

      Java, MySQL, utf-8

      Complete Mastery of Character Encoding That Makes You Work Overtime If You Don't Know It강의 썸네일

      Complete Mastery of Character Encoding That Makes You Work Overtime If You Don't Know It

      nullnull8537

      [MMORPG Game Development Series with C# and Unity] Part 5: Database강의 썸네일

      [MMORPG Game Development Series with C# and Unity] Part 5: Database

      rookiss

      This course teaches MS-SQL through baseball/company databases.

      초급

      초급

      SQL, DBMS/RDBMS

      [MMORPG Game Development Series with C# and Unity] Part 5: Database강의 썸네일

      [MMORPG Game Development Series with C# and Unity] Part 5: Database

      rookiss

      Do it! SQL Introduction강의 썸네일

      Do it! SQL Introduction

      easyspub

      A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

      입문

      입문

      SQL

      Do it! SQL Introduction강의 썸네일

      Do it! SQL Introduction

      easyspub

      Creating Practical Unity Games with Database Integration강의 썸네일

      Creating Practical Unity Games with Database Integration

      jengineer

      This is a course on making practical Unity games with a database. Challenging areas can be covered in this course.

      초급

      초급

      C#, Unity, Firebase

      Creating Practical Unity Games with Database Integration강의 썸네일

      Creating Practical Unity Games with Database Integration

      jengineer

      Large-Scale Systems Design Part 1강의 썸네일

      Large-Scale Systems Design Part 1

      byjayce

      Learn common components of global-scale services through popular papers, books, and articles.

      초급

      초급

      software-design, DBMS/RDBMS

      Large-Scale Systems Design Part 1강의 썸네일

      Large-Scale Systems Design Part 1

      byjayce

      Redis Introduction/Practice for Non-Majors (Query Performance Optimization Edition)강의 썸네일

      Redis Introduction/Practice for Non-Majors (Query Performance Optimization Edition)

      jscode

      I've created a 'Redis Introduction/Practical (Query Performance Optimization)' course that non-majors can easily understand and immediately apply in practice!

      초급

      초급

      Redis, performance-tuning, NoSQL

      Redis Introduction/Practice for Non-Majors (Query Performance Optimization Edition)강의 썸네일

      Redis Introduction/Practice for Non-Majors (Query Performance Optimization Edition)

      jscode

      Yoonpago's Information Processing Engineer DB/Programming All-In-One강의 썸네일

      Yoonpago's Information Processing Engineer DB/Programming All-In-One

      yoonpago93

      If you can master DB and programming, you should be more than halfway prepared for the information processing engineer exam. Let's take a look at the DB and programming parts, which are worth 45 to 55 points in the practical exam, and pass the written exam steadily.

      입문

      입문

      Engineer Information Processing, DBMS/RDBMS, C

      Yoonpago's Information Processing Engineer DB/Programming All-In-One강의 썸네일

      Yoonpago's Information Processing Engineer DB/Programming All-In-One

      yoonpago93