SQL Server on Linux Administration Fundamentals

Let's get you production ready for your SQL Server on Linux data platform. In this course, you'll learn about installation, configuration, Linux fundamentals, and high availability and disaster recovery options available to you.
Course info
Rating
(12)
Level
Beginner
Updated
Oct 31, 2017
Duration
2h 39m
Table of contents
Course Overview
Introduction and SQL Server Architecture
Installing and Configuring SQL Server on Linux
Administering Linux for DBAs
Managing SQL Server on Linux: Administration and Tools
High Availability and Disaster Recovery with SQL Server on Linux
Description
Course info
Rating
(12)
Level
Beginner
Updated
Oct 31, 2017
Duration
2h 39m
Description

SQL Server is available on Linux, and management wants you to leverage this shift in technology to more effectively manage your data platform. In this course, SQL Server on Linux Administration Fundamentals, you’ll delve into SQL on Linux in order for you to become an effective DBA. First, you'll explore an overview of its architecture, installation, and configuration. Next, you'll learn how to administer SQL Server on Linux. Finally, you'll discover high availability and disaster recovery options available to you for keeping your SQL Server online. By the end of this course, you'll have a solid foundation necessary to utilize SQL Server on Linux in production.

About the author
About the author

Meet Anthony Nocentino, Enterprise Architect, Founder and President of Centino Systems, Pluralsight Author, Microsoft Data Platform MVP, Corporate Problem Solver, and a voracious student of the latest computer science technology.

More from the author
More courses by Anthony Nocentino
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone! My name is Anthony Nocentino, Enterprise architect, and founder of Centino Systems. Welcome to my course, SQL Server on Linux Administration Fundamentals. Can you believe it? SQL Server is now available on Linux. And let's get you started on your journey to becoming an effective DBA using SQL Server on Linux. In this course, we're going to get you started on your path to do just that. First, we're going to introduce SQL Server on Linux and look closely at its architecture. Then we'll dive right in and install and configure SQL Server on Linux together. After that, we'll look at some of the Linux skills needed to effectively administer SQL Server on Linux. And then we'll look at some of the new tools that are available for SQL Server on Linux and how we can leverage some existing tools and using both to administer our system. And then, finally, we'll look at some of the high availability and disaster recovery options available to us in this new environment. And we'll also do an overview of backups and restores. By the end of this course, you'll be production ready for SQL Server on Linux. Before beginning this course, you should be familiar with Linux operating system concepts like logging in and basic command line usage. You'll also need to be familiar with basic relational database engine concepts. I hope you'll join me on this journey to learn SQL Server on Linux in my course, SQL Server on Linux Administration Fundamentals.

Introduction and SQL Server Architecture
Hello! This is Anthony Nocentino with Centino Systems. Welcome to my course, SQL Server on Linux Administration Fundamentals. This is the Introduction and SQL Server Architecture module. Well, who would have thought this would have happened? Microsoft SQL Server on Linux. Let's check out where we're going to head in this course. And, first off, in this module, Introduction and SQL Server Architecture, we're going to start off with an introduction and look at why and how Microsoft put SQL Server on Linux. Then we'll dive right in and download SQL Server on Linux, install it and configure it together in the module Installing and Configuring SQL Server on Linux. And then after that if you're coming from a Windows world, we're going to give you some basic Linux knowledge needed in the module Administering Linux for DBAs. With our SQL installation finished, and our basic Linux knowledge under our belt, we'll look at how we can manage our new data platform in the module Managing SQL Server on Linux: Administration and Tools. And in our final module, we'll look at how we can protect our data by keeping it online and backed up in the module High Availability and Disaster Recovery with SQL Server on Linux. So let's get cracking on this module and see where we're going. First off, we'll talk about why. Why did Microsoft put SQL Server on Linux? Then we'll introduce the SQL Server ecosphere. Basically what are the core components? And since it's a whole new world to some of us, I'm going to show you some of the places to look for help. And after that, we'll look at the lab environment that we'll be using in this course. And then, finally, we'll wrap up the module with a deep dive into SQL on Linux architecture and how Microsoft actually pulled this off.

Installing and Configuring SQL Server on Linux
Hello. This is Anthony Nocentino with Centino Systems. Welcome to my course SQL Server on Linux Administration Fundamentals. This is the Installing and Configuring SQL Server on Linux module. So far in this course, we've covered why Microsoft put SQL Server on Linux, its architecture, and our lab setup. Now let's move into Installing and Configuring SQL Server on Linux. So for this module, we're going to start off with how to install SQL Server on Linux. And then we'll take a closer look at each of its components. And then we'll discuss some Docker container basics.

Administering Linux for DBAs
Hello! This is Anthony Nocentino with Centino Systems. Welcome to my course SQL Server on Linux Administration Fundamentals. This module is Administering Linux for DBAs. So we're cruising along, and we just installed SQL Server on Linux together. Let's spend a little time getting you production ready with Administering Linux for DBAs. We're going to cover skills that I think are fundamental to building a production-ready SQL on Linux system. We're going to go through a lot in this module. And, first up, we're going to look at managing services with systemd where we'll learn how to start and stop SQL Server as a service and much more. We'll also look at some disk and partitioning concepts. As DBAs, we need to know about our disk subsystems, and we'll learn how to format, mount, and put SQL Server on a new disk. Then we'll take a quick tour of Linux file and directory ownership and look at how to mount and back up our data to a remote file system.

Managing SQL Server on Linux: Administration and Tools
Hello! This is Anthony Nocentino with Centino Systems. Welcome to my course SQL Server on Linux Administration Fundamentals. This module is Managing SQL Server on Linux: Administration and Tools. So we just went through the skills that I think that you need as a DBA to administer Linux systems. Now let's move up the stack inside SQL Server and look at the tools that are available to you in this cross-platform world in the module Managing SQL Server on Linux: Administration and Tools. In this module, we're going to start off by looking at the tools available to managing SQL Server on Linux, and then we'll leverage some of those tools and work on configuring SQL Server on Linux together. After that, we'll look at some of SQL Server's new dynamic management views and new ways to access that data.

High Availability and Disaster Recovery with SQL Server on Linux
Hello! This is Anthony Nocentino with Centino Systems. Welcome to my course SQL Server on Linux Administration Fundamentals. This module is High Availability and Disaster Recovery with SQL Server on Linux. Well, here we are at the end of the course. We've reviewed SQL Server on Linux's architecture. We've installed and configured SQL Server on Linux. And we went through some of the core Linux skills for DBAs. We've also looked at the new tools that are available to us, and it wouldn't be a DBA fundamentals course without a discussion on high availability and disaster recovery. So let's dig in. In this module, we're going to look at what our high availability and disaster recovery options are with SQL Server on Linux. Then we'll do a fundamentals level overview of backup and restore options for those new to SQL Server.