O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft 70-765 Provisioning SQL Databases

Video Description

This course prepares you for Microsoft Certification Exam 70-765. By the end of this course, you will be able to provision databases on Microsoft SQL Server 2016 and Microsoft Azure. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment

Table of Contents

  1. Introduction 00:01:18
  2. Introducing the Azure SQL Database Part 1 00:13:17
  3. Introducing the Azure SQL Database Part 2 00:15:44
  4. Setting Up Azure Lab 00:12:47
  5. Chose a Service Tier Part 1 00:20:39
  6. Chose a Service Tier Part 2 00:14:58
  7. Create Servers and Databases Part 1 00:22:27
  8. Creating a Azure SQL Server and Database Lab 00:10:54
  9. Create Servers and Databases Part 1 00:13:32
  10. Create Servers and Databases Part 2 00:13:32
  11. Create Servers and Databases Part 3 00:21:36
  12. Connecting SSMS to Azure SQL Lab Part 1 00:12:27
  13. Connecting SSMS to Azure SQL Lab Part 2 00:16:16
  14. Create a Sysadmin Account 00:11:33
  15. Creating Azure SQL Logins and Users Lab 00:13:39
  16. Configure Elastic Pools 00:10:18
  17. Creating and Configuring an Elastic Pool Lab 00:11:23
  18. Plan for an IaaS or On-Premises Deployment Part 1 00:05:03
  19. Plan for an IaaS or On Premises Deployment Part 2 00:06:36
  20. Select the Appropriate Size for a Virtual Machine 00:06:49
  21. Plan Storage Pools Based on Performance Requirements Part 1 00:19:44
  22. Plan Storage Pools Based on Performance Requirements Part 2 00:09:37
  23. Evaluate Best Practices for Installation 00:19:55
  24. Design a Storage Layout for a SQL Server Virtual Machine 00:09:39
  25. Deploy a SQL Server Instance in IaaS and On Premises 00:08:06
  26. Restoring AdventureWorks 2016 Database Lab 00:10:29
  27. Provision an Azure Virtual Machine to Host a SQL Server Instance 00:06:44
  28. Provisioning an Azure Virtual Machine to Host SQL Server Lab 00:11:15
  29. Manually Install SQL Server on an Azure Virtual Machine 00:21:14
  30. Installing SQL 2016 Lab Part 1 00:15:42
  31. Installing SQL 2016 Lab Part 2 00:14:01
  32. Automate the Deployment of SQL Server Databases 00:04:13
  33. Exploring Azure SQL Database Automation Lab 00:22:36
  34. Deploy SQL Server by Using Templates part 1 00:10:59
  35. Deploy SQL Server by Using Templates part 2 00:08:29
  36. Managing JSON Templates Lab 00:08:55
  37. Migrate an On-Premises SQL Server Database to an Azure Virtual Machine 00:14:22
  38. Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1 00:22:59
  39. Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2 00:14:57
  40. Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3 00:13:25
  41. Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4 00:21:28
  42. Generate Benchmark Data for Performance Needs 00:11:50
  43. Generating Benchmark Data Lab Part 1 00:24:17
  44. Generating Benchmark Data Lab Part 2 00:15:39
  45. Perform Performance Tuning on Azure IaaS 00:19:07
  46. Perform Performance Tuning on Azure IaaS Lab Part 1 00:08:26
  47. Perform Performance Tuning on Azure IaaS Lab Part 2 00:08:53
  48. Support Availability Sets in Azure Part 1 00:15:52
  49. Support Availability Sets in Azure Part 2 00:19:39
  50. Manage High Availability Lab Part 1 00:11:14
  51. Manage High Availability Lab Part 2 00:04:55
  52. Manage High Availability Lab Part 3 00:12:23
  53. Manage High Availability Lab Part 4 00:12:55
  54. Manage High Availability Lab Part 5 00:07:37
  55. Configure Firewall Rules 00:24:53
  56. Creating Firewall Rules Lab 00:19:54
  57. Configure Always Encrypted for Azure SQL Database 00:05:08
  58. Implementing Always Encrypted Lab 00:14:32
  59. Configure Cell Level Encryption 00:07:20
  60. Cell Level Encryption Lab 00:14:54
  61. Configure Dynamic Data Masking 00:12:22
  62. Dynamic Data Masking Lab 00:08:20
  63. Configure Transparent Data Encryption 00:13:03
  64. TDE Lab 00:18:00
  65. Configure SQL Performance Settings 00:04:58
  66. Configuring SQL Performance Settings Lab 00:10:42
  67. Configure Max Server Memory 00:04:30
  68. Configuring SQL Memory Lab 00:05:02
  69. Configure Database Performance Settings 00:01:23
  70. Configure Database Performance Settings Lab 00:20:08
  71. Configure Operators and Alerts part 1 00:15:46
  72. Configure Operators and Alerts part 2 00:16:53
  73. Create Databases 00:15:27
  74. Creating Databases Lab 00:05:07
  75. Manage Files and File Groups 00:08:42
  76. Managing Files and File Groups Lab 00:11:44
  77. Manage System Database Files 00:15:28
  78. anage System Database Files Lab 00:04:34
  79. Configure tempdb 00:12:39
  80. Configure tempdb Lab 00:18:08
  81. Manage SMB File Shares 00:18:22
  82. Manage SMB File Shares Lab 00:15:00
  83. Manage Stretch Databases 00:22:13
  84. Configure Azure Storage 00:25:09
  85. Change Service Tiers 00:23:15
  86. Change Service Tiers Lab Part 1 00:03:06
  87. Review Wait Statistics 00:03:06
  88. Manage Storage Pools 00:22:45
  89. Recover from Failed Storage 00:23:06
  90. Managing Storage Lab Part 1 00:12:01
  91. Managing Storage Lab Part 2 00:08:47
  92. Monitoring Tools 00:14:06
  93. Using Monitoring Tools Lab Part 1 00:17:40
  94. Using Monitoring Tools Lab Part 2 00:18:58
  95. Azure Performance Tuning 00:21:44
  96. Automate Maintenance Tasks 00:13:54
  97. Update Statistics and Indexes 00:14:46
  98. Update Statistics and Indexes Lab Part 1 00:14:43
  99. Update Statistics and Indexes Lab Part 2 00:18:35
  100. Verify Database Integrity 00:19:51
  101. Verify Database Integrity Lab 00:12:23
  102. Recover from Database Corruption 00:07:57
  103. Recover from Database Corruption Lab 00:15:22
  104. Conclusion 00:01:53