Unlock the power of SQL functions with SQL Server Functions for Smart Data Handling. This course will teach you advanced data manipulation techniques and function optimization.

SQL Server is one of the most popular database systems out there being used by enterprises of all sizes, verticals, and regions. This course will teach you a programmability feature called functions, which allows you to create reusable code.

SQL Server now runs on your choice of operating system. In this learning path, you'll discover the fundamentals of SQL Server on Linux, before discovering how to run SQL Server on Linux containers and deploy SQL Server on Linux. You'll then learn how to automatically tune your SQL Server on Linux deployment.

SQL Server performance tuning is an art to master - for developers and DBAs alike. This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems. This includes an introduction to understanding execution plans inside SQL Server.

Looking to generate and share reports with your organization? In this course you'll get up and running with SQL Server Reporting Services quickly, or just refresh yourself on specific techniques when creating reports.

In this course, you will learn essential concepts and practical techniques needed to effectively secure SQL Server databases, including authentication, authorization, encryption, management of principals, objects, and role-based security.

This course will teach you the fundamentals of manipulating and optimizing time series data in SQL Server.

This course will teach you everything you need to know as a developer to start making sense of query plans and improving query performance. Apart from developers, this course is also applicable to anyone who is responsible for SQL Server performance.

This course will teach you how to correctly choose indexes for your environment. You'll also learn how to understand index internals, how indexes are used, and much more.

Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance.

One of the most highly anticipated new features in SQL Server 2016 is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and run-time statistics.

Learn everything there is to know about how logging, recovery, and the transaction log work so you can avoid and recover from transaction log problems, applicable for anyone responsible for SQL Server, from SQL Server 2005 onwards