Microsoft SQL Server on Linux Quick Start
Database Training Architect II
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.
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
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
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
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
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
Introduction to mssql-conf
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
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
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.
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
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.
Unsupported Features and Known Issues
This video covers some of the most relevant unsupported features and known issues of SQL Server on Linux.
Bringing It All Together
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.
In this video, we discuss future directions for a learning journey from here. Never stop learning!
A message from our founder and CEO, Anthony James, about getting recognized for the achievement of completing this course.