CS325 - SQL Query Optimization

Course Description

Understand how the order of query processing may vary in the database from the syntax order in the query because of the SQL Order of Operations. Learn to make your SQL Queries easy to read and modify using formatting, comments, and aliases. Discover how to filter data and the best methods for using the Where and Having clauses. Understand how to analyze and tune your query performance. Learn to manage duplicates and when to use Distinct. Understand how to use union to get the same format of results from two different queries. Topics include using sub-query versus inner join and working with an execution plan. Additional topics include the importance of indexes, the impact of sorting, overriding the Query Optimizer, and using SQL Server statistics to improve query optimization.

In this course, you will learn to: 

• SQL order of operations 

• Analyze an execution plan of your query 

• Use the query execution plan to improve your query performance 

• Use formatting, comments, and aliasing to make your queries easier to read and maintain 

• Reduce the data returned to what is needed, by improving query filtering 

• Sort affect on query efficiency 

• Reduce duplication of data, and when and how to use distinct to prevent duplication 

• Create stored procedures to pre-compile the query, making query execution faster 

• Use a sub-query, inner join or CTE by looking at the execution plan 

• Use unions with results that are complete and efficient 

• Learn when to use views and when to use tables 

• Use indices to improve query speed 

• Create and update indices 

• Use statistics in your query 

• Create and update statistics to improve your results 

Applies Towards the Following Certificates

• Data Analysis Certificate : Core Courses
• Database Technology Certificate : Core Courses
• Programming Certificate : Required Courses
• Python Data Analysis Certificate : Electives