Administering SQL Server on Linux [Video]

Preview in Mapt

Administering SQL Server on Linux [Video]

Jasmin Azemović

Secure your data by administering your SQL Server solution on Linux
Mapt Subscription
FREE
$20.83/m after trial
Video
$106.25
RRP $124.99
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$106.25
$29.99 p/m after trial
RRP $124.99
Subscription
Video
Start 14 Day Trial

Frequently bought together


Administering SQL Server on Linux [Video] Book Cover
Administering SQL Server on Linux [Video]
$ 124.99
$ 106.25
Getting Started with SQL Server on Linux [Video] Book Cover
Getting Started with SQL Server on Linux [Video]
$ 124.99
$ 106.25
Buy 2 for $35.00
Save $214.98
Add to Cart

Video Details

ISBN 139781788997485
Course Length2 hours and 39 minutes

Video Description

Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud.

This course is your handy guide to implementing your SQL Server solution on the open-source Linux platform. You will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This course will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables.

By the end of this course, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment.

Style and Approach

This course follows a step-by-step approach to teach viewers the concepts of SQL Server on Linux (using the bash command line) and the SQL programming language through examples that can easily be adapted and applied in your own solutions.

Table of Contents

Backup and Recovery Operations
The Course Overview
Recovery Models and Backup Strategy Elements
Implementing Backup and Restoring Database
User Management
Authentication Process
Authorization Process
Accessing SQL Server resources
Implementing Data Protection
Crash Course in Cryptography
Transparent Data Encryption
Backup and Symmetric Encryption
Row-Level Security
Dynamic Data Masking
Indexing
Indexing Concepts
Clustered Index
Non-Clustered Index
Columnstore Index
In-Memory OLTP
Elements of Performance
Exploring In-Memory OLTP?
Beyond SQL Server
Query Store
Temporal Tables

What You Will Learn

  • Create and work with database objects using SQL Server on Linux
  • Configure and administer SQL Server on Linux-based systems
  • Create and restore database back-ups
  • Protect sensitive data using the built-in cryptographic features
  • Optimize query execution using indexes
  • Improve query execution time by more than 10x using in-memory OLTP
  • Track row-versioning using temporal tables

Authors

Table of Contents

Backup and Recovery Operations
The Course Overview
Recovery Models and Backup Strategy Elements
Implementing Backup and Restoring Database
User Management
Authentication Process
Authorization Process
Accessing SQL Server resources
Implementing Data Protection
Crash Course in Cryptography
Transparent Data Encryption
Backup and Symmetric Encryption
Row-Level Security
Dynamic Data Masking
Indexing
Indexing Concepts
Clustered Index
Non-Clustered Index
Columnstore Index
In-Memory OLTP
Elements of Performance
Exploring In-Memory OLTP?
Beyond SQL Server
Query Store
Temporal Tables

Video Details

ISBN 139781788997485
Course Length2 hours and 39 minutes
Read More

Read More Reviews

Recommended for You

Getting Started with SQL Server on Linux [Video] Book Cover
Getting Started with SQL Server on Linux [Video]
$ 124.99
$ 106.25
Learn C# With Windows Forms and SQL Server [Video] Book Cover
Learn C# With Windows Forms and SQL Server [Video]
$ 98.99
$ 84.15
SQL Server 2016 Advanced Security and Administration [Video] Book Cover
SQL Server 2016 Advanced Security and Administration [Video]
$ 124.99
$ 106.25
SQL Server on Linux Book Cover
SQL Server on Linux
$ 31.99
$ 22.40
SQL Server 2017 Administrator's Guide Book Cover
SQL Server 2017 Administrator's Guide
$ 43.99
$ 30.80
Fundamentals of Unix and Linux System Administration [Video] Book Cover
Fundamentals of Unix and Linux System Administration [Video]
$ 49.99
$ 42.50