Setup Menus in Admin Panel

Course 12: SQL Server 2016 Administration : New Features

1 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
top
© Copyright by Rafacademy@2016