Improving Query Performance in SQL Server

Course Cover

5

(3)

compare button icon
Course Report - Improving Query Performance in SQL Server

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

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

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

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