How to secure databases in use Course

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

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

$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

Learn about scholarships and financing with

Affirm logo

Award-winning training you can trust