MOD 10999: SQL Server on Linux

Description

During this two-day course database professionals looking to implement SQL Server on Linux

This course is geared toward existing database professionals with experience of database systems running on Linux and Linux professionals who are interested in adding database capabilities

Upon course completion, 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

Prerequisites

It is recommended that in addition to a student’s professional experience, students also have technical knowledge in:

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

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

Module 1: Introduction to SQL Server on Linux
Lessons

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

Module 3: Installing 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

Module 4: Configuring SQL Server on Linux
Lessons

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

Module 5: Managing Database Solutions for SQL Server for 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

Module 6: Migrating Databases to SQL Server on Linux and Disaster Recovery
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

Module 7: High Availability
Lessons

Log shipping
Failover clustering
Availability groups
Lab: High availability

Configure log shipping
Create a read-scale availability group

Enrolled