MS-10999 - SQL Server on Linux

This two-day instructor-led course is aimed at introducing database professionals to SQL Server on Linux.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »

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.

Detailed Class Syllabus


Module 1: Introduction to SQL Server on Linux


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

Module 2: Deploying SQL Server on Linux


Deploying SQL Server on Ubuntu
Deploying SQL Server on SUSE
Deploying SQL Server on Red Hat
Deploying SQL Server containers on Docker

Module 3: Installing additional components


SQL Server agent
SQL Server full-text search
SQL Server integration services

Module 4: Configuring SQL Server on Linux


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

Module 5: Managing Database Solutions for SQL Server for Linux


Connecting to SQL Server on Linux
Managing SQL Server on Linux

Module 6: Migrating Databases to SQL Server on Linux and Disaster Recovery


Backup and restore
Database export and import
SQL Server migration assistant
Bulk copy program
SQL Server integration services

Module 7: High Availability


Log shipping
Failover clustering
Availability groups