Practitioner Level
4 Hands-on labs

Microsoft SQL Server on Linux in Azure

By Landon Fowler

How to install, configure, and manage Microsoft SQL Server on Linux.

See Pricing
5 hours
  • 29 Lessons
  • 4 Hands-On Labs

About the course

Microsoft SQL Server is a robust relational database management system with a number of intriguing features. Starting with SQL Server 2017, it is now available on many operating systems, including Linux! In this course, we go over how to install, configure, and manage SQL Server on Linux. We highlight some of the key benefits that Azure brings to the table for our SQL Server strategy.

Whether you’re an experienced SQL Server professional coming from a Windows background or a Linux guru getting into MSSQL for the first time, this course has something to offer.

Lab Highlights

Backing Up and Recovering a SQL Server on Linux in Azure Configuring SQL Server on Linux in Azure Configuring User Access in SQL Server on Linux Deploying a SQL Server VM in Azure
Contact SalesSee Pricing
  • Chapter 1 4 Lessons Getting Started 7:51

    An Important Note About A Cloud Guru and Linux Academy Courses

    1:19

    Course Introduction

    1:30

    About the Training Architect

    0:48

    Database and RDBMS Introduction

    4:14
  • Chapter 2 7 Lessons Core Installation 1:30:05

    SQL Server on Linux Overview

    12:08

    CentOS Installation

    13:03

    Ubuntu Installation

    9:31

    Using Azure Images

    11:29

    SQL Server on Linux Containers

    5:47

    Azure SQL Database

    8:07

    Deploying a SQL Server VM in Azure

    30:00 Hands-On Lab
  • Chapter 3 5 Lessons Configuring Additional Features 1:10:11

    Configuring Connection Encryption

    10:55

    Configuring Full-Text Search

    5:04

    Enabling and Using SQL Server Agent

    6:46

    Installing and Configuring SSIS

    2:26

    Configuring SQL Server on Linux in Azure

    45:00 Hands-On Lab
  • Chapter 4 1 Lesson Updating 5:59

    Installing Updates

    5:59
  • Chapter 5 4 Lessons Authentication and Authorization 51:26

    Instance-Level

    4:25

    Database-Level

    4:05

    Configuring Active Directory Authentication

    12:56

    Configuring User Access in SQL Server on Linux

    30:00 Hands-On Lab
  • Chapter 6 1 Lesson Troubleshooting 9:04

    Troubleshooting Strategies and Tools

    9:04
  • Chapter 7 1 Lesson Managing with PowerShell 8:55

    Using SQL PowerShell

    8:55
  • Chapter 8 2 Lessons Always On Availability Groups 17:54

    Introduction to Always On Availability Groups

    10:39

    Configuring Always On Availability Groups

    7:15
  • Chapter 9 3 Lessons Backup and Recovery 47:24

    Planning and Performing Backups

    11:41

    Restoring Databases

    5:43

    Backing Up and Recovering a SQL Server on Linux in Azure

    30:00 Hands-On Lab
  • Chapter 10 1 Lesson Final Steps 3:08

    What's Next

    3:08

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
MyselfMy Organization
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Don't have an account?