Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

SQL Server: Query Plan Analysis

SQL Server: Query Plan Analysis

1425/month
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Intermediate
Login to earn ₹ 100

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Why should you choose this course?

Description

Learn how to interpret and analyze SQL Server query plans, making performance problems easier to recognize and understand, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards

Syllabus

Course Introduction
Why Do We Care About QPs?
What Doesn't a Query Plan Tell Us?
Course Structure
Module Introduction
Capturing a Plan
Demo: Capturing a Plan
Why Deprecate?
DMOs
Demo: DMOs
SQL Trace and Extended Events
Demo: Using Extended Events to Capture Execution Plans
Graphical Showplan
Demo: Graphical Showplan
SQL Sentry Plan Explorer
Demo: SQL Sentry Plan Explorer
Estimated vs. Actual
Demo: Estimated vs. Actual
Module Introduction
Iterators / Operators
Query Tree
Operator Cost (1)
Operator Cost (2)
Demo: Operator Cost
Operator Memory (1)
Operator Memory (2)
Demo: Operator Memory
Module Introduction
Table and Index Scans
Demo: Table and Index Scans
Index Seeks
Demo: Index Seeks
Lookups
Demo: Lookups
Join Considerations
Outer / Inner Terminology
Demo: Outer / Inner Terminology
Nested Loop
Demo: Nested Loop
Merge Join
Demo: Merge Join
Hash Match Join
Demo: Hash Match Join
Filter
Demo: Filter
Stream Aggregate
Demo: Stream Aggregate
Hash Match (Aggregate)
Demo: Hash Match Aggregate
Sort
Demo: Sort
Spools
Eager Spool and 'Halloween Protection'
Demo: Eager Spool
Constant Scan
Demo: Constant Scan
Assert
Demo: Assert
Compute Scalar
Demo: Compute Scalar
Identifying Parallelism in the Plan
Exchange Operators
Demo: Exchange Operators
Bitmap
Demo: Bitmap
Merge Interval
Demo: Merge Interval
Concatenation
Demo: Concatenation
Segment and Sequence Project
Demo: Segment and Sequence Project
Module Introduction
The 'Basics'
Demo: Missing index warnings
Lookups
Nested Loop Patterns
Merge Join Patterns
Demo: Merge Join Overhead
Hash Join Patterns
Demo: Hash Join Spills
Stop-and-Go Operators
Sort Patterns
Aggregates
Predicates
Spool Overhead
Parallelism Performance Aspects
Data Modification Plan Patterns
Demo: Data Modification Plan Patterns
Cardinality Estimate Issues
Data Type Conversions
PlanAffectingConvert
Demo: PlanAffectingConvert
NoJoinPredicateWarning
ColumnsWithNoStatistics Warning
Parameter Sniffing
Demo: Parameter Sniffing
Columnstore Index Execution Mode
Course Summary

What others say about this course

FAQs

What is SQL?

Structured Query Language (SQL) is a domain-specific language designed for data management for RDBMS. SQL comes particularly handy in managing structured data and offers certain advantages, such as allowing the access of multiple records through a single command and eliminating the need to specify how to access a record. In simpler words, SQL provides tools to the programmer to define, control and manipulate data in a relational model including tables, rows, and columns.

What are the Prerequisites for learning SQL?

If you wish to learn SQL programming, know the prerequisites well for a smooth learning journey. SQL is a basic query language used primarily for databases, coming with no prerequisites as such. With a simple syntax, there aren't many specific requirements, but it would be helpful to learn database concepts, calculus theories, and basic RDBMS concepts. Once you get a hold of these concepts, you are good to go.

Why should you learn SQL?

SQL query is purely a text message application which can help you access data. SQL is used for most relational storage systems, and it is more of a query language than a programming language. Learning SQL helps the programmers in accessing data with greater efficiency through basic queries. It is predominantly effectual for data manipulation, and the data stored in SQL is dynamic, which means it can be manipulated and modified at any point of time using a set of basic queries. These features make SQL fully equipped to manage datasets of all shapes and sizes.

How can Edvicer help you find the best SQL courses?

Edvicer is a great place to learn SQL with a large number of SQL courses, both free and paid, and projects, both for practice and freelancing. Edvicer has helped a large number of people learn SQL online through the best courses from the top providers like Coursera, Udemy, Udacity, and Pluralsight.

What are the top jobs that I can get from learning SQL?

The top job profile for SQL experts are Dotnet Developer with an average salary of INR 5 LPA, Software Engineer with an average salary of INR 7 LPA, and Database Administrator with an average salary of INR 7 LPA. Get your career map for your skills here.

What can I learn after learning SQL?

After learning SQL, the top skills you can learn to open highest number of job profiles for you are Python, Java, and Data Analytics. The top skills that can get you jobs with highest salaries are Node.js, Data Mining, and Statistical Modeling

Write your review of SQL Server: Query Plan Analysis

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer