강의

멘토링

로드맵

Inflearn brand logo image
Programming

/

Database

MSSQL Part 2 (Tuning Basics, Performance Tunning, Senior DBA)

You can learn how to solve concurrency problems, how to tune procedures, and how to speed up query execution. You can also learn various know-hows such as common mistakes and problems that occur in practice. (The only refactoring lecture in the world)

(3.8) 10 reviews

161 learners

  • vmproductor0202
mssql
dba
query
쿼리최적화
데이터베이스
MSSQL
query-tuning
query-refactoring
DBMS/RDBMS

What you will learn!

  • Concurrency Control

  • Correct use of indexes

  • Procedure Deepening

  • Improve query performance

  • Database Maintenance

  • Common Mistakes in Practice (Design and Habit)

  • Query Refactoring

  • How to solve deadlock

Powerful performance! The key to query tuning.

Must-know for DBAs
Practical query tuning know-how.

Query refactoring that works in practice!

You can learn the know-how from a working DBA practitioner easily, lightly, and inexpensively.

  • ✅ Those who want to learn more about MSSQL basics
  • ✅ An engineer who suddenly received a call saying that the DB was slow
  • ✅ Those who need to improve MSSQL query speed
  • ✅ Those who use MSSQL in practice

This lecture focuses on improving query execution speed . It presents solutions to a variety of practical problems, including concurrency issues, design flaws, unexplained CPU over-utilization, slowdowns, and poor practices.

This isn't just a theory-focused lecture. Through hands-on practice alongside the theory, you'll fully integrate the course content into your own skills. The lecture videos are subtitled , allowing you to learn with a light heart even in environments where audio is difficult to hear, such as during your commute.

Improve your query performance further with query tuning know-how from experts .

  • The only lecture in the world: Query refactoring (2023.01)
  • The only contents in the korea: Query refactoring (2023.01) How to solve deadlock (2023.01)
  • The only lecture in the korea: Procedure Recompile (2023.01) etc...

Learn the concepts with PPT,
Even hands-on practice with SQL Server.

Example of theoretical learning
Practice example

Please check the player process!

Recommended for
these people

Who is this course right for?

  • Senior DBA

  • Senior DBA

  • SW Tester

  • Maintenance Specialist

  • Backend Developer

Need to know before starting?

  • How to Use Microsoft SQL Server

  • Basic SQL skills beyond basic

Hello
This is

22,643

Learners

778

Reviews

283

Answers

4.4

Rating

23

Courses

국내IT실무진 기술선도자입니다.

국내유일강의:

전자정부프레임워크,LAYERED 아키텍처

,WPF_MVVM패턴.OLAP,SSIS.SSAS 등

The only lecture in the world:

Springframework + Enterprise Architecture[EA],

Query refactoring ,SignalR + JWT

MAUI + MVVM + AZURE, etc.

 

강의 중 궁금한 사항은

해당 강의의 질문&답변 또는

이메일 vmproductor@gmail.com로 남겨주세요.

강의 외적인 상담, 궁금한 사항,취업상담등도 받고 있습니다.

 

경력-

컴퓨터공학과 학사학위. 정보처리기사 취득

ExtremeNetworks(한국) 네트워크세계2위업체 인턴(전)

번역 웹,안드로이드,AI 개발 및 유지보수(전)

ERP 웹개발(전)

데이터베이스,서버 관리자(전)

MES,FA (전)

E-Commerce웹개발(전)

국가시설 원격제어 및 모니터링(현)

 

파트-

디자이너,웹,안드로이드,원격자동화시스템,번역프로그램,서버,네트워크,화이트해커,Angular

프로젝트관리자,DBA(MSSQL,ORACLE,MYSQL),DE,OS programming,응용 소프트웨어,천체물리학

등등을전문으로 다루고있습니다.

Curriculum

All

19 lectures ∙ (3hr 0min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

10 reviews

3.8

10 reviews

  • 공부님의 프로필 이미지
    공부

    Reviews 7

    Average Rating 5.0

    5

    100% enrolled

    • smban님의 프로필 이미지
      smban

      Reviews 3

      Average Rating 5.0

      5

      63% enrolled

      .

      • 노준호님의 프로필 이미지
        노준호

        Reviews 8

        Average Rating 5.0

        5

        63% enrolled

        • sbs님의 프로필 이미지
          sbs

          Reviews 1

          Average Rating 5.0

          5

          32% enrolled

          강의내용이 쉽고 잘 이해하기 쉽게 해줘서 감사합니다.

          • heamosu7님의 프로필 이미지
            heamosu7

            Reviews 3

            Average Rating 4.0

            4

            74% enrolled

            활용 가능한 많은 예제가 있는 강의 자료가 많은 도움이 됩니다.

            $59.40

            vmproductor0202's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!