SQL Server Performance for Developers – Learn how to use SQL Server for developers
Developers face an array of challenges when trying to develop performant applications for Microsoft SQL Server. In this course, instructor Joey D’Antoni shares concepts and strategies that can help you enhance your app’s performance on SQL Server. Throughout this course, Joey walks through best practices for building efficient, scalable database applications. He covers an array of topics, including execution plans, columnstore indexes, datatypes, temporary objects, and what not to do with SQL Server. He also goes over indexing, and shares how best to create temporary objects.
– Query execution
– How to read an execution plan
– What not to do with SQL Server
– Why cursors are bad
– Why scalar UDFs are expensive
– Datatypes and design
– What is a columnstore index?
– Transaction isolation
Language of instruction: English
Teacher: Joey D’Antoni
Level of training :, Secondary
Training Time: 3 hours + 44 minutes
File Size: 358 MB