MOC 10999 - SQL Server on Linux

This SQL Server on Linux training class is aimed at database professionals looking to implement SQL Server on Linux.

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.

Goals
  1. Learn to describe key capabilities and components of SQL Server on Linux.
  2. Learn to describe how to deploy SQL Server on Linux.
  3. Learn to describe how to install the additional optional components to SQL Server.
  4. Learn to describe how to configure SQL Server on Linux.
  5. Learn to describe how to connect and manage SQL server images on Linux.
  6. Learn to describe how to migrate databases from other database systems to SQL Server on Linux and provide disaster recovery.
  7. Learn to describe the high availability features of SQL Server on Linux .
Outline
  1. Introduction to SQL Server on Linux
    1. Why is SQL Server on Linux?
    2. SQL Server on Linux capabilities
    3. Containers
    4. Linux SQL Server VM in Azure
  2. Deploying SQL Server on Linux
    1. Deploying SQL Server on Ubuntu
    2. Deploying SQL Server on SUSE
    3. Deploying SQL Server on Red Hat
    4. Deploying SQL Server containers on Docker
    5. Lab: Deploying SQL Server on Linux
      1. Installing SQL Server
      2. Installing command line tools
      3. Creating a database
      4. Create a SQL Server 2017 Docker container
  3. Installing additional components
    1. SQL Server agent
    2. SQL Server full-text search
    3. SQL Server integration services
    4. Lab: Installing additional components
      1. SQL Server agent
      2. SQL Server full-text search
      3. SQL Server integration services
      4. Remove the Azure virtual machine
  4. Configuring SQL Server on Linux
    1. Configuring SQL Server with mssql-conf
    2. Configure a SQL Server on Linux Docker image
  5. Managing Database Solutions for SQL Server for Linux
    1. Connecting to SQL Server on Linux
    2. Managing SQL Server on Linux
    3. Lab: Managing SQL Server on Linux
      1. Connect to SQL Server on Linux
      2. Manage SQL Server on Linux
  6. Migrating Databases to SQL Server on Linux and Disaster Recovery
    1. Backup and restore
    2. Database export and import
    3. SQL Server migration assistant
    4. Bulk copy program
    5. SQL Server integration services
    6. Lab: Migrating databases
      1. Migrate a database with backup and restore
      2. Migrate a database with SQL Server migration assistant
  7. High Availability
    1. Log shipping
    2. Failover clustering
    3. Availability groups
    4. Lab: High availability
      1. Configure log shipping
      2. Create a read-scale availability group
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

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

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

Training for Yourself

$950.00 or 2 vouchers
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

What people say about our training

The DB2 SQL Training class was great ! The instructor was very knowledgeable about all topics and also more than willing to answer any questions raised. Looking forward to attending more online instructor-led training in the future.
Debra LaBelle
Delhaize America Hannaford
Efficient, effective, easy to understand and follow.
Diane Halweg
JETPUBS, Inc.
The class provides project based learning. I've always found hands on learning to be the best way to keep me focused to learn. The course book used is excellent. It outlines each project step-by-step for referencing once you've gotten out of the class.
Samantha Hayden
Auveco
Access 2007 level 3 and 4 deliver the goods to becoming proficient with database management. The tools gained in these two courses will make a good developer and manager even better. you will develop skills to become more efficient and well rounded.
Monty Clawson
DoD

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

60,864

Students who have taken Instructor-led Training

11,704

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 28,802 reviews

Contact Us or call 1-877-932-8228