Oracle Database Administration Learning Subscription

Course Details
Code: OR-DBA-LS
Tuition (USD): $6,995.00 • Subscription
Generate a quote

Access Comprehensive Oracle Database Training – Explore New Features and Develop Advanced Oracle Database Administration Skills The Oracle Database Administration Learning Subscription will provide you with access to all available Oracle Database administration training courses. This includes the Oracle Database 19c new features curriculum as well as courseware from all supported released versions of Oracle Database training, from 11g through 19c. Oracle University’s specialty Oracle Database training curriculum courses are also included. Grow your skills by taking recommended courses in the following product areas:

  • Database Security
  • Enterprise Manager
  • High Availability, including RAC, ASM, Clusterware, and Data Guard
  • Oracle Database Appliance (ODA)
  • Exadata Database Machine

Skills Gained

  • Become familiar with the Oracle Database architecture so you can describe the many areas you need to understand to manage it properly and benefit from its capabilities
  • Understand the Oracle Database Cloud Service (DBCS) architecture and features
  • Manage database security and implement auditing
  • Implement basic backup and recovery procedures
  • Move data between databases and files
  • Employ basic monitoring procedures and manage performance
  • Plan effective backup and recovery procedures
  • Configure the database for recoverability
  • Use Recovery Manager (RMAN) to create backups and perform recovery operations
  • Use the Data Recovery Advisor to diagnose and repair failures
  • Use Oracle Flashback Technologies to recover from human error
  • Perform an encrypted database backup and restore
  • Perform tablespace point-in-time recovery Manage PDB snapshots
  • Encrypt data in PDBs and isolate PDB keystore
  • Monitor performance in CDBs and PDBs
  • Protect data with Database Vault policies in CDB and PDBs
  • Manage a CDB fleet
  • Manage resource allocation between PDBs and within a PDB
  • Use Data Pump operations from a non-CDB or CDB into a PDB
  • Upgrade 12c CDBs or PDBs to 18c
  • Configure and create a CDB
  • Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
  • Backup, duplicate, recover, and flashback CDB and PDBs
  • Rack and cable a new Oracle Database Appliance engineered system
  • Power on the system for the first time and define network options
  • Configure Oracle Integrated Lights Out Manager (ILOM)
  • Validate Oracle Appliance Manager software version and re-image Operating System, if needed
  • Download and install the latest Oracle Database Appliance Patch-Set Bundle
  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database
  • Describe and determine database security requirements
  • Understand Oracle security solutions to help meet security requirements
  • Implement basic database security
  • Configure network security
  • Enumerate Oracle auditing solutions to monitor database security requirements
  • Implement Oracle Audit Vault and Database Firewall
  • Configure and use Transparent Data Encryption
  • Grasp and use Oracle Key Vault Security measures
  • Understand Oracle Data Redaction
  • Understand and use Oracle Data Masking and Subsetting
  • Grasp potential security risks and identify appropriate Oracle solutions
  • Configure general authentication and authorization
  • Understand and implement Global Users
  • Set up and maintain a simple wallet
  • Install and use Oracle Database Vault
  • Configure and use Transparent Sensitive Data Protection
  • Describe the key capabilities of Exadata Database Machine
  • Identify the benefits of using Exadata Database Machine for different application classes
  • Describe the architecture of Exadata Database Machine and its integration with Oracle Database, Clusterware, and ASM
  • Configure I/O Resource Management
  • Complete the initial configuration of Exadata Database Machine
  • Describe recommended approaches for migrating to Exadata Database Machine
  • Gain an understanding of the Oracle Database Exadata Cloud Service
  • Monitor Exadata Database Machine health and optimize performance

Who Can Benefit

  • Database administrator
  • Database architects
  • Database administrators
  • Database architects
  • Developers
  • IT managers
  • Security administrators
  • Web administrators
  • Data scientists
  • Database developers
  • NoSQL developers

Course Details

Course Outline

  • Oracle Database 18c: High Availability New Features
  • Working with Virtual Machines
  • Working with Endpoints
  • Working With Files and Directories
  • Virtualized Platform Deployments
  • Using the SQL Performance Analyzer
  • Using the New Features of RMAN
  • Using the Data Masking Pack
  • Using Transparent Sensitive Data Protection
  • Using Subqueries to Solve Queries
  • Using Strong Authentication
  • Using Smart Scan
  • Using Single-Row Functions to Customize Output
  • Using SQL New Features and SQLcl
  • Using Real Application Testing Enhancements
  • Using Proxy Authentication
  • Using Privilege Analysis
  • Using Oracle Scheduler to Automate Tasks
  • Using Oracle Data Pump, SQL*Loader, and External Tables
  • Using Multitenant Enhancements
  • Using Metrics and Alerts
  • Using In-Memory Column Store
  • Using In-Database Archiving and Temporal
  • Using Host Monitoring
  • Using Global User Authentication
  • Using General Database Enhancements
  • Using Flashback Technologies
  • Using Fine-Grained Audit
  • Using Enterprise User Security
  • SQL Enhancements
  • Restricting and Sorting Data
  • Restore and Recovery Concepts
  • Redacting Data
  • Recovery and Flashback of PDBs
  • Real-Time Database Operation Monitoring
  • RAC Databases Overview and Architecture
  • Privileges
  • Performing Recovery I
  • Performance in CDBs and PDBs
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward