SQL Server 2016 Advanced Security and Administration [Video]

Preview in Mapt
Code Files

SQL Server 2016 Advanced Security and Administration [Video]

Steve Jones

Gain the basics you need to better manage your SQL Server database environment with simplified explanations and demonstrations of its features.
Mapt Subscription
FREE
$29.99/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


SQL Server 2016 Advanced Security and Administration [Video] Book Cover
SQL Server 2016 Advanced Security and Administration [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
Buy 2 for $35.00
Save $188.98
Add to Cart

Video Details

ISBN 139781787124240
Course Length2 hours and 14 minutes

Video Description

SQL Server is a complex and feature rich platform that can requires knowledge and practice to extract optimum performance from an instance. This course will assist a database administrator in understanding the advanced security features that protect data within databases. You will also gain an advanced understanding in how to examine the activity on your system and better tune the database code to run efficiently.

In SQL Server 2016 Advanced Security and Administration, we go beyond the basics of managing and securing a SQL Server instance. This course will look at the complex world of encryption and how you can enable this to protect data at rest as well as inside the database. Learn about Always Encrypted, where the data is always protected outside of the client system. The course will show how Dynamic Data Masking and Row-Level Security can be used to ensure that your clients only view the data they should be allowed to view. Since performance is important to all clients, the course covers the ways in which an administrator can determine what activity is taking place on a database through Extended Events and how to analyse and improve performance of queries using execution plans and the Query Store.

In the end you will learn how to ensure predictable performance by analysing activity to find any performance problem, use detailed execution plans to tune query code, and use Query Store to prevent plan regressions.

Style and Approach

This course will consist of explanations of each feature along with demonstrations that enable the viewer to understand how to use each feature.

Table of Contents

Advanced Security Features
The Course Overview
Transparent Data Encryption
Always Encrypted
Column Level Encryption
Row Level Security
Dynamic Data Masking
Extended Events
Introduction to Extended Events
Extended Event Sessions
Extended Event Targets
Extended Event Options
Viewing and Analyzing XE Data
Execution Plans and the Query Store
Introduction to Execution Plans
Reading Execution Plans
Introduction to Query Store
Administering the Query Store

What You Will Learn

  • Learn to enable and administer Always Encrypted to secure data on the network and inside the database.
  • Use Row-Level Security to selectively limit access to data by user.
  • Configure Dynamic Data Masking to obfuscate data consistently in your applications.
  • Enable encryption to protect data stored in SQL Server.
  • Create Extended Event sessions that capture the activity on your database
  • Analyze activity on your system to troubleshoot issues your clients experience.
  • Capture query execution plans to understand how the application is performing
  • Learn to read plans and tune the system based on the data clients need.
  • Enable the Query Store to track query activity over time
  • Force query plans with the Query Store that can help ensure predictable performance.

Authors

Table of Contents

Advanced Security Features
The Course Overview
Transparent Data Encryption
Always Encrypted
Column Level Encryption
Row Level Security
Dynamic Data Masking
Extended Events
Introduction to Extended Events
Extended Event Sessions
Extended Event Targets
Extended Event Options
Viewing and Analyzing XE Data
Execution Plans and the Query Store
Introduction to Execution Plans
Reading Execution Plans
Introduction to Query Store
Administering the Query Store

Video Details

ISBN 139781787124240
Course Length2 hours and 14 minutes
Read More

Read More Reviews

Recommended for You

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 2017 Administrator's Guide Book Cover
SQL Server 2017 Administrator's Guide
$ 43.99
$ 30.80
ECMAScript 2016 and Beyond [Video] Book Cover
ECMAScript 2016 and Beyond [Video]
$ 124.99
$ 106.25
SQL Server 2016 - Maintenance and Automation [Video] Book Cover
SQL Server 2016 - Maintenance and Automation [Video]
$ 124.99
$ 106.25
Windows Server 2016 Administration Fundamentals Book Cover
Windows Server 2016 Administration Fundamentals
$ 31.99
$ 22.40
Develop an Advanced Cross-platform App Using Xamarin.Forms and XAML [Video] Book Cover
Develop an Advanced Cross-platform App Using Xamarin.Forms and XAML [Video]
$ 124.99
$ 106.25