SQL Database Internals and Query Optimization

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial per member

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.

Length: 2 Hours and 36 Minutes

$259.00
Or log in to access your purchased courses

Even the best logical model can’t help when the 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. 

Modules