Course description
Being aware of how to best protect data in use will be covered within this course. There will be discussion and labs on access control and data obfuscation for both a relational on-premises database and a non-relational cloud database.

Syllabus
Lab 1 – Least privilege
File — 00:10:00
Lab 2 – Least privilege MongoDB
File — 00:10:00
Provides step by step instructions for lab 2.
Lab 3 – Data masking
File — 00:10:00
Provides step by step instructions for lab 3.
Methods to protect data in use
Video — 00:05:00
Discuss different methods of protecting data in use (least privilege, data masking, data isolation, autonomy and data redaction).
Set up SQL environment
Video — 00:06:00
Demonstration of setting up an SQL Express environment for labs.
Set up MongoDB environment
Video — 00:09:27
Demonstration of setting up a MongoDB environment for labs.
Access management
Video — 00:15:14
Discuss database access management, strong passwords, password rotation, two-factor authentication and more password concerns.
Demo least privileges (RDMS)
Video — 00:30:23
Demonstrate access and least privileges on SQL Server (Lab 1).
Demo least privileges (NoSQL)
Video — 00:18:51
Demonstrate access and least privileges on MongoDB (Lab 2).
Data masking methods
Video — 00:05:52
Discuss data masking methods.
Demo masking (RDMS)
Video — 00:08:00
Demo data masking (Lab 3).
Data masking (NoSQL) third-party tools
Video — 00:03:14
Briefly discuss third-party tools, out of scope.
Recap of protecting data in use
Video — 00:03:05
Recap the information discussed in this course.
Unlock 7 days of free training
- 1,400+ hands-on courses and labs
- Certification practice exams
- Skill assessments
Associated NICE Work Roles
All Infosec training maps directly to the NICE Workforce Framework for Cybersecurity to guide you from beginner to expert across 52 Work Roles.
- All-Source Analyst
- Mission Assessment Specialist
- Exploitation Analyst
You're in good company
We use Infosec Skills to provide continuous training to our technicians and to prepare them for various certifications. Infosec Skills allows us to create personalized training programs that focus on each of our technicians’ particular roles and see their progress as they take courses. We also, recommend it to clients to make their IT support teams better.
Caleb Yankus
This has been utilized to bridge the skills gap across our cyber team and to aid them as they prepare for their various certifications. It also has provided a nice learning foundation for our various cyber team members to utilize as we continue to find ways for cross-utilization with operations while minimizing the downtime needed to ensure everyone’s knowledge is the same.
Daniel Simpson
We use Infosec Skills to provide base level knowledge for employees. We also use the services to provide in depth learning for employees as they encounter new technologies. If an employee is is assigned to a new project, we can rely on Infosec Skills to provide a rapid concentrated learning environment. This rapid concentrated learning positions our employees for success.
Infosec Skills Teams client
Plans & pricing
-
Infosec Skills Personal
- 190+ role-guided learning paths (e.g., Ethical Hacking, Threat Hunting)
- 100s of hands-on labs in cloud-hosted cyber ranges
- Custom certification practice exams (e.g., CISSP, Security+)
- Skill assessments
- Infosec peer community support
-
Infosec Skills Teams
- Team administration and reporting
- Dedicated client success manager
-
Single sign-on (SSO)
Easily authenticate and manage your learners by connecting to any identity provider that supports the SAML 2.0 standard.
-
Integrations via API
Retrieve training performance and engagement metrics and integrate learner data into your existing LMS or HRS.
- 190+ role-guided learning paths and assessments (e.g., Incident Response)
- 100s of hands-on labs in cloud-hosted cyber ranges
- Create and assign custom learning paths
- Custom certification practice exams (e.g., CISSP, CISA)
- Optional upgrade: Guarantee team certification with live boot camps
Award-winning training that you can trust




