Information Technology
Hands on Training icon
Hands On Training
Hands on Training icon

Improving Query Performance in SQL Server

Course Cover

5

(3)

compare button icon

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

For a mission-critical assignment, your SQL coding skills will be crucial. You are given code to fix. It is not fast or well-structured, but it does provide the results you need. It is therefore difficult to comprehend. Tomorrow is the deadline. You will need to reformat the code in order to improve performance. Now is the time to get involved! This course will teach you how to use SQL to analyze real-world data from sports and geoscience. This course will discuss good coding practices as well as how to improve query performance in order to get the same result.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

check-card-img

Intermediate SQL Server

What You Will Learn

check-card-img

In this course, students will learn to write queries that are both efficient and easy to read and understand

check-card-img

You’ll need to reformat the code and try different methods to improve performance

check-card-img

Students will also be introduced to query processing order in the database versus the order of the SQL syntax in a query

check-card-img

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

check-card-img

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

Author Image

Dean Smith

Founder, Atamai Analytics

Dean Smith is geoscientist specializing in information management systems for mining and mineral exploration. He has more than ten years of experience working with SQL Server and data visualization. ...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover