Oracle OCP 19C Certification Online Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration:  30 Days

About Course

The Oracle Database 19c: Performance Management and Tuning OCP has demonstrated a strong understanding of performance analysis, management and tuning and  Implementing Oracle Managed Files. Enroll today to get Certified.

Oracle OCP 19C Training Course Syllabus

Creating CDBs and Regular PDBs
  • Configure and create a CDB
  • Create a new PDB from the CDB seed
  • Explore the structure of PDBs
Manage CDBs and PDBs
  • Manage PDB service names and connections
  • Manage startup, shutdown and availability of CDBs and PDBs
  • Change the different modes and settings of PDBs
  • Evaluate the impact of parameter value changes
  • Performance management in CDBs and PDBs
  • Control CDB and PDB resource usage with the Oracle Resource Manager
Backup and Duplicate
  • Perform Backup and Recover CDBs and PDBs
  • Duplicate an active PDB
  • Duplicate a Database
Upgrading and Transporting CDBs and Regular PDBs
  • Upgrade an Oracle Database
  • Transport Data
Manage Application
  • Explain the purpose of application root and application seed
  • Define and create application PDBs
  • Install, upgrade and Patch applications
  • Create and administer Application PDBS
  • Clone PDBs and Application containers
  • Plug and unplug operations with PDBs and application containers
  • Comparing Local Undo Mode and Shared Undo Mode
Manage Security in Multitenant databases
  • Manage Security in Multitenant databases
  • Manage PDB lockdown profiles
  • Audit Users in CDBs and PDBs
  • Manage other types of policies in application containers
Recovery and Flashback
  • Restore and Recovering Databases with RMAN
  • Perform CDB and PDB flashback
Backup Strategies and Terminology
  • Perform Full and Incremental Backups and Recoveries
  • Compress and Encrypt RMAN Backups
  • Use a media manager
  • Create multi-section backups of very large files
  • Create duplexed backup sets
  • Create archival backups
  • Backup of recovery files
  • Backup non database files
  • Back up ASM meta data
Restore and Recovery Concepts
  • Employ the best Oracle Database recovery technology for your failure situation
  • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery
Using Flashback Technologies
  • Configure  your Database  to support Flashback
  • Perform flashback operations
Duplicating a Database
  • Duplicate Databases
Configuring and Using RMAN
  • Configure RMAN and the Database for Recoverability
  • Configure and Using an RMAN recovery catalog
Diagnosing Failures
  • Detect and repair database and database block corruption
  • Diagnosing Database Issues
Performing Recovery
  • Restore and Recovering Databases with RMAN
  • Perform Non RMAN database recovery
Transporting Data
  • Transport Data
RMAN Troubleshooting and
  • Interpret the RMAN message output
  • Diagnose RMAN performance issues
Install Grid Infrastructure and Oracle Database
  • Install Grid Infrastructure for a Standalone server
  • Install Oracle Database software
Patching Grid Infrastructure and Oracle
  • Patch Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure
  • Upgrade Oracle Grid Infrastructure
Oracle Database 18c: New Features

Image and RPM based Database Installation

Creating an Oracle Database by using DBCA
  • Create, Delete and Configure Databases using DBCA
Oracle Restart
  • Configure and use Oracle Restart to manage components
Upgrade the Oracle Database
  • Plan for Upgrading an Oracle Database
  • Upgrade an Oracle Database
  • Perform Post-Upgrade tasks
Install Grid Infrastructure for a Standalone server
  • Rapid Home Provisioning
Using General Overall Database
  • Install Oracle Database software
  • Create, Delete and Configure Databases using DBCA
  • Creating CDBs and Regular PDBs
  • Use Miscellaneaous 19c New Features
Using Availability
  • Use an RMAN recovery catalog
  • Use Flashback Database
Using Diagnosibility Enhancements
  • Use new Diagnoseability Features
Monitoring and Tuning Database Performance
  • Managing Memory Components
  • Understanding The Automatic Workload Repository (AWR)
  • Understanding The Advisory Framework
  • Monitoring Wait Events, Sessions, and Services
  • Managing Metric Thresholds and Alerts
  • Understanding and Using The Performance Tuning Methodology
  • Performing Performance Planning
  • Understanding The Automatic Database Diagnostic Monitor (ADDM)
Tuning SQL Statements
  • Understanding The Oracle Optimizer
  • Using The SQL Tuning Advisor
  • Managing Optimizer Statistics
  • Using The SQL Access Advisor
  • Understanding The SQL Tuning Process
Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

Oracle OCP 19C Training - Upcoming Batches

Coming Soon

AM IST

Weekday

Coming Soon

AM IST

Weekday

Coming Soon

PM IST

Weekend

Coming Soon

PM IST

Weekend

Don't find suitable time ?

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

Oracle OCP 19C Training FAQ'S

What is Oracle 19c?

Oracle Database 19c is the long-term support release of the Oracle Database 12c family, offering stability and extended support. It includes improvements in performance, multitenancy, security, and high availability.

What are the key new features in Oracle 19c?
  • Automatic Indexing

  • Real-Time Statistics & Statistics Feedback

  • Quarantine for problematic SQL

  • Hybrid Partitioned Tables

  • Data Guard DML redirection (for Active Data Guard)

  • JSON support improvements

  • PDB Lifecycle Management Enhancements

What is a Container Database (CDB) and Pluggable Database (PDB)?

A CDB is a multitenant container database that contains zero or more PDBs.

  • A PDB is a self-contained database within the CDB.

  • Oracle 19c mandates multitenant architecture as standard.

What is Active Data Guard in 19c?
  • A feature allowing a read-only standby database to be open for reporting.

  • New in 19c: DML Redirection, where simple DMLs can be automatically redirected to the primary

Get Head in your Career by Learning Oracle OCP 19C Through Viswa Online Trainings

Reviews

Quick Links