
Database MSSQL
vmproductor0202
This is a class on MSSQL, one of the three major databases. Even if you are learning databases for the first time, you can learn it easily.
입문
DBMS/RDBMS, MSSQL, 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)
166 learners
Level Intermediate
Course period Unlimited

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.
You can learn the know-how from a working DBA practitioner easily, lightly, and inexpensively.
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 .

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
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.
All
19 lectures ∙ (3hr 0min)
Course Materials:
All
11 reviews
3.9
11 reviews
Reviews 1
∙
Average Rating 5.0
Reviews 8
∙
Average Rating 5.0
Reviews 9
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 3
∙
Average Rating 4.0
$59.40
Check out other courses by the instructor!
Explore other courses in the same field!