PDP Url

SQL Server on Linux (MS-10999)

Rating:
80% of 100
This two-day instructor led training course is aimed at database professionals looking to implement SQL Server on Linux

Virtual

Learning Style

Intermediate

Difficulty

2 Days

Course Duration

2

SATV Value

Course Info

Download PDF

Certificate

See Sample

Subscribe Buy Individually
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1275 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
This two-day instructor led training course is aimed at database professionals looking to implement SQL Server on Linux

Course Information

About this course:

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

The average salary for a Solutions Developer with Microsoft Azure skills is $69,606 per year.

Course Objective:

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

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.

Prerequisite:

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.

Suggested Prerequisite:

Updating Your Skills to Microsoft SQL Server 2016 (MS-10986)

Career Path:

IT Ops & Management…

Outline

Frequently Asked Questions

1. What are the prerequisites to the SQL Server on Linux (MS-10999) course?

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.

2. What is the Difficulty level of the SQL Server on Linux (MS-10999) certification training?

Intermediate Level.

3. How will the SQL Server on Linux (MS-10999) certification training benefit me in my current job role?

  • 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.
  • This two-day training course is aimed at database professionals looking to implement SQL Server on Linux
  • Provides value added skills and expertise to excel seamlessly and robustly in your job role along with the confidence of being product specialist.
  • provides a real-world, hands-on practical approach for you to apply the knowledge and skills learned in the course.
  • provides on-the-job reference material to boost knowledge and skills retention.

4. What is the SQL Server on Linux (MS-10999) certification training objective?

  • 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

5. How SQL Server cross-platform support is achieved?

SQL Server on Linux is not a port or a rewrite of SQL Server on Windows—instead SQL Server on Windows and SQL Server on Linux share a common code base. By using a common code base, your database queries will be executed by the same logical operators, regardless of the operating system that hosts your SQL Server instance. This means that a large majority of SQL Server workloads will function identically on a Windows server or a Linux server. Clients connect to SQL Server in the same way regardless of the host operating system; the server platform should be transparent to database end users. All modern versions of SQL Server (since SQL Server 2005) use a component called SQL Operating System (SQLOS) to provide a common interface for SQL Server components and commands to access Windows operating system resources (I/O, CPU, and memory). SQL Server 2017 extends SQLOS into a Platform Abstraction Layer (SQLPAL) that provides the same common interface for resources on more than one operating system. SQLPAL provides the mechanism through which the shared code base of database-level and instance-level commands interact with the host operating system. A command that requires operating system resources requests them from SQLPAL; in turn, SQLPAL is responsible for converting that request into a Windows- or Linux-specific operating system command.

6. Describe the features of SQL Server on Linux?

Although Microsoft’s long-term goal is to provide parity of features between SQL Server on Windows and SQL Server on Linux, the initial release of SQL Server on Linux includes support for the following:

  • Database Engine (most features supported, including In-Memory OLTP, Columnstore, and Availability Groups)
  • SQL Server Agent
  • Full-text Search
  • SQL Server Integration Services (SSIS)

7. What are software containers and what do they offer?

Software containers offer a form of virtualization and are similar in purpose to virtual machines—although the underlying architecture of software containers and virtual machines is very different. Like a virtual machine, a software container uses a portion of the resources of a host operating system to run an independent operating system instance that is used to isolate an application and its dependencies. Unlike a virtual machine, a software container is not a completely isolated copy of the guest operating system—instead, many operating-system level services (such as networking and storage) are provided by a container engine service running on the host. All the software containers running on a host share the resources of the container engine—as a result, software containers typically require fewer resources to run and store than a comparable virtual machine.

8. What is a Docker and explain some important terms associated to it?

Docker is a container engine that you use to create, run, and manage software containers on Linux, Windows, and Mac. Some important Docker terms include:

  • Docker Engine: The service (Windows) or daemon (Linux) that provides shared resources and tools for running software containers.
  • Host: The operating system instance that runs the Docker Engine.
  • Container: An instance of a software container defined on an instance of the Docker Engine. A container might be in a started (running) or stopped state.
  • Image: A stored container definition. A single host might run many containers that start from the same image. It’s common for images to be built on a chain of image dependencies. Each image in such a chain contains only the changes from the preceding image.
  • Image repository: A repository for storing and sharing Docker images. Repositories are public or private. The largest public image repository is the Docker Hub—https://hub.docker.com.

9. What are the steps to install SQL Server on Linux?

To install SQL Server on Linux, you use the standard package management tool for your Linux distribution (yum for RHEL, apt-get for Ubuntu, zypper for SLES). Regardless of which distribution you are using, the logical steps are:

  1. Update the repository list on your Linux server to use the Microsoft repository for your distribution.
  2. Update the local list of available software packages.
  3. Install the SQL Server on Linux package. Regardless of your distribution, the SQL Server on Linux package is called mssql-server.

10. How to configure SQL Server on Linux?

When you have installed SQL Server on Linux, you must complete the following server-level actions:

  • Accept the SQL Server license.
  • Select the SQL Server edition.
  • Set the server language.
  • Set the sa password.

More Information

More Information
Brand Microsoft
Subjects IT Ops & Management
Lab Access Yes
Technology Linux, Microsoft
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 2 Days
Language English
SATV Value 2
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here