» » Azure SQL and SQL Server Query Performance Tuning
Information of news
1-12-2020, 09:58

Azure SQL and SQL Server Query Performance Tuning

Category: Tutorials

Azure SQL and SQL Server Query Performance Tuning
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Difficulty: Intermediate | Genre: eLearning | Language: English | Duration: 12 Lectures (1h 26m) | Size: 1.6 GB

SQL is the language for interacting with databases, and like all computer languages, there are many ways to achieve the right result. And like other software languages, some ways will be better and more efficient than others. What sets SQL and database programming apart from most other computer programming is the vast amount of data that is regularly dealt with, and how other factors that are not immediately obvious can impact the SQL query code you write.

This course looks at ways that you can see how the SQL Server engine views your queries and how it intends to execute them. Using that information, we look at other factors like table and index design that can positively or negatively impact your query execution.

Learning Objectives
Understand what impacts query performance when using SQL
Learn how the SQL Server engine processes queries
Use execution plans to see how a query is executed
Instruct the query engine
Understand how different query types can be used
Learn how to design tables to make queries more efficient
Use database file configuration to improve performance
Understand how database compression can impact performance

Intended Audience
This course is aimed at database administrators, data engineers, or anyone who wants to learn how to improve database query execution.

To get the most out of this course, you should be familiar with SQL query syntax, SQL data types, and SQL table structure.


Azure SQL and SQL Server Query Performance Tuning

Download link:

Links are Interchangeable - No Password - Single Extraction


Site BBcode/HTML Code:

Tags to an Article: Azure, SQL, and, SQL, Server

Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.
free html hit counter