Oracle Database Administration Learning Subscription

  • Tuition USD $6,995
  • Reviews star_rate star_rate star_rate star_rate star_half 839 Ratings
  • Course Code OR-DBA-LS
  • Duration 0 hours
  • Available Formats Subscription

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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

I've taken 2 AWS courses at ExitCertified both of them IMVP, they're my training provider of choice!

I had no problems signing up for and completing the course. The introduction was clear and helpful to get the course going. The course itself was excellent and very helpful.

The instructor is very good and very accommodating and excellent in answering participant's questions.

Excellent course. Ruben Lopez is an outstanding instructor. Learned tons of information. Would recommend ExitCertified to anyone!

Lectures are great, had a hard time with the lab exercises since instructions in the pdf are not that detailed.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward