SQL Server on Linux Administration Fundamentals

SQL Server on Linux Administration Fundamentals

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 2h 39m | 428 MB

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.

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

01 – Course Overview
02 – Introduction, Course Overview, and Module Overview
03 – SQL Server on Linux Ecosphere and System Requirements
04 – SQL Server on Linux Features
05 – Finding Help
06 – Lab Environment
07 – Demo – Lab Environment
08 – SQLOS and Drawbridge
09 – SQLPAL and SQL Server on Linux Process
10 – Module Summary
11 – Introduction, Course Overview, and Module Overview
12 – Installing SQL Server on Linux, Packages, and Package Contents
13 – Demo – Installing SQL Server on Linux, Packages, and File Layout
14 – SQL Server Components, Database Engine, and Files
15 – Database Engine and Authentication Model
16 – SQL Agent and sqlcmd
17 – Demo – sqlcmd Usage, Creating a Database, and SQL Agent Job
18 – Docker Containers
19 – Demo – Container Setup and Connecting to SQL Server in a Container
20 – Module Summary
21 – Introduction, Course Overview, and Module Overview
22 – systemd, journald, and SQL Server Error Log
23 – Demo – systemd Usage, Services, Unit Files, and journald
24 – Disk Partitioning Concepts
25 – LVM Commands, Formatting, and Mounting the File System
26 – Demo – Add a Disk for Use with SQL Server on Linux
27 – File and Directory Ownership
28 – Demo – Directory Ownership and Database Creation on a New Disk
29 – Remote File Systems and Backup Targets
30 – Demo – Mounting and Backing up to a Remote File System
31 – Module Overview
32 – Introduction, Course Overview, and Module Overview
33 – Tools for Managing SQL Server on Linux
34 – Getting Tools for SQL Server on Linux
35 – Demo – Connecting to SQL Server with VS Code, SSMS, and PowerShell
36 – Configuring SQL Server on Linux with mssql-conf
37 – Using mssql-conf and the mssql.conf Configuration File
38 – Demo – Configuring SQL Server on Linux with mssql-conf
39 – DMVs and DBFS
40 – Demo – Installing, Configuring, and Using DBFS
41 – Module Summary and What’s Next
42 – Introduction, Course Overview, and Module Overview
43 – Overview of HADR Options – Backups and Failover Clusters
44 – Overview of HADR Options – Availability Groups and Log Shipping
45 – Backup and Restore, Backup Targets, and Recovery Models
46 – Demo – Recovery Model and Database Backups
47 – Module Summary and Thank You
48 – Restoring Databases and Database Recovery
49 – Demo – Restoring Databases and Cross Platform Restores