SQL Server Fundamentals to Advanced
In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,
The course will teach you the fundamentals of the relational database model and how to access data stored in relational databases. The course will give students an understanding of relational database concepts and teach the practical application of these concepts through the T-SQL programming langua...
In this lab, you will learn the fundamentals of creating databases, tables, views and relationships using Microsoft SQL Server. You will gain experience using SQL Server Management Studio (SSMS) and learn introductory concepts of writing T-SQL queries.
In this lab, you will explore the new SQL Server 2016 real-time operational analytics feature. You will evaluate the performance improvements you will get when you add updateable nonclustered columnstore indexes on top of disk-based tables as well as memory-optimized tables.
In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.
In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.
In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries ...