1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Implementing Azure SQL Data Security

Implementing Azure SQL Data Security

Contents

keyboard_tab
Introduction and Overview
2
Course Overview
PREVIEW2m 27s
Storage Security
Information Security
Track Data Changes
Summary
10
Summary
2m 2s

The course is part of this learning path

play-arrow
Course Introduction
Overview
DifficultyIntermediate
Duration48m
Students56
Ratings
3/5
starstarstarstar-borderstar-border

Description

In the Information age data is the new currency and like anything valuable, it needs to be protected. Azure SQL and its environment provide a range of mechanisms for protecting your data from a multitude of hazards. The potential threats range from bad actors trying to steal information to unintentional human error corrupting your data. To cover all eventualities Azure provides pre-emptive protection in the form of network security, several types of data encryption, data classification, and vulnerability assessment services. After the fact protection is available in the form of built-in data change tracking. This course shows not only tells you about what protection is available for your database but also how to implement it.

If you have any feedback relating to this course, feel free to contact us at support@cloudacademy.com.

Learning Objectives

  • Learn what security components are available  within Azure SQL
  • Understand how these elements work together to provide a secure environment
  • Learn how to implement infrastructure security
  • Learn how to secure your data from external and internal hazards
  • Learn how to implement data change tracking

Intended Audience

  • Anyone who wants to learn how to implement secure Azure SQL databases
  • Those preparing for Microsoft’s DP-300 exam

Prerequisites

To get the most out of this course, you have should a general understanding of the fundamentals of Microsoft Azure. Experience using databases — especially SQL Server — would also be beneficial.

Resources

The GitHub repository for this course can be found here: https://github.com/cloudacademy/azure-sql-data-security-dp-300

Transcript

Hi, and welcome to this Implementing Azure SQL Data Security course. In this course, we see how to protect data stored in an Azure SQL database, whether it is at rest or in transit between the server and applications. We will look at how to protect sensitive data within the context of data that is legitimately accessed by authorized users and how to implement data change tracking. This is a beginner’s course in terms of database-specific knowledge. Still, to get the most out of this course, it would help to know about basic security and data auditing, and any experience with SQL will be beneficial, although not essential.

My name is Hallam Webber, and I’ll be your instructor for this course. We welcome all comments and feedback, so please feel free to reach out to us at support@cloudacademy.com with any questions or comments. Let’s get started.

Lectures

Course Overview - Firewall Rules - Vnet to Vnet and Azure Data Gateway - Disk Encryption - Transparent Data Encryption - Column Encryption - Advanced Data Security - Track Data Changes - Summary

 

About the Author
Students8529
Courses13
Learning paths1

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.