The primary audience for this course is individuals who are database administrators and database engineers. The secondary audience of this course is individuals who work with Microsoft SQL Server as a software engineer, technical lead or an architect.
This course requires that you meet the following prerequisites:
Working knowledge of data related solutions
Working knowledge on Microsoft SQL Server database
Working knowledge on T-SQL
After completing this course, you will be able to:
Describe design considerations of Microsoft SQL Server databases.
Describe design considerations of Microsoft SQL Server tables.
Describe table structures such as heap and cluster.
Describe indexing types: Rowstore and Columnstore.
Describe how to use and maintain indexes.
Describe statistics and why they are important.
Describe how to handle locks and blocks.
Describe concurreny issues and how to handle them.
Describe how to use memory-optimized tables and natively compiled procedures.