Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.

SQL Server Fundamentals to Advanced

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,

5 (10)
2 Lectures
4 Labs
Intermediate
6h 54m
Jul 8 2018
Mar 19 2019
5 (2)

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...

0%
Feb 23 2017
4 (5)

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

0%
Skill Me UP
Jan 10 2018
5 (1)

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.

0%
Skill Me UP
Jan 10 2018
4 (1)

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.

0%
Skill Me UP
Apr 2 2019
5 (1)

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.

0%
Skill Me UP
Apr 5 2019
0 (0)

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 ...

0%