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.
What you'll learn
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.
Table of contents
- 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
- 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
- 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
- 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
About the author
Anthony is a Principal Field Solution Architect at Pure Storage as well as a Pluralsight Author, 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.