Skip to main content

Microsoft SQL Server on Linux Quick Start

Course

Intro Video

Photo of Landon Fowler

Landon Fowler

Database Training Architect II

Length

02:43:05

Difficulty

Beginner

Videos

14

Hands-on Labs

2

Course Details

Microsoft SQL Server is a leading relational database management system (RDMS), and now it's available on Linux! Let's take a quick look at how to install and configure SQL Server on Linux, whether we're using a traditional machine, containers, or an Azure SQL VM. We cover how to connect to and manage this popular RDMS using a variety of tools running on our favorite operating system.

https://interactive.linuxacademy.com/diagrams/MicrosoftSQLServer.html

Syllabus

Course Introduction

Getting Started

Course Introduction

00:00:58

Lesson Description:

Welcome to the quick start course for Microsoft SQL Server on Linux! In this video we talk about what lies ahead for us in this course as well as some of the learning tools available to help.

About the Training Architect

00:00:36

Lesson Description:

Hi! I'd like to introduce myself. In this video, I give you a very quick synopsis of who I am and what my background is. It's nice to meet you!

Installation and Configuration

Installation and Initial Configuration

Linux

00:10:19

Lesson Description:

In this video we walk through the installation of SQL Server on Linux. This includes using yum to install the software, mssql-conf to perform the initial configuration on the instance, and connecting via SQLCMD to create a database. For Microsoft's full documentation, reference https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017

Docker

00:06:24

Lesson Description:

In this video we take a different approach to running SQL Server on Linux by using a container. This includes pulling the SQL Server image, running the container, connecting to the container, and running SQLCMD to create a database. For Microsoft's full documentation, reference https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017&pivots=cs1-bash

Azure SQL Server VM

00:07:34

Lesson Description:

In this video we use an image from the Azure Marketplace to get up and running with SQL Server. This inclues deploying the virtual machine in Azure, connecting to it via SSH, and using SQLCMD to create a database. For Microsoft's full documentation, reference https://docs.microsoft.com/en-us/azure/virtual-machines/linux/sql/provision-sql-server-linux-virtual-machine?toc=/sql/toc/toc.json

Hands-on Labs are real live environments that put you in a real scenario to practice what you have learned without any other extra charge or account to manage.

01:00:00

Further Configuration

Introduction to mssql-conf

00:05:09

Lesson Description:

In this video, we introduce mssql-conf, Microsoft's configuration utility for SQL Server on Linux. This includes a high-level overview of what the utility is, what it can do, and how you interact with it. For Microsoft's full documentation, reference https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017

Common Configuration Examples

00:06:22

Lesson Description:

In this video, we take a closer look at mssql-conf, using it to accomplish some common configuration tasks. For Microsoft's full documentation, reference https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017

Client Tools

SQLCMD

00:09:20

Lesson Description:

In this video, we take a closer look at SQLCMD, the client utility we've used throughout the course. We go over some of its capabilities and tips for how to get the most out of it.

VS Code

00:08:14

Lesson Description:

In this video, we work with Visual Studio Code, Microsoft's cross-platform code editor. We discover how to connect to SQL Server on Linux and look at the benefits of using this client to write our queries.

SQL Server Management Studio

00:05:24

Lesson Description:

In this video, we use SQL Server Management Studio to interact with our SQL Server on Linux instance. We learn its strengths and weaknesses compared to the other clients, and how it can help level up our SQL DBA game.

Limitations

Unsupported Features and Known Issues

00:06:32

Lesson Description:

This video covers some of the most relevant unsupported features and known issues of SQL Server on Linux.

Conclusion

Final Steps

Bringing It All Together

00:03:44

Lesson Description:

In this video, we pull together all of the concepts we've discussed throughout our time together, using the course diagram to illustrate what's been built.

What's Next?

00:01:36

Lesson Description:

In this video, we discuss future directions for a learning journey from here. Never stop learning!

Get Recognized

00:00:46

Lesson Description:

A message from our founder and CEO, Anthony James, about getting recognized for the achievement of completing this course.

Take this course and learn a new skill today.

Transform your learning with our all access plan.

Start 7-Day Free Trial