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.
Azure SQL Database: Diagnosing Performance Issues with DMVs
Azure SQL Database: Diagnosing Performance Issues with DMVs
Limited Time Discount Offers
Save your money with Edvicer. Check out our premium courses with discount offers.
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.
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 easily query Azure SQL Database for performance and configuration information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for Azure SQL Database.
Syllabus
Course Overview
Introduction and DMV Queries
Diagnosing Issues and Benefits of DMV Queries
Course Details and Module Summary
Introduction and Database Properties
Demo: Database Properties
File Sizes and Space
Demo: File Sizes and Space
Database-scoped Configurations
Demo: Database-scoped Configurations
Table Properties
Demo: Table Properties
Query Store Options
Demo: Query Store Options
Automatic Tuning Options
Demo: Automatic Tuning Options
Module Summary
Introduction and CPU Utilization by Database
Demo: CPU Utilization by Database
Top Worker Time Queries
Demo: Top Worker Time Queries
SP Worker Time
Demo: SP Worker Time
High Aggregate CPU Queries
Demo: High Aggregate CPU Queries
Module Summary
Introduction and Lock Waits
Demo: Lock Waits
Scalar UDF Statistics
Demo: Scalar UDF Statistics
Input Buffer
Demo: Input Buffer
Query Execution Counts
Demo: Query Execution Counts
SP Execution Counts
Demo: SP Execution Counts
SP Average Elapsed Time
Demo: SP Average Elapsed Time
Bad Nonclustered Indexes
Demo: Bad Nonclustered Indexes
Missing Indexes
Demo: Missing Indexes
Missing Index Warnings
Demo: Missing Index Warnings
Overall Index Usage - Reads
Demo: Overall Index Usage - Reads
Overall Index Usage - Writes
Demo: Overall Index Usage - Writes
Volatile Indexes
Demo: Volatile Indexes
Recent Resource Usage
Demo: Recent Resource Usage
Module Summary
Introduction and Buffer Usage
Demo: Buffer Usage
SP Logical Reads
Demo: SP Logical Reads
I/O Statistics by File
Demo: I/O Statistics by File
SP Physical Reads
Demo: SP Physical Reads
SP Logical Writes
Demo: SP Logical Writes
Top I/O Statements
Demo: Top I/O Statements
Module and Course Summaries
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 Azure SQL Database: Diagnosing Performance Issues with DMVs
Similar Courses
Related Jobs
 | | |
Related Internships
| | |
Related Projects
| | |
