업무에 바로 쓰는 SQL 튜닝

Name: 업무에 바로 쓰는 SQL 튜닝
Price: 59400 KRW
Rating: 4.9 (18 reviews)

이 강의를 통해 MySQL/MariaDB에 관한 쿼리 튜닝의 기초 용어와 원리를 학습한 후, 수 십개의 악성 쿼리를 함께 분석하면서 튜닝 실력을 향상해보아요.

(4.9) 수강평 18개

수강생 177명

바르니

mysql

query

MySQL SQL MariaDB query-tuning DBMS/RDBMS

먼저 경험한 수강생들의 후기

수강 후 이런걸 얻을 수 있어요

RDBMS에서의 쿼리 작성 방법
MySQL/MariaDB에서의 쿼리 최적화(튜닝)
쿼리 튜닝에 관한 용어와 지식들

업무에 바로 쓰는 SQL 튜닝 (MySQL/MariaDB 편)

쿼리 튜닝이 처음이신 분, 느린 SQL을 만나면 어떻게 튜닝(최적화)해야 할지 망설이시는 분에게 한 걸음 나아갈 수 있는 지식과 노하우를 공유드립니다.

SQL문만 작성할 수 있다면, 누구나 SQL 튜닝을 쉽게 시작할 수 있어요.
기본적인 원리와 용어를 이해한 후에, 현업에 흔히 볼 수 있는 나쁜 SQL문들로 한 단계 성장해보세요.
『업무에 바로 쓰는 SQL 튜닝』 도서의 저자가 직접 강의하는 학습 내용으로 기초실력 쑥쑥!

이런 분들께
추천드려요

학습 대상은
누구일까요?

SQL 튜닝을 막 시작하시려는 분들
느린 쿼리를 빠른 쿼리로 탈바꿈하고 싶은 분들
내가 작성한 쿼리가 빠른지 느린지 판단하고 싶은 분들

선수 지식,
필요할까요?

안녕하세요
입니다.

177

명

수강생

개

수강평

4.9

점

강의 평점

개

강의

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

국가 차원의 시험문제 출제/채점/검토 위원
IT 관련 도서 집필 3권 외 기고문 등재
IT 현업 경력 15년차

커리큘럼

전체

57개 ∙ (7시간 11분)

섹션 1. 0. Intro

2개 ∙ (5분)

1. 0-1. 인사말
02:43
2. 0-2. 강의 개요
02:20

섹션 2. 1. 실습 환경 구성하기

6개 ∙ (32분)

3. 1-1. 실습 환경 소개
02:15
4. 1-2. MySQL 설치
05:36
5. 1-3. MySQL 접속
03:48
6. 1-4. 실습 데이터 업로드
09:54
7. 1-5. 실습 데이터 상세 with ERD
06:07
8. (참고) Local PC에 MariaDB 설치
04:31

섹션 3. 2. 손에 잡히는 물리적 용어 이해하기

4개 ∙ (38분)

9. 2-1. 물리 엔진
09:39
10. 2-2. SQL문 수행 절차
10:52
11. 2-3. DB 오브젝트(1)
08:00
12. 2-4. DB 오브젝트(2)
09:40

섹션 4. 3. 손에 잡힐 것 같은 논리적 용어 이해하기

5개 ∙ (36분)

섹션 5. 4. 쿼리 튜닝의 매커니즘 이해하기

9개 ∙ (1시간 26분)

섹션 6. 5. 쿼리의 실행계획 이해하기

6개 ∙ (52분)

섹션 7. 6. 악성 SQL문 튜닝으로 초보자 탈출하기

11개 ∙ (1시간 7분)

섹션 8. 7. 악성 SQL문 튜닝으로 전문가 되기

14개 ∙ (1시간 52분)

강의 게시일:

마지막 업데이트일:

수강평

전체

18개

4.9

18개의 수강평

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
수강평 5
∙
평균 평점 5.0
5
61% 수강 후 작성
- 7e7ey
  지식공유자
  Thank you :)
qqwewew
수강평 14
∙
평균 평점 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.
jogman1704
수강평 6
∙
평균 평점 5.0
5
32% 수강 후 작성
st0584
수강평 3
∙
평균 평점 5.0
5
100% 수강 후 작성

₩59,400

비슷한 강의

같은 분야의 다른 강의를 만나보세요!

MariaDB client development, internal functions

swa

We will look at usage and examples of the 108 main internal functions provided by MariaDB using the HeidiSQL development tool.

초급

MariaDB

MariaDB client development, internal functions

swa

GCP BigQuery Tutorial for Beginners

Sungmin Kim

Let's learn together about Columnar Storage, which allows you to conveniently handle both structured and unstructured data provided by GCP and allows for a free table format, and BigQuery, a universal database.

입문

SQL, Google Cloud Platform, bigquery

GCP BigQuery Tutorial for Beginners

Sungmin Kim

Creating Practical Unity Games Combined with Databases

JEngineer

This is a course on creating practical Unity games with databases. You can work through the difficult-to-approach parts through the lectures.

초급

C#, Unity, Firebase

Creating Practical Unity Games Combined with Databases

JEngineer

DATABASE 1&2 - MySQL

Egoing Lee

It contains a comprehensive introduction to databases, the heart of information technology. We study the essence of databases and learn about MYSQL, the most representative relational database.

초급

MySQL, DBMS/RDBMS

DATABASE 1&2 - MySQL

Egoing Lee

Building a stateful service for Daeyongrang Chat TPS

July

We will tell you everything about how to build a server and perform uninterrupted deployment for stateful services such as Chijijik and AfreecaTV.

초급

Go, Kafka, Node.js

Building a stateful service for Daeyongrang Chat TPS

July

Create automation using Google Authenticator, QR, and Cron

July

In this lecture, we aim to create a Web Scraping API server using the Naver Shopping site. We will show you how to configure a managed API server by connecting MySQL and configuring a 3-tier architecture!!

초급

Go, MySQL, Web Scraping

Create automation using Google Authenticator, QR, and Cron

July

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

nullnull8537

Building a Chat Platform Using Spring Boot

Hong

You can learn about JWT and ws communication using Spring Boot, and how to handle high TPS.

초급

Spring Boot, JWT, websocket

Building a Chat Platform Using Spring Boot

Hong

For those who haven't even started with SQL, come here

coddatg

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

입문

SQL, bigquery

For those who haven't even started with SQL, come here

coddatg

[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

Rookiss

Essential Computer Science Knowledge for Job Preparation

kangminchul

Immutable truths for developers/engineers that will never change even in the AI era! We provide essential computer science knowledge for free to prepare for developer/engineer job applications and technical interviews.

입문

Network, DBMS/RDBMS, Computer Architecture

Essential Computer Science Knowledge for Job Preparation

kangminchul

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

Masocampus

Large-Scale Systems Design Part 1

Jayce

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

초급

software-design, DBMS/RDBMS

Large-Scale Systems Design Part 1

Jayce

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

usefulit

Introduction to BigQuery (SQL) for Beginners

kyleschool

This is an introductory BigQuery (SQL) course for beginners. Recommended for those curious about data processing methods. We teach SQL from a data analysis and data engineering perspective rather than a backend development perspective.

초급

SQL, Google Cloud Platform, bigquery

Introduction to BigQuery (SQL) for Beginners

kyleschool

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)

jscode

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

dooleyz3525

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

yoonpago93

업무에 바로 쓰는 SQL 튜닝

먼저 경험한 수강생들의 후기

수강 후 이런걸 얻을 수 있어요

업무에 바로 쓰는 SQL 튜닝 (MySQL/MariaDB 편)

이런 내용을 배워요

어려운 튜닝 용어는 쉬운 비유로!

함께 고민하면서 쿼리 최적화 하기

수강 전 참고 사항

실습 환경

선수 지식 및 유의사항

학습 자료

이런 분들께
추천드려요

안녕하세요
입니다.

커리큘럼

수강평

비슷한 강의

업무에 바로 쓰는 SQL 튜닝

먼저 경험한 수강생들의 후기

수강 후 이런걸 얻을 수 있어요

업무에 바로 쓰는 SQL 튜닝 (MySQL/MariaDB 편)

이런 내용을 배워요

어려운 튜닝 용어는 쉬운 비유로!

함께 고민하면서 쿼리 최적화 하기

수강 전 참고 사항

실습 환경

선수 지식 및 유의사항

학습 자료

이런 분들께 추천드려요

안녕하세요 .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}입니다.

커리큘럼

수강평

비슷한 강의

이런 분들께
추천드려요

안녕하세요
입니다.