info@prakshal.com
+91 93 2828 4040
QUICK ENQUIRY
CAREER
Calendar

OCA – ORACLE CERTIFIED ASSOCIATE

80 HOURS
Prerequisites :

Must have strong knowledge of C and C++

1Z0-071 : ORACLE DATABASE FUNDAMENTALS

  • Oracle and Structured Query Language (SQL) 
  • Restricting and Sorting Data 
  • Using Single-Row Functions to Customize Output 
  • Using Conversion Functions and Conditional Expressions 
  • Reporting Aggregated Data Using the Group Functions 
  • Displaying Data from Multiple Tables 
  • Using Subqueries to Solve Queries 
  • Using the Set Operators 
  • Manipulating Data 
  • Using DDL Statements to Create and Manage Tables 
  • Managing Objects with Data Dictionary Views 
  • Controlling User Access 
  • Managing Schema Objects 
  • Manipulating Large Data Sets

1Z0-052 : ORACLE DATABASE 11g ADMINISTRATION WORKSHOP I

  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data

OCP – ORACLE CERTIFIED PROFESSIONAL

40 HOURS
Prerequisites :

Must have strong knowledge of OCA

1Z0-053 : ORACLE DATABASE 11g ADMINISTRATION WORKSHOP II

  • Database Architecture and ASM
  • Configuring for Recoverability 
  • Using the RMAN Recovery Catalog
  • Configuring Backup Specifications
  • Using RMAN to Create Backups
  • Performing User-Managed Backup and Recovery
  • Using RMAN to Perform Recovery
  • Using RMAN to Duplicate a Database
  • Performing Tablespace Point-in-Time Recovery
  • Monitoring and Tuning RMAN
  • Using Flashback Technology
  • Additional Flashback Operations
  • Diagnosing the Database
  • Managing Memory
  • Managing Database Performance
  • Space Management
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Administering the Scheduler

UPGRADE TO ORACLE DATABASE 12c

40 HOURS
Prerequisites :

Must have strong knowledge of OCA

1Z0-060 : ORACLE DATABAE 12c ADMINISTRATOR CERTIFIED PROFESSIONAL (UPGRADE)

  • Enterprise Manager and Other Tools
  • Basics of Multitenant Container Database (CDB)
  • Configuring and Creating CDBs and PDBs
  • Managing CDBs and PDBs
  • Managing Tablespaces, Common and Local Users, Privileges and Roles
  • Backup, Recovery and Flashback for a CDB/PDB
  • Information Lifecycle Management and Storage Enhancements
  • In-Database Archiving and Valid-Time Temporal
  • Auditing
  • Privileges
  • Oracle Data Redaction
  • RMAN and Flashback Data Archive
  • Real-Time Database Operation Monitoring
  • SQL Tuning
  • Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics
  • Resource Manager and Other Performance Enhancements
  • Index and Table Enhancements
  • ADR and Network Enhancements
  • Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
  • Partitioning Enhancements
  • SQL Enhancements
Enrol Now