Improving Query Performance in SQL Server

Name: Improving Query Performance in SQL Server
Brand: Careervira
Price: 150 USD
Availability: InStock
Rating: 1 (1 reviews)

via

DataCamp

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.

Visit Course Report

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

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

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

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 will also be introduced to query processing order in the database versus the order of the SQL syntax in a query

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

Course Content

Expand all sections

Module 1: Introduction, Review and The Order of Things

Module 2: Filtering and Data Interrogation

Module 3: Sub-queries and presence or absence

Module 4: Query performance tuning

Course Instructors

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. ...