We may earn an affiliate commission when you visit our partners.
Goran Kliček
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.
Read more
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.
Read more
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/z3u44l/data
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
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
Save this course
Save Data Management with Azure: Implement Compliance Controls to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Data Management with Azure: Implement Compliance Controls with these
activities:
Review T-SQL Basics
Show steps
Review T-SQL basics will give you a solid foundation for better understanding of the concepts covered in this course.
Browse courses on
T-SQL
Show steps
-
Go through your notes or study materials from an introductory database course.
-
Do some practice problems on writing T-SQL queries.
Review T-SQL
Show steps
Reviewing T-SQL fundamentals will enhance your understanding of working with databases in this course.
Browse courses on
T-SQL
Show steps
-
Review basic T-SQL syntax
-
Practice writing SELECT, INSERT, UPDATE, and DELETE statements
-
Try out T-SQL commands in an online editor or local database
Complete the Azure SQL Database Fundamentals Tutorial
Show steps
This tutorial will provide you with a hands-on experience with Azure SQL Database, which will be helpful as you progress through this course.
Browse courses on
Azure SQL Database
Show steps
-
Set up an environment for the tutorial.
-
Follow the tutorial steps to create and manage an Azure SQL Database.
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Create a Sample Database
Show steps
Following guided tutorials to create a sample database will provide hands-on experience and prepare you for the course content.
Show steps
-
Find a tutorial on creating an Azure SQL Server database
-
Follow the steps in the tutorial to create your database
-
Populate the database with some sample data
Practice Writing T-SQL Queries
Show steps
Regularly practicing writing T-SQL queries will help you solidify your understanding of the language and improve your skills.
Browse courses on
T-SQL
Show steps
-
Find a collection of T-SQL query practice problems.
-
Set aside time each week to work on the problems.
-
Review your solutions and identify areas where you can improve.
Create a Cheat Sheet or Study Guide on Row-Level Security and Dynamic Data Masking
Show steps
Creating a cheat sheet or study guide will help you consolidate your knowledge and better retain the concepts covered in this course.
Browse courses on
Row-Level Security
Show steps
-
Identify the key concepts and terms related to row-level security and dynamic data masking.
-
Organize the information in a clear and concise manner.
-
Include examples and illustrations to enhance understanding.
Row-Level Security Exercises
Show steps
Practicing row-level security exercises will reinforce your understanding and improve your ability to implement this security measure.
Browse courses on
Row-Level Security
Show steps
-
Find practice exercises or problems on row-level security
-
Solve the exercises or problems
-
Review the solutions and identify areas for improvement
Develop a Data Classification Policy
Show steps
Creating a data classification policy will provide you with a practical application of the concepts covered in the course.
Browse courses on
Data Classification
Show steps
-
Research data classification best practices
-
Identify the types of data that need to be classified
-
Develop a classification system
-
Write a data classification policy
Mentor a Junior Developer on SQL Server Security
Show steps
Mentoring a junior developer will not only help them but also reinforce your own knowledge and understanding of SQL Server security.
Browse courses on
SQL Server Security
Show steps
-
Identify a junior developer who is interested in learning about SQL Server security.
-
Set up regular meetings to discuss topics and answer questions.
-
Provide guidance and support as the junior developer works on projects related to SQL Server security.
Participate in a SQL Server Hackathon
Show steps
Participating in a hackathon will challenge you to apply your skills and knowledge in a practical setting, which will help you solidify your learning and gain valuable experience.
Browse courses on
SQL Server
Show steps
-
Find a hackathon that is relevant to your interests and skill level.
-
Form a team or work on your own.
-
Develop a solution to the hackathon challenge.
Review T-SQL Basics
Show steps
Review T-SQL basics will give you a solid foundation for better understanding of the concepts covered in this course.
Browse courses on
T-SQL
Show steps
Show steps
Show steps
- Go through your notes or study materials from an introductory database course.
- Do some practice problems on writing T-SQL queries.
Review T-SQL
Show steps
Reviewing T-SQL fundamentals will enhance your understanding of working with databases in this course.
Browse courses on
T-SQL
Show steps
Show steps
Show steps
- Review basic T-SQL syntax
- Practice writing SELECT, INSERT, UPDATE, and DELETE statements
- Try out T-SQL commands in an online editor or local database
Complete the Azure SQL Database Fundamentals Tutorial
Show steps
This tutorial will provide you with a hands-on experience with Azure SQL Database, which will be helpful as you progress through this course.
Browse courses on
Azure SQL Database
Show steps
Show steps
Show steps
- Set up an environment for the tutorial.
- Follow the tutorial steps to create and manage an Azure SQL Database.
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Create a Sample Database
Show steps
Following guided tutorials to create a sample database will provide hands-on experience and prepare you for the course content.
Show steps
Show steps
Show steps
- Find a tutorial on creating an Azure SQL Server database
- Follow the steps in the tutorial to create your database
- Populate the database with some sample data
Practice Writing T-SQL Queries
Show steps
Regularly practicing writing T-SQL queries will help you solidify your understanding of the language and improve your skills.
Browse courses on
T-SQL
Show steps
Show steps
Show steps
- Find a collection of T-SQL query practice problems.
- Set aside time each week to work on the problems.
- Review your solutions and identify areas where you can improve.
Create a Cheat Sheet or Study Guide on Row-Level Security and Dynamic Data Masking
Show steps
Creating a cheat sheet or study guide will help you consolidate your knowledge and better retain the concepts covered in this course.
Browse courses on
Row-Level Security
Show steps
Show steps
Show steps
- Identify the key concepts and terms related to row-level security and dynamic data masking.
- Organize the information in a clear and concise manner.
- Include examples and illustrations to enhance understanding.
Row-Level Security Exercises
Show steps
Practicing row-level security exercises will reinforce your understanding and improve your ability to implement this security measure.
Browse courses on
Row-Level Security
Show steps
Show steps
Show steps
- Find practice exercises or problems on row-level security
- Solve the exercises or problems
- Review the solutions and identify areas for improvement
Develop a Data Classification Policy
Show steps
Creating a data classification policy will provide you with a practical application of the concepts covered in the course.
Browse courses on
Data Classification
Show steps
Show steps
Show steps
- Research data classification best practices
- Identify the types of data that need to be classified
- Develop a classification system
- Write a data classification policy
Mentor a Junior Developer on SQL Server Security
Show steps
Mentoring a junior developer will not only help them but also reinforce your own knowledge and understanding of SQL Server security.
Browse courses on
SQL Server Security
Show steps
Show steps
Show steps
- Identify a junior developer who is interested in learning about SQL Server security.
- Set up regular meetings to discuss topics and answer questions.
- Provide guidance and support as the junior developer works on projects related to SQL Server security.
Participate in a SQL Server Hackathon
Show steps
Participating in a hackathon will challenge you to apply your skills and knowledge in a practical setting, which will help you solidify your learning and gain valuable experience.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Find a hackathon that is relevant to your interests and skill level.
- Form a team or work on your own.
- Develop a solution to the hackathon challenge.
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 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.
Compliance Auditor
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.
Information Governance Analyst
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.
Machine Learning Engineer
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.
Database Administrator
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.
Information Security Analyst
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.
Risk 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.
Data Scientist
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.
Security Analyst
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.
Privacy 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.
Data Protection Officer
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.
Database Security Engineer
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.
Data Analyst
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.
Cloud Security Engineer
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.
Data 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.
For more career information including salaries, visit:
OpenCourser.com/course/z3u44l/data
Reading list
We've selected 12 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Data Management with Azure: Implement Compliance Controls.
Covers the basics of database security with Azure SQL Database, including how to create and manage database security policies. It also covers how to use SQL Server Management Studio and Azure Data Studio to manage your database security policies.
Save
Covers the basics of Microsoft Defender for SQL, including how to install and configure Microsoft Defender for SQL. It also covers how to use Microsoft Defender for SQL to protect your databases from threats.
Save
Collection of recipes for solving common Transact-SQL problems. It covers a wide range of topics, including data manipulation, data retrieval, and database administration.
Save
Data Classification: Concepts, Techniques and Applications provides an in-depth look at data classification techniques, including those used in row-level security and dynamic data masking. It valuable resource for understanding the theoretical foundations of these technologies.
Protecting Data: Privacy, Security, and Trust in the Information Age examines the legal and ethical issues surrounding data protection, including the use of row-level security and dynamic data masking. It provides a valuable perspective on the importance of protecting sensitive data.
Dynamic Data Masking with SQL Server provides a comprehensive overview of dynamic data masking in SQL Server. It covers both the theoretical foundations and practical implementation, making it a valuable resource for anyone interested in this technology.
The Data Security Handbook comprehensive reference guide to data security best practices. It covers a wide range of topics, including row-level security and dynamic data masking. It valuable resource for anyone responsible for data security.
Offers a comprehensive overview of data security and privacy in the cloud, covering topics such as data encryption, access control, and regulatory compliance. It provides a broader understanding of data security principles that apply beyond Azure.
Focuses on identity and access management, as well as security services in Azure. It can provide additional insights into securing data and applications in the Azure environment.
Security Engineering: A Guide to Building Dependable Distributed Systems provides a comprehensive overview of security engineering principles. It covers a wide range of topics, including data protection, authentication, and authorization. It valuable resource for anyone interested in learning more about security engineering.
Database Systems: The Complete Book comprehensive textbook on database systems. It covers a wide range of topics, including data classification, security, and privacy. It valuable resource for anyone interested in learning more about database systems.
Microsoft Azure Security Center: Administration provides a comprehensive overview of the Microsoft Azure Security Center. It covers a wide range of topics, including security monitoring, threat detection, and incident response. It valuable resource for anyone interested in learning more about the Microsoft Azure Security Center.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/z3u44l/data
Share
Similar courses
Here are nine courses similar to
Data Management with Azure: Implement Compliance Controls.
SQL Server 2016 New Features for Developers
OpenCourser.com/course/atoog8/sql
SQL Server 2016 New Features for Developers
Most relevant
Secure Your Data at Rest
OpenCourser.com/course/ml5s15/secure
Secure Your Data at Rest
Most relevant
EssentialSQL: Stored Procedures Unpacked - Code in TSQL
OpenCourser.com/course/bsx0h1/stored
EssentialSQL: Stored Procedures Unpacked - Code in TSQL
Most relevant
Implement Data Auditing with Azure Data Lake
OpenCourser.com/course/59u5km/implement
Implement Data Auditing with Azure Data Lake
Most relevant
Programming SQL Server Database Stored Procedures
OpenCourser.com/course/qjy046/programming
Programming SQL Server Database Stored Procedures
Most relevant
Configure and Manage Azure Key Vault
OpenCourser.com/course/c1zub6/configure
Configure and Manage Azure Key Vault
Most relevant
Troubleshooting SQL Server Performance with sp_WhoIsActive
OpenCourser.com/course/wdw9pu/troubleshooting
Troubleshooting SQL Server Performance with sp_WhoIsActive
Most relevant
Azure Database Administrator Associate
OpenCourser.com/course/epfy8r/azure
Azure Database Administrator Associate
Most relevant
Automate Data Workflows with SQL Server Stored Procedures
OpenCourser.com/course/nrom0z/automate
Automate Data Workflows with SQL Server Stored Procedures
Most relevant
Effort
2 hours
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Goran Kliček
Language
English
Good to know
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
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser