강의

멘토링

커뮤니티

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

166 learners

Level Intermediate

Course period Unlimited

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

23,379

Learners

847

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.

Curriculum

All

19 lectures ∙ (3hr 0min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

11 reviews

3.9

11 reviews

  • seolyh4127206님의 프로필 이미지
    seolyh4127206

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    • studyhardwith님의 프로필 이미지
      studyhardwith

      Reviews 8

      Average Rating 5.0

      5

      100% enrolled

      • njh88102830님의 프로필 이미지
        njh88102830

        Reviews 9

        Average Rating 5.0

        5

        63% enrolled

        • sbs2514님의 프로필 이미지
          sbs2514

          Reviews 1

          Average Rating 5.0

          5

          32% enrolled

          Thank you for making the lecture content easy and understandable.

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

            $59.40

            vmproductor0202's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!