Overview What You Will Learn Curriculum Instructor

Course Overview

Oracle Database is currently regarded as the most popular database management system in the world and is widely used in application development, online transaction processing (OLTP), data warehousing, mixed (OLTP & DW) database workloads, and enterprise grid computing, allowing large size companies to store and work with massive amounts of data. Oracle Database offers several complex security features and tools, such as Transparent Data Encryption, Key Management, Database Security Assessment Tool, Database Firewall, MAC, auditing, and more, and database administrators and data security teams must be well-trained to administer these features effectively. Oracle Database security teams can face several security issues and vulnerabilities, including broken access control, encryption failures, misconfigurations, outdated components, identification and authentication failures, monitoring failures, and more. Oracle Database can be prone to several security attacks, including SQL Injection attacks, brute forcing, accessible backups, DoS attacks, packet sniffing, exposed databases, data leakage, and privilege escalation, while Oracle Database was also impacted by the Log4j vulnerability. Thus, it is crucial for database admins, database security admins, and system administrators, to correctly administer Oracle Database security features and deploy additional measures such as monitoring and isolation to prevent vulnerability attacks.

The course will start with a thorough introduction to Oracle Database 19c, followed by a look at Oracle Database 19c’s components, architecture, and operation. As you move along, you’ll gain an understanding of the common security vulnerabilities and attack vectors in Oracle Database 19c, and what are the fundamental requirements for Database Security. Next, you’ll learn how to perform privilege analysis in Oracle Database and how to use Oracle Database Security Assessment Tool (DBSAT) to manage security configuration, user entitlement, and sensitive data risks. The course will then illustrate how to deploy Oracle Database Firewall, which will be followed by an introduction to the Oracle Database Vault. The course will then demonstrate how to perform user and permissions management in Oracle Database and how to manage database roles. You’ll also explore how to use Oracle Label Security for data access control. Moving ahead, the course will guide you through the process of password management in Oracle Database, and how authentication and authorization are carried out in Oracle Databases. You’ll also explore how data encryption is carried out in Oracle Databases, and how application security is performed in Oracle Databases with RASADM. The course will then illustrate how to perform data masking and subnetting in Oracle Databases and how to audit and monitor database activity. You’ll also learn how to perform logging in an Oracle Database, how vulnerability management is carried out in Oracle Database, and how to defend Oracle Databases against SQL Injection. As you near the conclusion, you’ll also learn how to ensure regular updates and patch installation in your Oracle Database and how to secure the Oracle Database against the Log4J vulnerability. The course will end with a look at some of the best security practices and security errors to avoid.

By the end of this course, you’ll have a clear understanding of all the potential security issues in the Oracle Database, and you’ll be able to implement the measures needed to protect your Oracle Database environment.

What You Will Learn

  • Learn how to effectively secure your Oracle Database system against both internal and external threats
  • How to monitor and audit activities within the database to provide an audit should something go wrong
  • Data security techniques such as encryption and firewalls
  • How to analyze your own database’s security status and how to obtain recommendations on configuration changes
  • Hands-on to prevent non-authorized users from gaining access to your database using force or other code base techniques

Program Curriculum

  • Introduction to Oracle Databases
  • Oracle Database Architecture
  • Installing and Configuring Oracle Databases
  • $7 Million Cybersecurity Scholarship by EC-Council

  • Introduction to Database Security Pitfalls
  • Strategies for Avoiding Weak Passwords and User Privilege Issues
  • Data Leakage Prevention Strategies
  • Chapter 2 Quiz

  • Introduction to Database Security Assessment Tools
  • Oracle Database Security Assessment Tool (DBSAT)
  • Oracle Audit Vault
  • Chapter 3 Quiz

  • Introduction to Oracle Database Firewall
  • Setting Up Policies and Rules in Oracle Database Firewall
  • Monitoring and Analyzing Firewall Activity
  • Chapter 4 Quiz

  • Introduction to Oracle Database Vault
  • Setting up Oracle Database Vault
  • Managing Realms and Access Control Policies
  • Chapter 5 Quiz

  • Introduction to Managing Users in Oracle
  • Creating Users and Assigning Privileges
  • User Authentication Methods
  • Chapter 6 Quiz

  • Introduction to Oracle Database Label Security
  • Setting up Label Security Policies
  • Managing Labels and Creating Security Profiles
  • Chapter 7 Quiz

  • Introduction to Database Encryption
  • Using Transparent Data Encryption (TDE)
  • Data Redaction
  • Chapter 8 Quiz

  • Introduction to Oracle Database Real Application Security Administration (RASADM)
  • Creating and Managing Security Policies with RASADM
  • Enforcing Security Policies with RASADM
  • Chapter 9 Quiz

  • Using Data Masking and Data Subsetting to Control Sensitive Data
  • Creating and Managing Data Masks and Subsets
  • Applying Data Masks and Subsets to Your Database
  • Chapter 10 Quiz

  • Introduction to SQL Injection Attacks
  • Identifying and Preventing SQL Injection Attacks
  • Chapter 11 Quiz

  • Introduction to Database Patching Best Practices
  • Database Patching
  • Oracle Vulnerability Management
  • Chapter 12 Quiz

