Microsoft Azure Security Technologies: Database User Access
Azure 2019
| Intermediate
- 14 Videos | 46m 29s
- Includes Assessment
- Earns a Badge
This 14-video course explores Azure database user access management, SQL threat detection, and how to enable SQL threat policies, while helping prepare learners for AZ-500 Microsoft Azure Security Technologies certification exam. First, you will learn to use SQL and Azure AD (Active Directory) logins to authenticate Azure SQL deployments, and create SQL logins. You will learn how to use SQL Server Management Studio to connect to Azure SQL and how to enable RBAC (role-based access control) for Azure AD administration by using the GUI (graphical user interface), CLI (command-line interface), and PowerShell. You will learn to configure the Azure SQL Firewall, and to configure custom keys for Azure SQL TDE (transparent data encryption). This course then demonstrates how to conduct a SQL vulnerability assessment to determine security shortcomings. You will examine Advanced Threat Detection, and how to configure threat detection settings at the Azure SQL Server level and at individual database level. Finally, learn to enable threat policies by using CLI and PowerShell.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this coursecreate SQL loginsset an Azure AD admin for SQLconnect to Azure SQL using Management Studiouse the GUI to enable RBAC for Azure AD administrationuse the CLI to enable RBAC for Azure AD administrationuse PowerShell to enable RBAC for Azure AD administration
-
configure the Azure SQL firewalluse PowerShell to configure custom keys for Azure SQL TDEconduct a SQL vulnerability assessmentmanage SQL threat detectionuse the portal to configure SQL threat policiesuse PowerShell to enable threat policiessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 57sUP NEXT
-
2.SQL User Logins2m 53s
-
3.SQL Admins and Azure AD3m 23s
-
4.Azure SQL and SQL Server Management Studio4m 19s
-
5.SQL, RBAC, and the GUI3m 41s
-
6.SQL, RBAC, and the CLI3m 3s
-
7.SQL, RBAC, and PowerShell3m 11s
-
8.Azure SQL Server Firewall2m 24s
-
9.Azure SQL TDE, Custom Keys, and PowerShell6m 1s
-
10.Azure SQL Server Vulnerability Assessment4m 43s
-
11.Azure SQL Server Threat Detection5m 9s
-
12.Azure SQL Threat Policies2m 32s
-
13.Threat Policies and PowerShell1m 52s
-
14.Course Summary1m 20s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.