Course Features
Duration
4 hours
Delivery Method
Online
Available on
Limited Access
Accessibility
Mobile, Desktop, Laptop
Language
English
Subtitles
English
Level
Intermediate
Teaching Type
Self Paced
Video Content
4 hours
Course Description
Course Overview
Virtual Labs
International Faculty
Post Course Interactions
Hands-On Training,Instructor-Moderated Discussions
Skills You Will Gain
Prerequisites/Requirements
Intermediate SQL Server
What You Will Learn
In this course, students will learn to write queries that are both efficient and easy to read and understand
You’ll need to reformat the code and try different methods to improve performance
Students will also be introduced to query processing order in the database versus the order of the SQL syntax in a query
Students are introduced to how STATISTICS TIME, STATISTICS IO, indexes, and executions plans can be used in SQL Server to help analyze and tune query performance
Students are introduced to how STATISTICS TIME, STATISTICS IO, indexes, and executions plans can be used in SQL Server to help analyze and tune query performance
Course Instructors
Course Reviews
Average Rating Based on 3 reviews
100%