M10999: SQL on Linux

2 Day Course
Hands On
Official Microsoft Curriculum
Code M10999

This course has been retired. Please view currently available Microsoft SQL Server Training Courses.

Modules

Hide all

Introduction to SQL Server on Linux (4 topics)

  • Why is SQL Server on Linux?
  • SQL Server on Linux capabilities
  • Containers
  • Linux SQL Server VM in Azure

Deploying SQL Server on Linux (9 topics)

  • Deploying SQL Server on Ubuntu
  • Deploying SQL Server on SUSE
  • Deploying SQL Server on Red Hat
  • Deploying SQL Server containers on Docker
  • Lab: Deploying SQL Server on Linux
  • Installing SQL Server
  • Installing command line tools
  • Creating a database
  • Create a SQL Server 2017 Docker container

Installing additional components (8 topics)

  • SQL Server agent
  • SQL Server full-text search
  • SQL Server integration services
  • Lab: Installing additional components
  • SQL Server agent
  • SQL Server full-text search
  • SQL Server integration services
  • Remove the Azure virtual machine

Configuring SQL Server on Linux (2 topics)

  • Configuring SQL Server with mssql-conf
  • Configure a SQL Server on Linux Docker image

Managing Database Solutions for SQL Server for Linux (3 topics)

  • Connecting to SQL Server on Linux
  • Managing SQL Server on Linux
  • Lab: Managing SQL Server on Linux

Migrating Databases to SQL Server on Linux and Disaster Recovery (8 topics)

  • Backup and restore
  • Database export and import
  • SQL Server migration assistant
  • Bulk copy program
  • SQL Server integration services
  • Lab: Migrating databases
  • Migrate a database with backup and restore
  • Migrate a database with SQL Server migration assistant

High Availability (6 topics)

  • Log shipping
  • Failover clustering
  • Availability groups
  • Lab: High availability
  • Configure log shipping
  • Create a read-scale availability group

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Familiarity with the SUSE, Red Hat, or Ubuntu operating system and networking.
  • Familiarity with the SQL language.

Course PDF

Print

Sections