Loading...

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 

Prerequisites

Advanced SQL or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
SQL Query Optimization
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Apr 26, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 24, 2024
Transfer Request Deadline
Apr 24, 2024
Section Title
SQL Query Optimization
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Apr 26, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 24, 2024
Transfer Request Deadline
Apr 24, 2024
Required fields are indicated by .