This course teaches you how to write performance-conscious queries during the SQL development phase, guided by a SQL Server expert. You can learn the basics for meeting query performance requirements along with practical case studies.
1,264 learners
Level Intermediate
Course period 6 months
Learn the basic rules and prohibitions for writing high-performance queries.
Basic knowledge for writing good quality queries
Indirect experience of common practical cases
Query writing determines performance and quality!
Learn solidly with a focus on practical skills. 👨💻
In terms of performance, poorly written queries are a major cause of DB performance and service performance degradation. It is common for queries written early in development to be result-oriented or implementations that are not suitable for SQL Server to cause performance problems later as data increases .
As a SW developer, I would like to share my knowledge and experience so that I can understand and immediately apply to my work which types of queries or implementations may cause performance issues in the future when developing projects or solutions.
SQL Server
Beginner/Intermediate Developer
SQL
Query User
For IT projects
Mainly involved developers
On query performance
Interested in~
Intermediate user
Query optimization
Worried about
Solution Developer
Writing a query
Need a standard
manager
There are basic rules, taboos, and writing methods that must be followed from the development and implementation stages for index and query tuning.
In this training, developers can learn various rules and recommendations that should be considered in the query implementation phase, which will help them implement better quality and easier to maintain queries . In particular, knowledge sharing experts with long-term consulting and teaching experience in SQL Server use examples that commonly appear in practice as samples for each topic, so it will be directly helpful for practical use after training.
If you know the basics of SQL, it will be easier to understand and follow the content. If there is something you don't know in the middle, it will be helpful to learn the relevant sentence/command/grammar and listen to it again. Or you can use Q/A. 😊
There are subtle differences in architecture for each DBMS, such as indexes, statistics, locks, and query optimization, so the content of this lecture based on SQL Server may not be 100% applicable. However, I can tell you that a lot of the content is applicable to other DBMS as well.
Most of the content is almost the same as the versions currently in use. Any differences will be explained in the lecture.
1. Query writing basics
2. Query Contraindications
3. Write better queries
4. Considerations when implementing cursors, views, and user-defined functions
History
Qualifications and Certifications
Teaching activities (since 1999)
Outside activities
Q. Is this a lecture that non-majors can also take?
If you have basic or experience using SQL, you can take this course. Even if you are a little lacking, you can learn the basics you need while taking the course.
Q. Is there anything I need to prepare before attending the lecture?
You can install the SSMS program provided by SQL Server or a similar program that can use queries, and download the demo DB and SQL script provided in advance. The demo DB configuration will be explained in the training.
Q. Are there any notes regarding taking the course (environment required, other things to keep in mind, etc.)?
I need SQL Server for demos and assignments. If possible, the latest version (2019 as of 2021) is good, but an older version is also fine.
Q. How is it different from the training content on the topic of "Query Tuning"?
Query tuning covers the overall process, methods, and cases of diagnosing and analyzing query performance and improving performance through cause tracking and resolution. Since this is not covered in this course , please refer to it, and this part will be explained again in the first half of the training video.
Who is this course right for?
SQL Server junior to mid-level developer
Solution Developer
A developer who mainly participates in IT projects
Mid-to-entry level developers interested in query performance
A manager who needs query writing standards
Need to know before starting?
SQL Basics
1,699
Learners
146
Reviews
63
Answers
4.7
Rating
4
Courses
(주)씨퀄로 대표컨설턴트/이사, SQLBigEyes Monitoring Solution Developer
Microsoft Data Platform MVP (Award, 2002 ~ 현재)
MCT, Azure DBA, MCITP, MCDBA
SQL PASS Korea Chapter Leader
Email: jskim@sqlroad.com
Homepage: www.visualdb.net (인프런 쿠폰 코드 제공)
Youtube: 김정선 SQL TV
강의: 스킬서포트교육센터@서울
All
34 lectures ∙ (6hr 12min)
Course Materials:
4. Introduction
04:47
12. Introduction
04:32
13. What is SARG?
05:58
All
99 reviews
4.6
99 reviews
Reviews 4
∙
Average Rating 5.0
5
Thank you so much for the great lecture^^ If I just understand this lecture well, I think more than 80% of performance issue queries will disappear!!!
Thank you for the good review~ :D
Reviews 1
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 4.0
4
It feels like I'm learning the reasons behind things I've been using naturally. I have a slight regret that I wish it had gone a bit deeper into the content. The lecture is excellent!
Hello ytlee, I'm glad it was helpful. Thank you for leaving such a positive course review~ From Kim Jungsun
Reviews 1
∙
Average Rating 5.0
5
Good~
hansangmin9801, I'm glad I could help :D Have a happy end of the year~ From Kim Jeongseon
Limited time deal ends in 5 days
$92,400.00
30%
$102.30
Check out other courses by the instructor!
Explore other courses in the same field!
![[MMORPG Game Development Series with C# and Unity] Part 5: Database강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
![[ITⓔCoaching] Practical Data Management with Oracle강의 썸네일](https://cdn.inflearn.com/public/courses/327587/cover/8133dede-51cb-4410-949c-cd95aa80b7d6/327587-eng-original.jpg?f=avif&w=420)