Course Summary and Next Steps

Load more modules

Instructor

Kate Gawron

Kate Gawron has worked as an Oracle Database administrator for over 20 years. Her experience comes from a mixture of public sector and private companies and more recently includes advising customers on running Oracle Databases within the cloud. Kate holds three Oracle certifications and five certifications from AWS. Kate is a passionate member of the Oracle Community forums and she hold an AWS award for her work supporting Oracle Databases running on AWS.

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

$ 499.00
Billed annually or $59.00 billed monthly
Get Started Now
Start your 7-day trial for $1

What is included

  • 700+ Premium Short Courses
  • 50+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

$ 599.00
Billed annually or $69.00 billed monthly
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 800+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month
  • 3 Official EC-Council Essentials Certifications¹ (retails at $897!)
    Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

  • AWS Certified Security Specialty - Cert Prep

    AWS Certified Security Specialty - Cert Prep

    Short Course

    AWS Certified Security Specialty - Cert Prep

    Cloud Security

    Everything that you need to know to pass the Amazon Web Servi...

    $49.99

    Intermediate

    5 hr 48 m

  • Azure Kubernetes Service - Deploy ElasticStack (ELK)

    Azure Kubernetes Service - Deploy ElasticStack (ELK)

    Short Course

    Azure Kubernetes Service - Deploy ElasticStack (ELK)

    Cloud Security

    Learn Kubernetes fundamentals right from scratch

    $49.99

    Intermediate

    4 hr 0 m

  • Containers and Kubernetes on Azure

    Containers and Kubernetes on Azure

    Short Course

    Containers and Kubernetes on Azure

    Cloud Security

    Containerize your applications with Containers and Kubernetes...

    $49.99

    Beginner

    1 hr 30 m

  • Introduction to Azure Cloud Security Tools and Services

    Introduction to Azure Cloud Security Tools and Services

    Short Course

    Introduction to Azure Cloud Security Tools and Services

    Cloud Security

    Explore the Microsoft Azure Cloud Platform and gain an unders...

    $49.99

    Beginner

    1 hr 39 m

  • AZ 900 - Basics of Cloud Computing

    AZ 900 - Basics of Cloud Computing

    Short Course

    AZ 900 - Basics of Cloud Computing

    Cloud Security

    Everything you need to know about Cloud Computing with Azure

    $49.99

    Beginner

    1 hr 0 m

  • Entra ID and Entra Domain Services

    Entra ID and Entra Domain Services

    Short Course

    Entra ID and Entra Domain Services

    Cloud Security

    Learn how Entra ID (Azure Active Directory), On-Premises AD a...

    $49.99

    Intermediate

    4 hr 0 m

  • Introduction to Cloud Computing

    Introduction to Cloud Computing

    Short Course

    Introduction to Cloud Computing

    Cloud Security

    Learn about evolution of cloud and cloud models

    $49.99

    Beginner

    2 hr 0 m

  • Serverless Computing on AWS with Lambda, API Gateway, S3 and DynamoDB

    Serverless Computing on AWS with Lambda, API Gateway, S3 and DynamoDB

    Short Course

    Serverless Computing on AWS with Lambda, API Gateway, S3 and D...

    Cloud Security

    Master serverless computing technologies on AWS while develop...

    $59.99

    Intermediate

    4 hr 0 m

1 8