Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

courses popup callback

LIVE LAB:

Oracle 12c OCP 1Z0-062: Installation and Administration

Practical exercises in a live environment to help you get real-world, hands-on experience.

Overview

The Oracle-1Z0-062 Practice Lab will provide you with the necessary platform to gain hands on skills in Oracle. By completing the lab tasks you will improve your practical skills in Database Management Tools, Database instances, Configuring Oracle Network Environments, Managing Database Storage Structures, Administering User Security, Managing Space, Undo Data and Data Concurrency, implementing Database Audits, Performing Database Maintenance, Configuring Backup and Recovery, Installing Oracle and Creating and Upgrading Oracle Databases. These same tasks will help you understand the objectives and competencies required by the Oracle 1Z0-062 certification exam.

Vendor:   Oracle
Vendor Id:   ORACLE-1Z0-062
Version:   1
Level:   Entry
Learning Time:   1080  Minutes

Exercises

  1. Oracle Database Instances
  2. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Exercise 1 - Understanding Initialization Parameter Files
    • Exercise 2 - Starting Up and Shutting Down an Oracle Instance
    • Exercise 3 - Viewing the Alert Logs and Access Dynamic Performance View
    • Summary
  3. Configuring an Oracle Network Environment
  4. Total Learning Time is 60  Minutes and module version is 10

    Exercises:
    • Introduction
    • Exercise 1 - Managing Oracle Listeners
    • Exercise 2 - Configure the Client Side Network
    • Exercise 3 - Configure Communication Between Databases
    • Summary
  5. Managing Database Storage Structures
  6. Total Learning Time is 60  Minutes and module version is 11

    Exercises:
    • Introduction
    • Exercise 1 - Creating and Managing Tablespaces
    • Exercise 2 - Performing Operations
    • Summary
  7. Administering User Security
  8. Total Learning Time is 60  Minutes and module version is 9

    Exercises:
    • Introduction
    • Exercise 1 - Create and Manage Database User Accounts
    • Exercise 2 - Granting and Revoking Privileges
    • Exercise 3 - Creating and Managing Roles
    • Exercise 4 - Creating and Managing Profiles
    • Summary
  9. Managing Space
  10. Total Learning Time is 60  Minutes and module version is 5

    Exercises:
    • Introduction
    • Exercise 1 - Using Compression to Save Space
    • Exercise 2 - Monitor and Manage Tablespace Usage
    • Exercise 3 - Manage Resumable Space Allocation
    • Summary
  11. Managing Data Concurrency and Undo
  12. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Exercise 1 - Monitor and Administer UNDO
    • Exercise 2 - Configure UNDO Retention
    • Exercise 3 - Monitor and Resolve Locking Conflicts
    • Summary
  13. Implementing Oracle Database Auditing
  14. Total Learning Time is 60  Minutes and module version is 4

    Exercises:
    • Introduction
    • Exercise 1 - Auditing Database Activity
    • Exercise 2 - Purging the Audit Trail
    • Exercise 3 - Managing Fine Grained Auditing
    • Exercise 4 - Implementing Unified Auditing
    • Summary
  15. Using Backup and Recovery Concepts
  16. Total Learning Time is 60  Minutes and module version is 3

    Exercises:
    • Introduction
    • Exercise 1 - Multiplexing Control Files
    • Exercise 2 - Using Redo Log Files
    • Exercise 3 - Understanding Archived Redo Log Files
    • Exercise 4 - Understanding the Fast Recovery Area
    • Exercise 5 - Performing Control File Backups
    • Exercise 6 - Performing Database Backups
    • Exercise 7 - Performing Backup Using RMAN
    • Summary
  17. Performing Database Recovery
  18. Total Learning Time is 60  Minutes and module version is 3

    Exercises:
    • Introduction
    • Exercise 1 - Performing Recovery Operations
    • Exercise 2 - Recovering from User Errors
    • Exercise 3 - Recovering from a Loss of a Control File
    • Exercise 4 - Recovering from the Loss of a Redo Log File
    • Exercise 5 - Recovering from a Loss of a Non-System Critical Data File
    • Exercise 6 - Recovering from a Loss of a System Critical Data File
    • Summary
  19. Moving Data
  20. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Exercise 1 - Moving Data
    • Exercise 2 - Using Data Pump to Move Data between Oracle Databases
    • Exercise 3 - Using External Tables to Move Data
    • Summary
  21. Managing Database Performance
  22. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Exercise 1 - Managing Optimizer Statistics
    • Exercise 2 - Gathering Performance Statistics
    • Exercise 3 - Automatic Database Diagnostic Monitoring
    • Exercise 4 - Understanding Automatic Diagnostic Repository
    • Exercise 5 - Automatic Shared Memory Management
    • Exercise 6 - Automatic SQL Execution Memory Management
    • Summary
  23. Managing Resource Using Database Resource Manager
  24. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Exercise 1 - Configuring the Database Resource Manager
    • Exercise 2 - Accessing and Creating Resource Plans
    • Exercise 3 - Monitor the Resource Manager
    • Summary
  25. Automating Tasks Using Oracle Scheduler
  26. Total Learning Time is 60  Minutes and module version is 4

    Exercises:
    • Introduction
    • Exercise 1 - Understanding Oracle Scheduler
    • Exercise 2 - Using Oracle Scheduler
    • Exercise 3 - Relating Tasks with Job Chains
    • Exercise 4 - Scheduling Jobs on Remote Systems
    • Exercise 5 - Prioritizing Jobs With Oracle Scheduler
    • Summary
  27. Installing Oracle Grid Infrastructure and Using Oracle Restart
  28. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Exercise 1 - Creating Disk Groups
    • Exercise 2 - Installing Grid Infrastructure for a Standalone Server
    • Exercise 3 - Registering Components with Oracle Restart
    • Exercise 4 - Starting and Stopping the Oracle Restart
    • Summary
  29. Installing Oracle 12c
  30. Total Learning Time is 60  Minutes and module version is 6

    Exercises:
    • Introduction
    • Exercise 1 - Installing Oracle Database Software
    • Summary
  31. Creating an Oracle Database Using DBCA
  32. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Exercise 1 - Creating a Database using DBCA
    • Exercise 2 - Configuring an Oracle Database Using DBCA
    • Exercise 3 - Creating Template Definitions Using the DBCA
    • Exercise 4 - Deleting an Oracle Database Using DBCA
    • Summary
  33. Upgrading to Oracle 12c
  34. Total Learning Time is 60  Minutes and module version is 4

    Exercises:
    • Introduction
    • Exercise 1 - Preparing a Database Upgrade
    • Exercise 2 - Upgrading the Database
    • Exercise 3 - Performing Manual Upgrade
    • Summary
  35. Migrating Data Using Oracle Data Pump
  36. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Exercise 1 - Oracle Data Pump
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top