Data Engineering on Microsoft Azure: Securing Data

IN THIS COURSE

• 1.  Course Overview
  1m 26s
  In this video, you’ll learn more about your instructor and this course. In this course, you’ll learn the various methods available for encrypting data stored in SQL databases. You’ll also learn how to use DataFrames and Databricks. You’ll see how to implement Advanced Threat Protection and dynamic data masking in Azure databases. Finally, you’ll learn how immutable blobs can be used to manage sensitive information. FREE ACCESS
• 2.  Azure Data Encryption
  6m 37s
  In this video, you’ll learn how Azure manages data encryption. When you encrypt data, you turn it from readable, clear text to ciphertext, which cannot be read by unauthorized people or code without the proper key to decrypt it. Encryption is critical. Data may be intercepted when it's traveling between the client and the server, or what's called data in motion. Data at rest, stored in a database on the server, is also potentially vulnerable. FREE ACCESS
• 3.  Managing Transparent Data Encryption
  7m 15s
  In this video, you’ll watch a demo. You’ll learn how to manage transparent data encryption on a SQL database in Azure. Transparent data encryption keeps your data encrypted at rest. This way, if anyone steals the data and doesn't have the key to decrypt it, they can't read it. Onscreen, you’ll see you need to open Azure. Then, you’ll click on Create a resource. FREE ACCESS
• 4.  Database Encryption
  5m 18s
  In this video, you’ll learn that the SQL server has a feature called always encrypted. This ensures your data is encrypted when in motion between the client and the server. This is a feature on the standalone on-premises version of SQL Server. It can be applied to a SQL database resource instance in Azure, or a standalone SQL Server instance implemented in a virtual machine on Azure. You’ll learn how the always encrypted feature works. FREE ACCESS
• 5.  Implementing Always Encrypted
  10m 25s
  In this video, you’ll watch a demo. You’ll learn how to enable the always encrypted feature on an Azure SQL database. You’ll open Azure, and head to the SQL database that’s set up. You'll go to your resource group and you'll see a SQL Server called sqlserver2426 and a SQL database called sqldb2426. This is the database you’ll be talking to. You’ll talk to the database through Microsoft SQL Server Management Studio or SSMS. FREE ACCESS
• 6.  Encrypting Database Columns
  7m 38s
  In this video, you’ll watch a demo. You’ll learn more about encrypting and decrypting columns in a SQL database table using a symmetric key. You’ll open Azure, and see a SQL server is set up. It’s called server2526. You’ll use Microsoft SQL Server Management Studio. Go to the SQL server. You’ll need to copy your server name, which is on the Overview of your server. Then, you’ll go to SQL Server Management Studio or SSMS. FREE ACCESS
• 7.  Applying Row-level Security
  14m 2s
  In this video, you’ll watch a demo. You’ll learn how to set row security on a SQL table to limit the rows certain users are allowed to see. You’ll create a SQL database in Azure. Then, you’ll connect to it with SQL Server Management Studio. On the homepage in Azure you’ll see a button that says Create a resource. Click on that and then you’ll create your SQL database. FREE ACCESS
• 8.  Working with DataFrames
  10m 19s
  In this video, you’ll watch a demo. You’ll learn how to manipulate an Apache Spark DataFrame using Azure Databricks workspace. You’ll start in Azure. You’ll see a Databricks instance has already been started, but you’ll how to create your own. On the home page, you’ll click Create a resource. Then, on the new page in the search box, you’ll type azure databricks. Choose Azure Databricks, and click Create. FREE ACCESS
• 9.  Securing Azure Database Data
  11m 56s
  In this video, you’ll watch a demo. You’ll learn how to dynamically mask data in an Azure SQL database. Then, you’ll go through some advanced threat protection to help protect your SQL server. In Azure, you’ll see there’s already a database set up. On the Home page, if you go to your resource group, you'll see a SQL Server instance set up called sqlserver2426 and a SQL database set up called sqldb2426.  FREE ACCESS
• 10.  Utilizing Immutable Blobs
  5m 28s
  In this video, you’ll learn how to utilize immutable blobs. There are cases where business-critical blob data needs to be immutable. This means once it's written, it cannot be overwritten or deleted for a given time period. This is referred to as Write Once, Read Many, or WORM. As the name suggests, you can only write the data once. After that, you can't change it or delete it for the immutable period. FREE ACCESS
• 11.  Course Summary
  1m 5s
  In this video, you’ll summarize what you’ve learned in the course. You’ve learned how to utilize tools to secure data in Azure Blob storage and SQL databases. You explored encrypting data across a platform, database encryption, and managing Transparent Data Encryption. You also learned to enable Always Encrypted and encrypted single columns in Azure SQL Database. You also applied row-level security with group membership and used DataFrames in DataBricks. FREE ACCESS