Description
SQL Database Internals and Query Optimization
Even the best logical model can’t help when physical implementation is bad. Therefore, it is important to know how SQL Server, Azure SQL Database, and partially also Azure Synapse Analytics, store data in row and columnar format and how the engines access this data. You will learn about heaps, balanced trees, and columnar indexes. In addition, this course introduces query optimization for both, transactional and analytical queries.
Basic familiarity with SQL Server is recommended for this course. If you are a complete beginner in this area, then we recommend that you watch the Starting with SQL Server and Azure SQL Database course first.
Link to the agenda and sample videos from the course
Length: 2 Hours and 36 Minutes
Instructor
Dejan Sarka
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on the development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, SolidQ, and Pluralsight.
Reviews
There are no reviews yet.