Premium Features

Previous Buy now to get complete version Next
  • Home
uCertify Logo
  • login
  • Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

Oracle DB 12c Administrator Certified Professional

(1Z0-063.AE1) / ISBN: 978-1-64459-292-2
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
1Z0-063.AE1 : Oracle DB 12c Administrator Certified Professional
Try this course Pre-Assessment and first two Lessons free No credit card required
Are you an instructor? Teach using uCertify products
Request a free evaluation copy

Oracle DB 12c Administrator Certified Professional

Here's what you will get

Lessons
  • 14+ Lessons
  • 269+ Exercises
  • 144+ Quizzes
  • 107+ Flashcards
  • 107+ Glossary of terms
TestPrep
  • 50+ Pre Assessment Questions
  • 2+ Full Length Tests
  • 50+ Post Assessment Questions
  • 100+ Practice Test Questions
LiveLab
  • 19+ LiveLab
Here's what you will learn
Download Course Outline
Lesson 1: Performing Oracle User-Managed Backups
  • Oracle Database Data Protection Options
  • Understanding the Oracle Database as It Relates to Backup and Recovery
  • Configuring the Database for Backup and Recovery
  • Performing Oracle Offline Backups
  • Performing Oracle Online Backups
  • Backing Up the Control File
  • Summary
  • Exam Essentials
Lesson 2: Performing Oracle User-Managed Database Recoveries
  • Performing a Recovery in NOARCHIVELOG Mode
  • Performing a Full Database Recovery in ARCHIVELOG Mode
  • Performing User-Based Incomplete Recoveries
  • Performing Other Types of Recoveries
  • Summary
  • Exam Essentials
Lesson 3: Configuring and Backing Up Oracle Databases Using RMAN
  • Why Use RMAN?
  • Exploring the RMAN Architecture
  • Getting Started with RMAN
  • Configuring RMAN
  • Backing Up Your Database with RMAN
  • Summary
  • Exam Essentials
Lesson 4: Using the RMAN Recovery Catalog
  • Introducing the Recovery Catalog
  • Creating the Recovery Catalog User and Schema Objects
  • Using a Recovery Catalog
  • Using Scripts in the RMAN Recovery Catalog
  • Maintaining the Recovery Catalog
  • Using the RMAN Virtual Private Catalog
  • Summary
  • Exam Essentials
Lesson 5: Recovering Databases with RMAN
  • RMAN Database-Recovery Basics
  • Recovering a Database in NOARCHIVELOG Mode
  • Recovering a Database in ARCHIVELOG Mode
  • Recovering a Database Using Incomplete Recovery
  • Using Image Copies to Recover Your Database
  • Other Basic Recovery Topics
  • Summary
  • Exam Essentials
Lesson 6: Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow
  • Overview of the RMAN Report and List Commands
  • Monitoring, Administering, and Tuning RMAN
  • The Oracle Database Fault Diagnostic Framework
  • Summary
  • Exam Essentials
Lesson 7: Performing Oracle Advanced Recovery
  • Switching between RMAN Incarnations
  • Overview of RMAN Database Duplication
  • Performing an RMAN Tablespace Point-in-Time Recovery
  • Restoring a Database to a New Host
  • Backup Best Practices for Data Warehouses
  • Performing Table and Partition Recovery from Backups
  • ASM-Related Backups
  • Configuring and Using Oracle Secure Backup
  • Oracle Database 12c Multitenant Architecture and RMAN
  • Summary
  • Exam Essentials
Lesson 8: Understanding Flashback Technology
  • Describe the Flashback Technologies
  • Managing Undo Automatically
  • Employing Flashback Technologies
  • Perform Flashback Database Operations
  • Summary
  • Exam Essentials
Lesson 9: Diagnosing the Database and Managing Performance
  • Diagnosing Failures
  • Managing Database Performance
  • Summary
  • Exam Essentials
Lesson 10: Managing Database Resources
  • Managing Storage
  • Managing Storage in a CDB and PDBs
  • Summary
  • Exam Essentials
Lesson 11: Creating Oracle Multitenant Databases
  • Multitenant Container and Pluggable Database Architecture
  • Creating Multitenant Container Databases and Pluggable Databases
  • Summary
  • Exam Essentials
Lesson 12: Managing Oracle Multitenant Databases
  • Establishing Connections to CDB/PDB
  • Start Up and Shut Down a CDB and Open and Close PDBs
  • Evaluate the Impact of Parameter Value Changes
  • Summary
  • Exam Essentials
Lesson 13: Oracle Utilities
  • Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
  • Summary
  • Exam Essentials
Lesson 14: Oracle Security in CDBs and PDBs
  • Managing Security in a CDB and PDBs
  • Summary
  • Exam Essentials

Hands on Activities (Live Labs)

Performing Oracle User-Managed Backups

  • Putting a Database in ARCHIVELOG Mode
  • Executing an Offline Backup

Performing Oracle User-Managed Database Recoveries

  • Recovering the Database from the Loss of All Data Files

Configuring and Backing Up Oracle Databases Using RMAN

  • Configuring RMAN
  • Executing an Online Backup of your ARCHIVELOG Mode Database

Using the RMAN Recovery Catalog

  • Creating a Recovery Catalog Schema

Recovering Databases with RMAN

  • Restoring your ARCHIVELOG Mode Database with RMAN

Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow

  • Using the REPORT Command
  • Using the LIST Command

Performing Oracle Advanced Recovery

  • Performing a Tablespace Point in Time Recovery

Understanding Flashback Technology

  • Purging a Table from the Recycle Bin
  • Using Flashback Table

Diagnosing the Database and Managing Performance

  • Setting the Diagnostic Destination
  • Using ADRCI

Creating Oracle Multitenant Databases

  • Creating a New CDB Using SQL*Plus

Managing Oracle Multitenant Databases

  • Connecting to a CDB Using SQL*Plus
  • Connecting to a PDB Using SQL*Plus

Oracle Utilities

  • Using Data Pump to Migrate a Non-CDB to a CDB

Oracle Security in CDBs and PDBs

  • Creating Common and Local Users
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept