From the course: Designing Highly Scalable and Highly Available SQL Databases
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Identify security and compliance requirements
From the course: Designing Highly Scalable and Highly Available SQL Databases
Identify security and compliance requirements
- [Instructor] Now, another important factor we need to consider really around any kind of database is security and compliance. Now, when we talk about security, we're really talking about confidentiality of data, availability of that data and maintaining the integrity of it. And basically we want to focus on who can do what to which pieces of data? Now compliance is a little bit different. It's about institutional industry and government policies and laws that really vary by region and industry, but dictate what we can do with data. Now, confidentiality is about limiting access to data to those that need it to do their jobs. Now, this follows from something called the Principle of Least Privilege. The idea here is that anyone doing a particular job working with data or applications, they have all the privileges they need to get their jobs done, but they don't have more. So if you don't need access to a certain set of data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.