Share Description
In this course, you will :
- Learn how to use SQL code formatting, commenting, and aliasing to make queries easier to read and understand.
- Students will also learn about query processing order in the database versus query syntax order in a query.
- introduces WHERE and HAVING filtering, as well as some best practises for how (and how not) to use these keywords.
- Learn about data interrogation methods and the effects they may have on performance.
- introduction to subqueries and their possible effects on query performance
- Learn how to use SQL Server's STATISTICS TIME, STATISTICS IO, indexes, and execution plans to help analyse and tune query performance.
Syllabus :
- Introduction, Review and The Order of Things
- Filtering and Data Interrogation
- Sub-queries and presence or absence
- Query performance tuning
