Home
Course
Course 12: SQL Server 2016 Administration : New Features

Course 12: SQL Server 2016 Administration : New Features

4 STUDENTS ENROLLED

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

Course Curriculum

1. SQL 2016 New Features Scripts and Docs
	SQL 2016 New Features Scripts and Docs	00:00:00
2. Downloads and Apps
	Downloads and Apps	00:00:00
3. Creating a VM with Windows OS
	Creating a VM with Windows OS	00:00:00
4. Installing SQL 2016 Part 1
	Installing SQL 2016 Part 1	00:00:00
5. Installing SQL 2016 Part 2
	Installing SQL 2016 Part 2	00:00:00
6. Installing SSMS
	Installing SSMS	00:00:00
7. Installing SSMS Part 2
	Installing SSMS Part 2	00:00:00
8. Installing Sample DBS
	Installing Sample DBS	00:00:00
9. Dynamic Data Masking
	Dynamic Data Masking	00:00:00
10. Dynamic Data Masking Part 2
	Dynamic Data Masking Part 2	00:00:00
11. Row Level Security
	Row Level Security	00:00:00
12. Stretch Database
	Stretch Database	00:00:00
13. Reasons to Create Stretch Database
	Reasons to Create Stretch Database	00:00:00
14. Cost of Azure
	Cost of Azure	00:00:00
15. Create an Azure Account
	Create an Azure Account	00:00:00
16. Stretch Demo
	Stretch Demo	00:00:00
17. Restoring Stretch DB
	Restoring Stretch DB	00:00:00
18. Live Query Statistics
	Live Query Statistics	00:00:00
19. Temporal Tables Part 1
	Temporal Tables Part 1	00:00:00
20. Temporal Table Part 2
	Temporal Table Part 2	00:00:00
21. Query Store
	Query Store	00:00:00
22. Query Store Part 2
	Query Store Part 2	00:00:00
23. Forced Plan
	Forced Plan	00:00:00
24. Forced Plan Part 2
	Forced Plan Part 2	00:00:00
25. What is In Memory OLTP
	What is In Memory OLTP	00:00:00
26. In Memory OLTP Demo
	In Memory OLTP Demo	00:00:00
27. In Memory OLTP Demo Part 2
	In Memory OLTP Demo Part 2	00:00:00
28. Determining Memory Tables
	Determining Memory Tables	00:00:00
29. Restart Services
	Restart Services	00:00:00
30. Demo of performance and IO
	Demo of performance and IO	00:00:00
31. Polybase
	Polybase	00:00:00
32. Azure Blob Storage Setup
	Azure Blob Storage Setup	00:00:00
33. Azure Blob Storage Setup Part 2
	Azure Blob Storage Setup Part 2	00:00:00
34. Set up Polybase
	Set up Polybase	00:00:00
35. Delete Azure Account
	Delete Azure Account	00:00:00
36. R technology
	R technology	00:00:00
37. Bonus Video
	Bonus Video	00:00:00