Deep Dive T-SQL Performance Tuning
This course is designed to provide all the information and skills needed to become a highly skilled SQL Server Developer. It covers everything from indexing and statistical estimation to complex query constructs, optimizer tricks, execution plan analysis, architectural guidance, and much more.
SQL Server Database Administration
This course aims to provide you with all the knowledge you need to be a specialist SQL Server DBA. It covers all the basics and essentials from disaster recovery and baselining through to server configuration, index maintenance, and high availability, but then pushes on to database design analysis and architecture (CDC, Temporal Tables, partitioning, and In-Memory optimisations).