00 | 16 Weeks
Enrollment Minimum Requirements
BASIC REQUIREMENTS
- Basic computer skills
- Laptop
- Access to the internet
Course Contents/Details
DSM 007: Oracle Database SQL Certifified Professional level
Module 1: Introduction to Oracle Database 19c Administration
• Overview of Oracle Database Architecture
• Understanding Oracle Database Editions
• Preparing the Environment for Oracle Database Installation
• Installing Oracle Database 19c
• Configuring Oracle Net Services
Module 2: Managing Oracle Database Instance
• Understanding Oracle Database Instance
• Managing Database Initialization Parameters
• Starting and Stopping the Database
• Managing Memory and Processes
• Managing Control Files, Redo Logs, and Archive Logs
• Managing Database Storage
Module 3: Managing Oracle Database Storage Structures
• Understanding Oracle Database Storage Structures
• Managing Tablespaces and Data Files
• Managing Undo Data
• Managing Temporary Data
• Managing Oracle Database Files and Directories
• Managing Automatic Storage Management (ASM)
Module 4: Managing Users and Security
• Understanding Oracle Database Security Concepts
• Managing Database Users and Roles
• Managing Privileges and Permissions
• Managing Passwords and Profiles
• Managing Audit Policies
Module 5: Maintaining High Availability and Performance
• Implementing Backup and Recovery Strategies
• Performing Database Recovery
• Monitoring and Tuning Oracle Database
• Implementing Oracle Database High Availability
• Configuring Oracle Data Guard
• Implementing Oracle Database Replication
