Oracle Database 19C: Administration Workshop Certification Training

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Oracle Database 19c Administration Workshop training is designed to equip IT professionals with essential skills for effectively managing Oracle Database environments. Participants learn database architecture, installation, configuration, backup, recovery, and performance tuning techniques. The training covers multitenant architecture, security features, and database maintenance tasks, enabling participants to ensure data integrity and availability. Through hands-on labs, students gain practical experience in managing Oracle databases. Successful completion of the training prepares individuals for the Oracle Database 19c Administrator Certified Associate certification, validating their expertise in administering Oracle databases and enhancing their career prospects in database administration roles.

Show More

What Will You Learn?

  • 1. Database Management Skills
  • 2. Career Advancement
  • 3. Industry Recognition
  • 4. Optimized Performance
  • 5. Data Security
  • 6. Backup and Recovery
  • 7. Oracle Community

Course Content

Module 1: Introduction to Oracle Database

  • Objectives
  • Oracle Database Server Architecture: Overview
  • Oracle Multitenant Container Database: Introduction
  • Oracle Multitenant Container Database: Architecture
  • Oracle Database Instance Configurations
  • Database Sharding: Introduction
  • Oracle Database Server: Interactive Architecture Diagram
  • Summary

Module 2: Accessing an Oracle Database

Module 3: Creating an Oracle Database by Using DBCA

Module 4: Creating an Oracle Database by Using a SQL Command

Module 5: Starting Up and Shutting Down a Database Instance

Module 6: Managing Database Instances

Module 7: Oracle Net Services: Overview

Module 8: Configuring Naming Methods

Module 9: Configuring and Administering the Listener

Module 10: Configuring a Shared Server Architecture

Module 11: Configuring Oracle Connection Manager for Multiplexing and Access Control

Module 12: Creating PDBs from Seed

Module 13: Using Other Techniques to Create PDBs

Module 14: Managing PDBs

Module 15: Database Storage Overview

Module 16: Creating and Managing Tablespaces

Module 17: Improving Space Usage

Module 18: Managing Undo Data

Module 19: Creating and Managing User Accounts

Module 20: Configuring Privilege and Role Authorization

Module 21: Configuring User Resource Limits

Module 22: Implementing Oracle Database Auditing

Module 23: Introduction to Loading and Transporting Data

Module 24: Loading Data

Module 25: Transporting Data

Module 26: Using External Tables to Load and Transport Data

Module 27: Automated Maintenance Tasks: Overview

Module 28: Automated Maintenance Tasks: Managing Tasks and Windows

Module 29: Database Monitoring and Tuning Performance Overview

Module 30: Monitoring Database Performance

Module 31: Database Processes

Module 32: Managing Memory

Module 33: Analyzing SQL and Optimizing Access Paths

Want to receive push notifications for all major on-site activities?