Microsoft Azure Security Technologies: Database User Access

Azure    |    Intermediate
  • 14 videos | 46m 29s
  • Includes Assessment
  • Earns a Badge
Rating 4.2 of 18 users Rating 4.2 of 18 users (18)
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 course
    Create sql logins
    Set an azure ad admin for sql
    Connect to azure sql using management studio
    Use the gui to enable rbac for azure ad administration
    Use the cli to enable rbac for azure ad administration
    Use powershell to enable rbac for azure ad administration
  • Configure the azure sql firewall
    Use powershell to configure custom keys for azure sql tde
    Conduct a sql vulnerability assessment
    Manage sql threat detection
    Use the portal to configure sql threat policies
    Use powershell to enable threat policies
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 57s
  • 2m 53s
    In this video, you will learn how to create SQL logins. FREE ACCESS
  • Locked
    3.  SQL Admins and Azure AD
    3m 23s
    Find out how to set an Azure AD administrator for SQL. FREE ACCESS
  • Locked
    4.  Azure SQL and SQL Server Management Studio
    4m 19s
    Learn how to connect to Azure SQL using Microsoft SQL Server Management Studio. FREE ACCESS
  • Locked
    5.  SQL, RBAC, and the GUI
    3m 41s
    In this video, find out how to use the GUI to enable RBAC for Azure AD administration. FREE ACCESS
  • Locked
    6.  SQL, RBAC, and the CLI
    3m 3s
    In this video, learn how to use the CLI to enable RBAC for Azure AD administration. FREE ACCESS
  • Locked
    7.  SQL, RBAC, and PowerShell
    3m 11s
    Learn how to use PowerShell to enable Role-Based Access Control (RBAC) for Azure AD administration. FREE ACCESS
  • Locked
    8.  Azure SQL Server Firewall
    2m 24s
    In this video, you will learn how to configure the Azure SQL firewall. FREE ACCESS
  • Locked
    9.  Azure SQL TDE, Custom Keys, and PowerShell
    6m 1s
    Learn how to use PowerShell to configure custom keys for Azure SQL TDE. FREE ACCESS
  • Locked
    10.  Azure SQL Server Vulnerability Assessment
    4m 43s
    In this video, find out how to conduct a SQL vulnerability assessment. FREE ACCESS
  • Locked
    11.  Azure SQL Server Threat Detection
    5m 9s
    In this video, you will learn how to manage SQL threat detection. FREE ACCESS
  • Locked
    12.  Azure SQL Threat Policies
    2m 32s
    Learn how to use the portal to configure SQL Server threat policies. FREE ACCESS
  • Locked
    13.  Threat Policies and PowerShell
    1m 52s
    In this video, learn how to enable threat policies using PowerShell. FREE ACCESS
  • Locked
    14.  Course Summary
    1m 20s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 208 users Rating 4.5 of 208 users (208)
Rating 4.6 of 236 users Rating 4.6 of 236 users (236)
Rating 4.6 of 328 users Rating 4.6 of 328 users (328)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)