Essentials of SQL Server Performance for Every Developer – Course Introduction
Hello, I am Rajan Arora, and welcome to my course “Essentials of SQL Server Performance for Every Developer”. In this course, we are going to see what Every Developer should consider for SQL server performance.
Prerequisites for this Course
Before starting this course, i would like to tell prerequisites for this course
To follow along with the course you should have some experience with the development and you must have hands-on experience on SQL server because in this course we are concentrating on the performance tuning in SQL Server.
This course is for the Developers who wants to optimize the SQL server performance during their development
What you will learn (Course Overview)
Now I would like to tell you about the course modules and what you’re going to learn from this course.
This Course is divided into 6 Modules
1) First module is “Getting Started” in this module
- We will try to understand why developers should understand the performance of SQL servers.
- Restore the Demo Database which is going to be useful during the course
- What tools you require to follow along with the course and learn about the basics of Table and Index in SQL Server.
2) Second module is “Analyzing SQL Statement for Performance” In this module
- We will understand how SQL Server will execute the SQL statement.
- Reading and interpreting the execution plan of the SQL statement and going to see how we can optimize that SQL statement.
3) Third module is “Building Effective Indexes” in this module
- We will see that what are indexes
- How to select the columns for an index
- How indexes work with the Like clauses
- How functions in the where clause affects indexes
- Effects of Over Indexing
- Interpreting SQL Server Index Recommendations
4) Fourth module is “Finding Performance Bottlenecks in SQL Server”
- We will see the permission required for querying Dynamic Management views
- Information regarding the SQL server sessions and resource usage
- Finding what SQL server is currently executing
- Find the most expensive SQL statement running in the SQL server
- And most important finding the indexes that are not in use
5) The fifth module is “Capturing What Your Application is Doing Inside SQL Server” in this module.
- We will see what is SQL tracing and why developers should know about it
- What is SQL profiler and how we can use it
- What are Extended events and how developers can use them for tracing the SQL statements?
6) And the last and sixth module is “Applying Common Performance Practices for Better Performance” in this module we will see the common performance practices
- Like the use of Parameterized SQL
- Are Stored procedure is faster than SQL in application code
- Working of Object Relational Model (ORM)