Data Engineering on Microsoft Azure: Securing Data

Azure    |    Intermediate
  • 11 videos | 1h 21m 28s
  • Includes Assessment
  • Earns a Badge
Rating 4.9 of 22 users Rating 4.9 of 22 users (22)
The final line of defense for protecting against a data breach is securing the data itself. With today's cloud environments, data is often in transit, duplicated, and stored in various data centers around the world, making effective data protection a challenge. In this course, you'll explore the various methods available for encrypting data stored in SQL databases. You'll examine how to use DataFrames in Databricks, as well as 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. This course is one in a collection that prepares learners for the Microsoft Data Engineering on Microsoft Azure (DP-203) exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Describe the tools used by azure to encrypt data across the platform
    Manage transparent data encryption on azure sql databases
    Describe how always encrypted is used by the database engine to process queries on encrypted data
    Enable always encrypted on an azure sql database
    Encrypt single columns in an azure sql database
  • Use group membership to control access to azure sql database rows
    Use dataframes in databricks to perform mixed functions
    Configure advanced threat protection and dynamic data masking in an azure sql database, azure sql managed instance, or azure synapse analytics instance
    Utilize immutable storage on azure blob storage to store business data in a manner that cannot be erased or modified to meet time-based or legal holds
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

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.7 of 41 users Rating 4.7 of 41 users (41)
Rating 4.6 of 161 users Rating 4.6 of 161 users (161)
Rating 4.7 of 49 users Rating 4.7 of 49 users (49)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.7 of 34 users Rating 4.7 of 34 users (34)
Rating 4.6 of 63 users Rating 4.6 of 63 users (63)
Rating 4.6 of 28 users Rating 4.6 of 28 users (28)