Oracle Database 19c: DBA OCP Certification 1Z0-071, 1Z0-149 and 1Z0-083

The WebLearning Oracle Database 19c: OCP DBA Certification course combines Oracle Certified Associate and Professional Exams Oracle Database: Introduction to SQL 1Z0-071, Oracle Database 19c: Program with PL/SQL - 1Z0-149 and Oracle Database 19c: Administration Workshop II -1Z0-083. 

On successful Completion of this course you will be able to:

• Understand Oracle Database Tools
• Learn Data Definition Language - DDL
• Learn Data Manipulation Language - DML
• Learn Data Control Language - DCL
• Create, execute, and maintain
• Procedures and functions
• Package constructs
• Database triggers
• Manage PL/SQL subprograms and triggers
• Use a subset of Oracle-supplied packages to generate screen and file output
• Identify various techniques that impact your PL/SQL code design considerations
• Use the PL/SQL compiler and manage dependencies
• Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
• Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
• Use an appropriate and flexible memory configuration for your database
• Identify burdensome database sessions and poorly performing SQL
• Configure the Oracle Database for optimal recovery
• Configure the database instance such that resources are appropriately allocated among sessions and tasks
• Schedule jobs to run inside or outside of the database
• Use compression to optimize database storage and duplicate a database