Episode 11 of 15
For the full video series, click here: https://aka.ms/DP-300onYouTube
Explore normalization for relational databases. Investigate the impact of proper data type usage. Compare types of indexes. Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore Query Store hints. Next, move to a lab where you’ll learn how to identify and resolve database design issues. You’ll examine queries, troubleshoot problems, fix warning messages, and improve code for better performance and reliability. Then, move to another lab where you’ll learn how to troubleshoot and optimize poorly performing SQL queries. We’ll guide you through generating execution plans, resolving suboptimal plans, using Query Store to detect regressions, analyzing resource-heavy queries, and applying query hints for better performance.
Learn more about this course and take the certification exam to test your new skills: https://aka.ms/DP-300onLearn
Chapters
00:00 Video start
00:21 Explore performance-based database design
00:25 Objectives
20:12 Knowledge check
20:58 Demo: Identify database design issues
32:59 Evaluate performance improvements
33:11 Objectives
47:43 Knowledge check
48:31 Demo: Isolate problem areas in poorly performing queries in a SQL Database
01:15:01 Learning Path Recap
