Securing Azure SQL Database

Offered By
Coursera Project Network
In this Guided Project, you will:

Learn to limit network access to your Azure SQL Database by utilizing server-level IP rules and virtual network access.

Learn to create database users and roles to easily manage permissions in your database.

Learn to enable Auditing and Temporal Tables to monitor executed queries and changes to your data.

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this project you will create a virtual network in Azure and utilize it to limit network access to your Azure SQL Database. You will create database users and roles to easily manage permissions in your database and enable auditing and system-versioning to monitor data changes over time. Besides implementing security and auditing features, you will define a backup policy for point-in-time and long-term retention backups. By completing this project, you will understand how to secure your database and restore your data in case of an accident or a security threat.

Skills you will develop

Database (DBMS)temporal tablesAuditingNetworkingdatabase backup

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Setting up your environment

  2. Limiting network access to your database

  3. Creating a dedicated database user for your application

  4. Azure SQL Database Auditing and Temporal Tables

  5. Defining a backup policy for you Azure SQL Database

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.