- Module 1: In this module, you will learn about running SQL Server 2019 on Linux servers and containers.
- Describe the key benefits of running SQL Server on Linux
- Describe both Windows and cross-platform tools that can be used to administer SQL Server on Linux
- Describe the benefits of running SQL Server on Linux virtual machines
- Describe the benefits of running SQL Server on container runtime environments, such as Docker
- Module 2: 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.
- Deploy SQL Server 2019 on Ubuntu
- Deploy SQL Server 2019 on SUSE
- Deploy SQL Server 2019 in Red Hat
- Deploy a SQL Server 2019 Linux container image to Docker
- Module 3: In this module, you will learn how to monitor and optimize the performance of SQL Server on Linux servers.
- Decide whether to enable Query Store.
- Use Azure Data Studio to monitor performance in SQL Server on a Linux server.
- Configure Query Store on a Linux server and use the recommendations it provides.
- Enable automatic tuning in SQL Server on a Linux server.
- Module 4: In this module, you will learn how to use Docker containers on Linux operating systems to host SQL Server installations.
- Install a container host on a Linux server.
- Manage containers.
- Create a container from an image that includes SQL Server 2019.
- Create a customized container image.
- Run a database application with a web front-end in containers.
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will: