Data Management with Azure: Implement Compliance Controls from Coursera

Confidential data stored within a Microsoft SQL Server or Azure SQL Database should be classified and kept safe within the database. This classification allows the SQL Server users, as well as other applications, to know the sensitivity of the data that is being stored. Classification and protection of the data stored in the database is a must – implementation of row-level security can restrict row-level access based on a user's identity, role, or execution context and with the implementation of Dynamic Data Masking you can limit sensitive data exposure to non-privileged users. Using the Azure portal, you can identify, classify, and protect your sensitive data.

In this intermediate-level guided project "Data Management with Azure: Implement Compliance Controls”, you will create an Azure SQL Server and set up sample database. Using sample database, sensitive data will be classified and “protected” using row level security and dynamic data masking. You will also learn what is and how to use Microsoft Defender for SQL.

The requirement for this project is having a free and active Azure account and an active Azure subscription. You will be given short instructions on how to get them in the first task.

What's inside

Syllabus

Project Overview

In this Guided Project you will create an Azure SQL Server and set up a sample database which will be used to classify and protect sensitive data using row-level security and dynamic data masking. You will also learn what is and how to use Microsoft Defender for SQL.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Offers learners security fundamentals of data management

Enabled by Microsoft Defender for SQL

Focuses on data integrity and protection using security mechanisms

Serves as a comprehensive guide to data management with Azure

Career center

Learners who complete Data Management with Azure: Implement Compliance Controls will develop knowledge and skills that may be useful to these careers:

Software Engineer

Software Engineers design, develop, and maintain software applications. They work on a variety of projects, from small business applications to large enterprise systems. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to build secure software applications.

See salaries and explore the career path for Software Engineer

Compliance Auditor

Compliance Auditors evaluate an organization's compliance with laws, regulations, and standards. They identify and assess risks and make recommendations for improvement. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Compliance Auditor

Information Governance Analyst

Information Governance Analysts develop and implement policies and procedures to manage an organization's information assets. They also oversee the organization's information governance activities. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Information Governance Analyst

Machine Learning Engineer

Machine Learning Engineers design, build, and deploy machine learning models. They use machine learning to solve business problems, such as fraud detection and customer segmentation. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Machine Learning Engineer

Database Administrator

Database Administrators are responsible for the installation, configuration, maintenance, and performance monitoring of database management systems. Completing this course will help build a foundation in using Microsoft SQL Server and Azure SQL Database, which are commonly used by Database Administrators. By learning how to classify and protect sensitive data using row-level security and dynamic data masking, you will gain skills that are highly relevant to this role.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts plan and implement security measures to protect an organization's information systems and data. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Information Security Analyst

Risk Analyst

Risk Analysts identify, assess, and mitigate risks. They work to protect organizations from financial losses, reputational damage, and other threats. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Risk Analyst

Data Scientist

Data Scientists use data to solve business problems. They collect, clean, and analyze data to identify trends and patterns. They then use this information to develop predictive models and make recommendations. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Data Scientist

Security Analyst

Security Analysts identify, assess, and mitigate security risks. They work to protect organizations from cyber threats and data breaches. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Security Analyst

Privacy Analyst

Privacy Analysts identify and assess privacy risks, and they develop and implement privacy policies and procedures. They also oversee an organization's privacy compliance activities. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Privacy Analyst

Data Protection Officer

Data Protection Officers are responsible for ensuring that an organization complies with data protection laws and regulations. They develop and implement data protection policies and procedures, and they oversee the organization's data protection activities. Completing this course will provide you with a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Data Protection Officer

Database Security Engineer

Database Security Engineers design and implement security measures to protect databases from unauthorized access and data breaches. This course may be useful for aspiring Database Security Engineers as it provides an introduction to data classification and protection. By understanding how to classify and protect sensitive data, you will be better equipped to design and implement effective security measures for databases.

See salaries and explore the career path for Database Security Engineer

Data Analyst

Data Analysts collect, clean, and analyze data to identify trends and patterns. They use this information to make recommendations and improve decision-making. This course can be useful for aspiring Data Analysts as it provides a foundation in data classification and protection. By understanding how to identify and protect sensitive data, you will be better equipped to work with sensitive data in your role.

See salaries and explore the career path for Data Analyst

Cloud Security Engineer

Cloud Security Engineers design and implement security measures to protect cloud-based systems and data. This course may be useful for aspiring Cloud Security Engineers as it provides an introduction to data classification and protection. By understanding how to classify and protect sensitive data, you will be better equipped to design and implement effective security measures for cloud-based systems.

See salaries and explore the career path for Cloud Security Engineer

Data Engineer

Data Engineers design, build, and maintain data pipelines and infrastructure. They ensure that data is properly stored, processed, and analyzed. This course may be helpful for Data Engineers as it provides an introduction to data classification and protection. By understanding how to classify and protect sensitive data, you will be better equipped to design and build secure data pipelines.

See salaries and explore the career path for Data Engineer