YoVDO

SQL Server on Linux

Offered By: Microsoft via Microsoft Learn

Tags

SQL Courses Relational Databases Courses Database Deployment Courses

Course Description

Overview

  • Module 1: In this module, you will learn about running SQL Server 2019 on Linux servers and containers.

    • In this module, you will:

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

    • In this module, you will:

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

    • In this module, you will:

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

    • In this module, you will:

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

Syllabus

  • Module 1: Introduction to SQL Server on Linux
    • Introduction
    • What is SQL Server on Linux?
    • SQL Server on Linux features
    • Tools for SQL Server on Linux
    • Use containers with SQL Server on Linux
    • Summary
  • Module 2: Deploy SQL Server on Linux
    • Introduction
    • Deploy SQL Server on Ubuntu
    • Exercise - Install SQL Server on Ubuntu
    • Deploy SQL Server on SUSE
    • Exercise - Install SQL Server on SUSE
    • Deploy SQL Server on Red Hat
    • Exercise - Install SQL Server on Red Hat
    • Deploy SQL Server on a container
    • Exercise - Install SQL Server on a container
    • Knowledge check - client tools
    • Summary
  • Module 3: Automatically tune SQL Server on Linux
    • Introduction
    • Monitor SQL performance in Linux
    • Exercise - Monitor SQL performance in Linux
    • Choose to use Query Store and automatic tuning
    • Configure SQL Server to use Query Store and autotuning
    • Summary
  • Module 4: Run SQL Server 2019 on Linux containers
    • Introduction
    • Choose to run SQL Server on Linux containers
    • Exercise - Run SQL Server 2019 on Linux containers
    • Create custom images
    • Exercise - Create a custom Docker image
    • Use Docker Compose to deploy multiple containers
    • Exercise - Use Docker Compose to deploy multiple containers
    • Summary

Tags

Related Courses

Build With Amazon DocumentDB (with MongoDB compatibility)
Amazon Web Services via AWS Skill Builder Building VPC, S3, EC2, and RDS Products with AWS Service Catalog (Korean)
Amazon Web Services via AWS Skill Builder AWS Certified Solutions Architect
LearnKartS via Coursera Deploying an Open Source Cassandra™ Database using the GCP Marketplace
Google via Google Cloud Skills Boost Exam Readiness: AWS Certified Database - Specialty
Amazon Web Services via AWS Skill Builder