How to secure databases in use

In this course, you’ll explore the best methods to secure databases in use.


  • Data masking (NoSQL) third-party tools Video — 00:03:14
    • Briefly discuss third-party tools, out of scope.

  • Data masking methods Video — 00:05:52
    • Discuss data masking methods.

  • Demo least privileges (RDMS) Video — 00:30:23
    • Demonstrate access and least privileges on SQL Server (Lab 1).

  • Set up MongoDB environment Video — 00:09:27
    • Demonstration of setting up a MongoDB environment for labs.

  • Lab 2 – Least privilege MongoDB
  • 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).

  • Recap of protecting data in use Video — 00:03:05
    • Recap the information discussed in this course.

  • Demo masking (RDMS) Video — 00:08:00
    • Demo data masking (Lab 3).

  • Demo least privileges (NoSQL) Video — 00:18:51
    • Demonstrate access and least privileges on MongoDB (Lab 2).

  • Access management Video — 00:15:14
    • Discuss database access management, strong passwords, password rotation, two-factor authentication and more password concerns.

  • Lab 3 – Data masking
  • Set up SQL environment Video — 00:06:00
    • Demonstration of setting up an SQL Express environment for labs.

  • Lab 1 – Least privilege


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.

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

    $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

    $799 per license / year

    • 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

Unlock 7 days of free training

  • 1,400+ hands-on courses and labs
  • Certification practice exams
  • Skill assessments

Award-winning training that you can trust

Comprehensive Cybersecurity Training - Infosec Skills
Cybersecurity Education and Training Gold Award - Infosec IQ
Top Rated Award - Infosec Skills
2021 G2 Summer - Leader - Tech Skills Dev, Online Course, eLearning Content
Top 20 Company - Online Learning Library