SQL Server on Linux Administration Fundamentals

By Anthony Nocentino
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.
Start FREE course
Play course overview
Course info
Rating
(21)
Level
Beginner
Updated
Oct 31, 2017
Duration
2h 39m
Table of contents
Course Overview
Course Overview 1m
Introduction and SQL Server Architecture
Introduction, Course Overview, and Module Overview 2m SQL Server on Linux Ecosphere and System Requirements 3m SQL Server on Linux Features 3m Finding Help 1m Lab Environment 1m Demo: Lab Environment 1m SQLOS and Drawbridge 2m SQLPAL and SQL Server on Linux Process 2m Module Summary 1m
Installing and Configuring SQL Server on Linux
Introduction, Course Overview, and Module Overview 1m Installing SQL Server on Linux, Packages, and Package Contents 4m Demo: Installing SQL Server on Linux, Packages, and File Layout 10m SQL Server Components, Database Engine, and Files 4m Database Engine and Authentication Model 2m SQL Agent and sqlcmd 3m Demo: sqlcmd Usage, Creating a Database, and SQL Agent Job 10m Docker Containers 1m Demo: Container Setup and Connecting to SQL Server in a Container 6m Module Summary 0m
Administering Linux for DBAs
Introduction, Course Overview, and Module Overview 1m systemd, journald, and SQL Server Error Log 3m Demo: systemd Usage, Services, Unit Files, and journald 9m Disk Partitioning Concepts 2m LVM Commands, Formatting, and Mounting the File System 3m Demo: Add a Disk for Use with SQL Server on Linux 6m File and Directory Ownership 1m Demo: Directory Ownership and Database Creation on a New Disk 3m Remote File Systems and Backup Targets 1m Demo: Mounting and Backing up to a Remote File System 8m Module Overview 1m
Managing SQL Server on Linux: Administration and Tools
Introduction, Course Overview, and Module Overview 1m Tools for Managing SQL Server on Linux 4m Getting Tools for SQL Server on Linux 2m Demo: Connecting to SQL Server with VS Code, SSMS, and PowerShell 7m Configuring SQL Server on Linux with mssql-conf 2m Using mssql-conf and the mssql.conf Configuration File 2m Demo: Configuring SQL Server on Linux with mssql-conf 8m DMVs and DBFS 2m Demo: Installing, Configuring, and Using DBFS 6m Module Summary and What's Next 1m
High Availability and Disaster Recovery with SQL Server on Linux
Introduction, Course Overview, and Module Overview 1m Overview of HADR Options: Backups and Failover Clusters 3m Overview of HADR Options: Availability Groups and Log Shipping 2m Backup and Restore, Backup Targets, and Recovery Models 4m Demo: Recovery Model and Database Backups 5m Module Summary and Thank You 3m Restoring Databases and Database Recovery 11m Demo: Restoring Databases and Cross Platform Restores 1m
Description
Course info
Rating
(21)
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
Anthony Nocentino
About the author

Anthony is the Founder and President of Centino Systems as well as a Pluralsight Author and a Microsoft Data Platform MVP, Linux Expert, and Corporate Problem Solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.

More from the author
Maintaining, Monitoring and Troubleshooting Kubernetes
Intermediate
2h 11m
Jun 29, 2020
Configuring and Managing Kubernetes Networking, Services, and Ingress
Intermediate
1h 55m
May 26, 2020
Designing a Site Recovery Strategy on Microsoft Azure
Beginner
2h 9m
Apr 22, 2020
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.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT