SQL Server 2016 Administration

Name: SQL Server 2016 Administration
Rating: 4.5 (741 reviews)

Newest and beneficial features of SQL Server 2016

Created byRaphael Asghar

Last updated 8/2017

English

What you'll learn

At the end of this course, the student will be able to learn, configure, and manage the newest features of SQL Server 2016 administration such as data masking, temporal tables, polybase, row level security and much more

Course content

1 section • 37 lectures • 6h 33m total length

Introduction to SQL Server 2016 New Features and Administration4:44
1 Downloads and apps8:02
Learn to set up a virtual box environment for SQL Server 2016 administration, install Windows Server 2016 with service packs, and deploy the Wide World Imports and Adventure Works databases.
2 Creating a VM with Windows OS15:35
Create a virtual machine in VirtualBox to run Windows Server 2016 for SQL Server 2016 administration, including VM setup, ISO installation, resource planning, and network and firewall considerations.
3 Installing sql 201610:00
3 Installing sql 2016 part 211:08
4 Installing SSMS2:56
4a Installing SSMS3:53
5 Installing sample dbs6:59
6 Dynamic Data Masking10:00
6 Dynamic Data Masking part 213:28
7 Row Level Security19:20
Explore row level security in sql server 2016, implementing a function and security policy to filter data by user with filter and block predicates, while keeping access transparent to applications.
8 Stretch database8:47
Learn how SQL Server 2016 stretch database offloads archival data from on-premises databases to Microsoft Azure, reducing hardware needs while remaining transparent to users.
9 Reasons to create stretch database16:22
10 Cost of Azure5:27
10b Create an Azure account16:55
11 Stretch Demo18:54
11a restoring stretch db8:46
12 Live Query Statistics9:38
Explore live query statistics in SQL Server 2016, compare it with older execution plans, and learn how real-time data aids troubleshooting and performance tuning.
13 Temporal Tables10:00
13a Temporal Table part 219:47
14 Query Store10:00
14a Query Store part 216:49
Monitor the SQL Server 2016 query store in production, keep it in read mode, and tune retention and capture modes while using DMVs to spot slow queries.
15 Forced Plan10:00
15a Forced Plan11:00
16 What is In Memory OLTP18:19
17 In Memory OLTP demo10:00
17a In Memory OLTP demo part 210:02
18 Determining memory tables9:05
19 Restart services3:39
20 Demo of performance and IO13:18
21 Polybase13:34
22 Azure Blob storage setup13:00
22a Azure Blob storage setup13:31
23 set up polybase11:17
Set up PolyBase to access Azure storage data from SQL Server 2016 by configuring master keys, credentials, external data sources, file formats, and external tables, then run remote queries.
24 delete azure account4:30
Demonstrates deleting Azure resources and canceling a subscription in a testing environment to avoid charges, including confirming deletions and verifying billing status.
25 R technology1:05
BONUS VIDEO AND DOCS3:23

Requirements

To follow and benefit from this course, you must have taken the prerequisite courses: Learn T-SQL from Scratch, SQL Administration part 1, 2 and 3

Description

Welcome to SQL Server 2016 Administration. In this course, the student will be exposed to the latest and newest features that SQL Server 2016 has to offer. The student will learn about data masking, temporal tables, row level security, Azure cloud technology, stretch database configuration, live query statistics and much more. With this experience, the student will be able to configure, manage, deploy the latest features that are only available in SQL Server 2016 and as a result gain an advantage over the other IT professionals

Who this course is for:

Any student that wants to learn and administrate SQL Server 2016 and gain the benifits from the newest features