inflearn logo

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.9) 11 reviews

170 learners

Level Intermediate

Course period Unlimited

MSSQL
MSSQL
query-tuning
query-tuning
dba
dba
query-refactoring
query-refactoring
DBMS/RDBMS
DBMS/RDBMS
MSSQL
MSSQL
query-tuning
query-tuning
dba
dba
query-refactoring
query-refactoring
DBMS/RDBMS
DBMS/RDBMS

What you will gain after the course

  • 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 vmproductor0202

23,557

Learners

864

Reviews

288

Answers

4.4

Rating

24

Courses

I am a technology leader among IT professionals in Korea.

The only lecture in Korea:

eGovFrame, LAYERED Architecture

,WPF_MVVM pattern. OLAP, SSIS, SSAS, etc.

The only lecture in the world:

Springframework + Enterprise Architecture[EA],

Query refactoring, SignalR + JWT

MAUI + MVVM + AZURE, etc.

If you have any questions during the lecture,

Questions and answers regarding this lecture, or

Please leave a message at vmproductor@gmail.com.

I also offer consultations for non-lecture related matters, general inquiries, and career counseling.

Experience-

Bachelor's degree in Computer Science. Certified Engineer Information Processing.

ExtremeNetworks (Korea), former intern at the world's 2nd largest network company

Web, Android, AI development and maintenance (former)

ERP Web Development (Former)

Database, Server Administrator (Former)

MES, FA (Former)

E-Commerce Web Development (Former)

Remote control and monitoring of national facilities (current)

Web, Android, AI development and maintenance (Former) ERP web development (Former) Database, Server Administrator (Former) MES, FA (Former) E-Commerce web development (Former) Remote control and monitoring of national facilities (Current)

Part-

Designer, Web, Android, Remote Automation Systems, Translation Programs, Server, Network, White Hat Hacker, Angular

Project Manager, DBA (MSSQL, ORACLE, MYSQL), DE, OS programming, Application Software, Astrophysics

I specialize in these and other related fields.

More

Curriculum

All

19 lectures ∙ (3hr 0min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

11 reviews

3.9

11 reviews

  • sbs2514님의 프로필 이미지
    sbs2514

    Reviews 1

    Average Rating 5.0

    5

    32% enrolled

    Thank you for making the lecture content easy and understandable.

    • seolyh4127206님의 프로필 이미지
      seolyh4127206

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      • heamosu75189님의 프로필 이미지
        heamosu75189

        Reviews 3

        Average Rating 4.0

        4

        74% enrolled

        The lecture material is very helpful as it has lots of examples that you can use.

        • studyhardwith님의 프로필 이미지
          studyhardwith

          Reviews 8

          Average Rating 5.0

          5

          100% enrolled

          • njh88102830님의 프로필 이미지
            njh88102830

            Reviews 9

            Average Rating 5.0

            5

            63% enrolled

            vmproductor0202's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            $59.40