Setup Menus in Admin Panel

Course 12: SQL Server 2016 Administration : New Features

0 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