M10999: SQL on Linux

2 Day Course
Hands On
Official Microsoft Curriculum
Code M10999

Book Now - 2 Delivery Methods Available:

Scheduled Virtual Onsite

Overview

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

Objectives

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server on Linux
  • Describe how to deploy SQL Server on Linux
  • Describe how to install the additional optional components to SQL Server
  • Describe how to configure SQL Server on Linux
  • Describe how to connect and manage SQL server images on Linux
  • Describe how to migrate databases from other database systems to SQL Server on Linux and provide disaster recovery
  • Describe the high availability features of SQL Server on Linux

Target Audience

The primary audience for this course is existing database professionals with experience of database systems running on Linux.
The secondary audience is Linux professionals who are interested in adding database capabilities.

Additional Information

Please note: for Attend from Anywhere customers an additional screen is required. The additional screen must have a minimum screen size of 19' and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

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.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.

Pricing

Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Sep Oct Nov Dec Jan Feb
M10999 2 Days $995

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections