Course Description

Course Overview

The Oracle 19c Database Administration course offers comprehensive training on the administration and management of Oracle Database 19c. Participants will gain in-depth knowledge of various database administration tasks, including installation, configuration, backup and recovery, performance tuning, and security. The course equips participants with the skills necessary to effectively administer an Oracle Database 19c environment and handle day-to-day operational tasks.

Prerequisites

To derive maximum benefit from this course, participants should have a basic understanding of relational database concepts and familiarity with Oracle Database. Additionally, a basic understanding of SQL would be advantageous. It is recommended that participants have completed the Oracle Database 19c SQL Fundamentals course or possess equivalent knowledge.

Methodology

The course utilizes a combination of theoretical instruction, hands-on exercises, and practical demonstrations. Participants will receive detailed explanations of concepts and techniques, followed by opportunities to apply their learning in a lab environment. The course is delivered through instructor-led sessions, enabling participants to interact, ask questions, and engage in discussions.

Course Outline

Introduction to Oracle Database Administration

Overview of Oracle Database architecture

Understanding Oracle Database editions and options

Introduction to database administration tasks

Installing and Configuring Oracle Database 19c

Pre-installation considerations

Installation options and methods

Post-installation configuration steps

Configuring Oracle Net Services

Managing Database Storage Structures

Understanding tablespaces and data files

Creating and managing tablespaces

Managing space usage and allocating extents

Implementing Oracle Managed Files (OMF)

Administering Users and Security

Creating and managing database users

Assigning privileges and roles

Implementing password management policies

Securing the database using profiles and auditing

Backup and Recovery Concepts

Understanding backup and recovery strategies

Configuring the Oracle Flash Recovery Area

Performing database backups (full, incremental, and consistent)

Performing database recoveries (complete and incomplete)

Performance Tuning and Monitoring

Monitoring database performance using Oracle Enterprise Manager

Identifying and resolving performance bottlenecks

Optimizing SQL statements and execution plans

Implementing database tuning techniques

Managing Database Security

Securing database connections using SSL/TLS

Implementing Transparent Data Encryption (TDE)

Configuring and managing Oracle Data Redaction

Implementing Virtual Private Database (VPD)

Database Maintenance and Automation

Managing database objects (tables, indexes, etc.)

Monitoring and managing database storage

Automating administrative tasks using Oracle Scheduler

Implementing database alerts and thresholds

Course Outcome

Upon completion of the course, participants will:

• Possess a thorough understanding of Oracle Database 19c administration concepts and tasks.
• Be proficient in installing and configuring Oracle Database 19c.
• Have the skills to manage database storage structures effectively.
• Understand user management and security practices in Oracle Database.
• Be capable of implementing backup and recovery strategies.
• Have the ability to tune and optimize database performance.
• Be able to implement and manage database security measures.
• Possess the knowledge to perform routine database maintenance and automate administrative tasks.

Course Labs

The course includes hands-on labs that provide participants with practical experience in administering Oracle Database 19c. The labs cover various scenarios, allowing participants to practice installation and configuration, managing database storage structures, implementing security measures, performing backup and recovery, and optimizing database performance. The labs are designed to reinforce the concepts learned during the theoretical instruction and help participants build confidence in their database administration skills.