SQL Server on Linux

Intermediate
Data Engineer
SQL Server

SQL Server now runs on your choice of operating system. In this learning path you will 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 will then learn how to automatically tune your SQL Server on Linux deployment.

Prerequisites

Basic understanding of Linux administration and administration of relational databases.

Modules in this learning path

Learn the benefits of installing SQL Server on Linux.

Learn about the software and hardware prerequisites to run SQL Server on Linux and then discover the straightforward steps to install SQL Server on Linux. You will also learn additional tasks, such as installing command-line tools.

Database administrators often spend much time optimizing performance for their database queries. In SQL Server 2016 and later, you can use the Query Store feature to collect query performance information and view recommendations that may help accelerate responses. In SQL Server 2017, you can also use automatic tuning to configure the server to apply these recommendations. This module shows you how to collect performance data when using SQL Server 2017 on Linux servers by using Azure Data Studio and how to use Query Store and automatic tuning.

Containers provide isolated virtual environments in which you can run applications such as SQL Server 2017 and are growing in popularity because of their scalability. If you choose SQL Server 2017 to host your databases, you can run that system in one or more containers based on either Linux or Windows and the Docker system. You can create a container from an image that has SQL Server pre-installed or create your own customized image. In this module, you will see how to run SQL Server 2017 in Linux containers and host a custom database application.