How to secure databases in use Course
2 hours, 15 minutes
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 3 - Data masking
File - 00:10:00
Provides step by step instructions for lab 3.
Lab 2 - Least privilege MongoDB
File - 00:10:00
Provides step by step instructions for lab 2.
Lab 1 - Least privilege
File - 00:10:00
Step by step instructions for lab 1.
Recap of protecting data in use
Video - 00:03:00
Recap the information discussed in this course.
Data masking (NoSQL) third-party tools
Video - 00:03:00
Briefly discuss third-party tools, out of scope.
Demo masking (RDMS)
Video - 00:08:00
Demo data masking (Lab 3).
Data masking methods
Video - 00:06:00
Discuss data masking methods.
Demo least privileges (NoSQL)
Video - 00:19:00
Demonstrate access and least privileges on MongoDB (Lab 2).
Demo least privileges (RDMS)
Video - 00:30:00
Demonstrate access and least privileges on SQL Server (Lab 1).
Access management
Video - 00:15:00
Discuss database access management, strong passwords, password rotation, two-factor authentication and more password concerns.
Set up MongoDB environment
Video - 00:09:00
Demonstration of setting up a MongoDB environment for labs.
Set up SQL environment
Video - 00:06:00
Demonstration of setting up an SQL Express environment for labs.
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).
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
Plans & pricing
Infosec Skills Personal
$299 / year
- 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
Book a meeting to get a custom quote
- 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
Learn about scholarships and financing with
Award-winning training you can trust
