Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

SQL Server 2016 on Linux

( Duration: 2 Days )

The SQL Server 2016 on Linux training course is aimed at database professionals looking to implement SQL Server on Linux.

By attending SQL Server 2016 on Linux workshop, delegates will learn 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

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

The SQL Server 2016 on Linux class is ideal for:

  • The primary audience being existing database professionals with experience of database systems running on Linux.
  • The secondary audience being Linux professionals who are interested in adding database capabilities.

COURSE AGENDA

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
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
3

Installing Additional Components

  • SQL Server Agent
  • SQL Server Full-Text Search
  • SQL Server Integration Services
4

Configuring SQL Server on Linux

  • Configuring SQL Server with mssql-conf
  • Configure SQL Server on Linux Docker Image
5

Managing Database Solutions for SQL Server for Linux

  • Connecting to SQL Server on Linux
  • Managing SQL Server on Linux
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
7

High Availability

  • Log Shipping
  • Failover Clustering
  • Availability Groups

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top