업무에 바로 쓰는 SQL 튜닝

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

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

(4.9) 수강평 16개

수강생 173명

바르니

mysql

query

MySQL SQL MariaDB query-tuning DBMS/RDBMS

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

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

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

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

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

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

이런 분들께
추천드려요

학습 대상은
누구일까요?

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

선수 지식,
필요할까요?

안녕하세요
입니다.

173

명

수강생

개

수강평

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분)

강의 게시일:

마지막 업데이트일:

수강평

전체

16개

4.9

16개의 수강평

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.
dayeonkwon8297
수강평 1
∙
평균 평점 5.0
5
100% 수강 후 작성
cswooo178461
수강평 2
∙
평균 평점 5.0
5
32% 수강 후 작성

₩59,400

비슷한 강의

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

[SQL Automation] PL/SQL for Immediate Practical Use

codingkorea

Author's direct lecture for the SQL200je (PL/SQL) book, published by 정보문화사! This PL/SQL course is by Oracle instructor Yooyeonsu, who has trained countless DBAs and PL/SQL developers. After taking the lecture, you will clearly feel the difference between before and after using PL/SQL.

입문

PL/SQL, SQL, RPA

[SQL Automation] PL/SQL for Immediate Practical Use

codingkorea

Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

topdatastudio

'Complete Mastery of Practical SQL in 49 Sessions II - Advanced Course' follows the basic course. By using a practical database for learning, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems.

초급

SQL, MSSQL

Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

topdatastudio

[Part 2] Creating Your First Spring Boot Project with Real Understanding Alongside the Developer Next Door

nextdoordeveloper

[Web Dev Beginners Only] Build a Spring Boot REST API easily, step-by-step, fully understanding JPA.

초급

Spring, Spring Boot, JPA

[Part 2] Creating Your First Spring Boot Project with Real Understanding Alongside the Developer Next Door

nextdoordeveloper

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

Master Kotlin through Real Project Practice

Hong

Let's build a project using Ktor, the most popular project in Kotlin, and master Kotlin! 😆

입문

Kotlin, MySQL, ktor

Master Kotlin through Real Project Practice

Hong

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

BigQuery(SQL) Application (Funnel Analysis, Retention Analysis)

kyleschool

We conduct app log analysis using data from Google Analytics 4 and Firebase. It includes useful content for practical use, such as arrays, window functions, funnels, retention, Google Sheets, and more.

중급이상

bigquery, SQL, Firebase

BigQuery(SQL) Application (Funnel Analysis, Retention Analysis)

kyleschool

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

datarian

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

입문

SQL, MySQL, kakao-service

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

datarian

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

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

[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

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

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

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

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

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

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

업무에 바로 쓰는 SQL 튜닝

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

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

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

이런 내용을 배워요

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

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

수강 전 참고 사항

실습 환경

선수 지식 및 유의사항

학습 자료

이런 분들께
추천드려요

안녕하세요
입니다.

커리큘럼

수강평

비슷한 강의

업무에 바로 쓰는 SQL 튜닝

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

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

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

이런 내용을 배워요

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

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

수강 전 참고 사항

실습 환경

선수 지식 및 유의사항

학습 자료

이런 분들께 추천드려요

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

커리큘럼

수강평

비슷한 강의

이런 분들께
추천드려요

안녕하세요
입니다.