How to secure databases in use

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

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.


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

    $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

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
Technical Skills Development - Small Business, Mid-Market
Top 20 Online Learning Library