Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

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

Oracle Database 12c - Installation and Administration

LIVE LAB:

Oracle Database 12c - 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. 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. 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. Exercises:
    • Introduction
    • Exercise 1 - Creating and Managing Tablespaces
    • Exercise 2 - Performing Operations
    • Summary
  7. Administering User Security
  8. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. Exercises:
    • Introduction
    • Exercise 1 - Installing Oracle Database Software
    • Summary
  31. Creating an Oracle Database Using DBCA
  32. 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. 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. 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.
USD 295 USD 120 59% OFF
  • 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