SQL Server on Linux (10999)

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

Key Features of this Training:

You Will Learn How 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

Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals

ON DEMAND

On Demand + Instructor Coaching

  • The same high quality MOC content as the live event
  • Flexibility to take the course on your own time, at your own pace
  • Enjoy a blend of video, text, hands-on labs, and knowledge checks with on demand training
  • Forever access to the digital course materials – including future course content updates
View Details & Schedule ›

Standard $1195

Government $1195

GET STARTED

PRODUCT #8507

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • 2-day instructor-led training course
  • One-on-one after-course instructor coaching
  • After-course computing sandbox
  • Pay later by invoice -OR- at the time of checkout by credit card
View Details & Schedule ›

Standard $2225

Government $1950

GET STARTED

PRODUCT #8507

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organization
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Contact Us for Team Pricing

GET STARTED

Save More On Training with FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

On Demand + Instructor Coaching

SQL Server on Linux On-Demand Training Information

  • On-Demand Training Description

    With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.

    PLUS, we include access to a Microsoft Certified Trainer(MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!

    • Flexibility to take the course on your own time, at your own pace
    • Forever access to the digital course materials – for any refreshers
    • You will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months
    • Upon course activation, the MOC On Demand videos and labs are available for three months
    • 2 FREE hours of individual coaching from an MCT Learning Tree Instructor
    • This delivery is also eligible for Microsoft Assurance Training Vouchers(SATVs)
    • NOTE: Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit

SQL Server on Linux On-Demand Training Outline

  • Module 1: Introduction to SQL Server on Linux

    Describe key capabilities and components of SQL Server on Linux.

    Lessons

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

    After completing this module, students will be able to:

    • Explain why SQL Server is on Linux and it’s capabilities
    • Describe containers
    • Describe the SQL Server on Linux VM
  • Module 2: Deploying SQL Server on Linux

    This module examines deploying SQL Server to a number of common Linux instances.

    Lessons

    • 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

    After completing this module, you will be able to:

    • Deploy and configure SQL Server 2017 on Ubuntu servers.
    • Deploy and configure SQL Server 2017 on SUSE servers.
    • Deploy and configure SQL Server 201y in Red Hat servers.
    • Pull and run a SQL Server 2017 image in a Docker Container.
  • Module 3: Installing additional components

    When you install the SQL Server on Linux with the mssql-server package, only the core database engine is installed. Additional components, such as SQL Server Agent, Full-Text Search and SQL Server Integration Services must be installed from separate packages. This module covers the installation process for these additional components.

    Lessons

    • 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

    After completing this module, you will be able to:

    • Install SQL Server Agent on RHEL, SLES, and Ubuntu.
    • Install SQL Server Full-Text Search on RHEL, SLES, and Ubuntu.
    • Install SQL Server Integration Services on RHEL and Ubuntu.
  • Module 4: Configuring SQL Server on Linux

    Once a Microsoft SQL Server on Linux instance is installed, you must configure it. Since SQL Server on Linux does not include a Linux-native GUI tool for configuring SQL Server settings, you must use command-line tools and options to configure aspects of the SQL Server behavior. This module covers configuring SQL Server on Linux and SQL Server on Linux Docker containers.

    Lessons

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

    After completing this module, you will be able to:

    • After completing this module, students will be able to:
    • Configure SQL Server on Linux with mssql-conf
    • Configure SQL Server on Linux Docker containers
  • Module 5: Managing Database Solutions for SQL Server for Linux

    Once you have installed and configured Microsoft SQL Server on Linux, you need to know how to connect to your SQL Server on Linux instance, both to manage SQL Server and to connect your applications to SQL Server. In this module, you will learn about several ways that developers and administrators can connect to SQL Server instances running on Linux..

    Lessons

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

    Lab : Managing SQL Server on Linux

    • Connect to SQL Server on Linux
    • Manage SQL Server on Linux

    After completing this module, you will be able to:

    • Describe different ways to connect to SQL Server on Linux
    • Describe how to manage SQL Server on Linux
  • Module 6: Migrating Databases to SQL Server on Linux and Disaster Recovery

    Once you are familiar with the basic operation of Microsoft SQL Server on Linux, you are likely to need to import data. The data you import might take the form of whole databases that you are migrating to SQL Server on Linux from SQL Server on Windows, or from another RDBMS. You might also need to import data to or export data from individual tables or groups of tables in your databases. This module introduces various techniques for moving data and databases to and from SQL Server on Linux.

    Lessons

    • 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

    After completing this module, you will be able to:

    • Move SQL Server databases with backup and restore.
    • Move SQL Server databases with database import and export.
    • Use SQL Server Migration Assistant to import databases from other RDBMS platforms to SQL Server.
    • Use the Bulk Copy Program to import and export data.
    • Use SQL Server Integration Services to import and export data.
  • Module 7: High Availability

    SQL Server on Linux can power mission-critical database systems with high-availability technologies at several different granularities. Log shipping provides high availability for single databases. Failover clustering provides automatic failover and redundancy for SQL Server instances. Availability groups provide high availability, disaster recovery, and read load balancing for groups of databases. This module covers configuring these technologies for SQL Server on Linux.

    Lessons

    • Log shipping
    • Failover clustering
    • Availability groups

    Lab : High availability

    • Configure log shipping
    • Create a read-scale availability group

    After completing this module, you will be able to:

    • Configure log shipping.
    • Configure failover clustering.
    • Configure availability groups.

In Class & Live, Online Training

  • Jan 14 - 15 (2 Days)
    9:00 AM - 4:30 PM EST
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Mar 25 - 26 (2 Days)
    9:00 AM - 4:30 PM EDT
    New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • May 6 - 7 (2 Days)
    9:00 AM - 4:30 PM EDT
    Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Jul 22 - 23 (2 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Sep 23 - 24 (2 Days)
    9:00 AM - 4:30 PM EDT
    New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

SQL Server on Linux Course Information

  • Requirements

    • 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.
  • Redeem Your Microsoft Training Vouchers (SATV):

  • Industry Credits & Certification

    This course offers you the opportunity to earn the following industry credits and certifications:

    • 11 NASBA Credits (live, in-class attendance required)

SQL Server on Linux Course Outline

  • Module 1: Introduction to SQL Server on Linux

    Describe key capabilities and components of SQL Server on Linux.

    Lessons

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

    After completing this module, students will be able to:

    • Explain why SQL Server is on Linux and it’s capabilities
    • Describe containers
    • Describe the SQL Server on Linux VM
  • Module 2: Deploying SQL Server on Linux

    This module examines deploying SQL Server to a number of common Linux instances.

    Lessons

    • 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

    After completing this module, you will be able to:

    • Deploy and configure SQL Server 2017 on Ubuntu servers.
    • Deploy and configure SQL Server 2017 on SUSE servers.
    • Deploy and configure SQL Server 201y in Red Hat servers.
    • Pull and run a SQL Server 2017 image in a Docker Container.
  • Module 3: Installing additional components

    When you install the SQL Server on Linux with the mssql-server package, only the core database engine is installed. Additional components, such as SQL Server Agent, Full-Text Search and SQL Server Integration Services must be installed from separate packages. This module covers the installation process for these additional components.

    Lessons

    • 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

    After completing this module, you will be able to:

    • Install SQL Server Agent on RHEL, SLES, and Ubuntu.
    • Install SQL Server Full-Text Search on RHEL, SLES, and Ubuntu.
    • Install SQL Server Integration Services on RHEL and Ubuntu.
  • Module 4: Configuring SQL Server on Linux

    Once a Microsoft SQL Server on Linux instance is installed, you must configure it. Since SQL Server on Linux does not include a Linux-native GUI tool for configuring SQL Server settings, you must use command-line tools and options to configure aspects of the SQL Server behavior. This module covers configuring SQL Server on Linux and SQL Server on Linux Docker containers.

    Lessons

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

    After completing this module, you will be able to:

    • After completing this module, students will be able to:
    • Configure SQL Server on Linux with mssql-conf
    • Configure SQL Server on Linux Docker containers
  • Module 5: Managing Database Solutions for SQL Server for Linux

    Once you have installed and configured Microsoft SQL Server on Linux, you need to know how to connect to your SQL Server on Linux instance, both to manage SQL Server and to connect your applications to SQL Server. In this module, you will learn about several ways that developers and administrators can connect to SQL Server instances running on Linux..

    Lessons

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

    Lab : Managing SQL Server on Linux

    • Connect to SQL Server on Linux
    • Manage SQL Server on Linux

    After completing this module, you will be able to:

    • Describe different ways to connect to SQL Server on Linux
    • Describe how to manage SQL Server on Linux
  • Module 6: Migrating Databases to SQL Server on Linux and Disaster Recovery

    Once you are familiar with the basic operation of Microsoft SQL Server on Linux, you are likely to need to import data. The data you import might take the form of whole databases that you are migrating to SQL Server on Linux from SQL Server on Windows, or from another RDBMS. You might also need to import data to or export data from individual tables or groups of tables in your databases. This module introduces various techniques for moving data and databases to and from SQL Server on Linux.

    Lessons

    • 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

    After completing this module, you will be able to:

    • Move SQL Server databases with backup and restore.
    • Move SQL Server databases with database import and export.
    • Use SQL Server Migration Assistant to import databases from other RDBMS platforms to SQL Server.
    • Use the Bulk Copy Program to import and export data.
    • Use SQL Server Integration Services to import and export data.
  • Module 7: High Availability

    SQL Server on Linux can power mission-critical database systems with high-availability technologies at several different granularities. Log shipping provides high availability for single databases. Failover clustering provides automatic failover and redundancy for SQL Server instances. Availability groups provide high availability, disaster recovery, and read load balancing for groups of databases. This module covers configuring these technologies for SQL Server on Linux.

    Lessons

    • Log shipping
    • Failover clustering
    • Availability groups

    Lab : High availability

    • Configure log shipping
    • Create a read-scale availability group

    After completing this module, you will be able to:

    • Configure log shipping.
    • Configure failover clustering.
    • Configure availability groups.

Team Training

SQL Server on Linux Training FAQs

  • Who should attend this course?

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

100% Satisfaction Guaranteed

Questions about which training is right for you?

Your Training Comes with a 100% Satisfaction Guarantee!*

call 888-843-8733
chat Live Chat




Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français