SQL Database Internals and Query Optimization

$259.00

  • EUR: €239.13
  • GBP: £204.95
  • NZD: $431.21
  • CAD: $351.33
  • AUD: $396.31

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.

Length: 2 Hours and 36 Minutes

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.

Be the first to review “SQL Database Internals and Query Optimization”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Product Enquiry

You may also like…