SQL Server Indexing for Developers

SQL Server indexes not working as expected? Learn how they really work and how to design effective ones.

Course Summary

Need to know any of the following? Need to fix the situation fast?

  • How SQL Server indexes work
  • How to design SQL Server indexes
  • Why SQL Server seems to be ignoring the indexes that you designed
  • How data type choices affect indexes
  • If filtered indexes would work better in your application
  • How to check whether or not SQL Server "likes" your index
  • How to avoid having too many indexes
  • Which indexes you can remove
If so, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.

Greg Low

Instructor

Dr Greg Low is an international consultant, developer and trainer. He has been working in development since 1978, holds a PhD in Computer Science and a host of Microsoft certifications. Greg was the first certified master for SQL Server world-wide. He is the Managing Director for SQL Down Under, a Data Platform (SQL Server) MVP, host of the popular SQL Down Under podcast series, and a member of the Microsoft Regional Director program.

Course Curriculum

Course Pricing