This course takes programming in SQL Server from the basic level to the advanced, providing students with tools and techniques that will allow them to write code for a broad range of requirements while optimizing performance.
Throughout the course, you get to analyze different case studies while comparing several approaches for each one and choosing the best solutions.
Your Instructor
I founded Madeira in 2007 with a simple vision: to do something that I love and to enjoy every minute of it. Today I feel so lucky to be in the position of leading such an extraordinary team of people. My focus is on creating a supporting environment to allow our professionals to achieve their full potential and to deliver the best solutions to our customers. I’m passionate about the community. I’m a SQL Server MVP and the leader of the Israeli SQL Server user group. Except for blogging and podcasting on a regular basis, I frequently speak at conferences and events around the world. I also love jogging. I start my day early in the morning with a one-hour run while listening to great music.
Course Curriculum
-
PreviewOpening (0:30)
-
PreviewCourse Introduction (6:58)
-
PreviewThe Plan Cache (15:30)
-
StartHow to Find the Problematic Query (24:01)
-
StartThe ARITHABORT Problem (15:03)
-
StartExecution Plan Analysis Part 1 (31:56)
-
StartHow to Measure Query Performance (17:05)
-
StartExecution Plan Analysis Part 2 (31:13)
-
StartQuery Hints and Plan Guides (15:00)
-
StartParameter Sniffing Issues (33:57)
-
StartMore Tuning Case Studies (32:13)
-
StartCourse Summary (12:28)