Skill Up Card - Course Bundles

Pricing is per delegate, giving you huge savings over the cost of individual courses.

  • UK = £2,000 + VAT per Skill Up Card
  • Ireland = €2,400 per Skill Up Card
skill up card logo - Nexus Human

Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619)

4.6 out of 5 rating Last updated 14/11/2024   English

Jump to outline

Global Schedule

GTR = Guaranteed to Run

10 Feb 25 Book
15:00 - 23:00 Live Online 2,632
14 Apr 25 Book
15:00 - 23:00 Live Online 2,632

02 Jun 25 Book
15:00 - 23:00 Live Online 2,632
21 Jul 25 Book
15:00 - 23:00 Live Online 2,632
29 Sep 25 Book
15:00 - 23:00 Live Online 2,632
15 Dec 25 Book
15:00 - 23:00 Live Online 2,632
Duration

5 Days

30 CPD hours

Overview

This course is about 50% hands-on lab to lecture ration, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will explore:
- Creating CDBs and Regular PDBs
-Managing CDBs and PDBs
-Backup and Duplicate
-Upgrading and Transporting CDBs and Regular PDBs
-Backup Strategies and Terminology
-Restore and Recovery Concepts
-Using Flashback Technologies
-Duplicating a Database
-Installing Grid Infrastructure and Oracle Database
-Patching Grid Infrastructure and Oracle Database
-Upgrading to Oracle Grid Infrastructure
-Using General Overall Database Enhancements
-Monitoring and Tuning Database Performance
-Managing Application PDBs
-Managing Security in Multitenant databases
-Recovery and Flashback
-Configuring and Using RMAN
-Diagnosing Failures
-Performing Recovery
-Transporting Data
-RMAN Troubleshooting and Tuning
-Creating an Oracle Database by using DBCA-
-Oracle Restart
-Upgrading the Oracle Database
-Installing Grid Infrastructure for a Standalone server
-Using Availability Enhancements
-Tuning SQL Statements

Description

Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration Workshop II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.

Prerequisites

This hands-on course is geared for experienced DBAs with basic Oracle 19c skills.

Creating CDBs and Regular PDBs

Configure and create a CDB
Create a new PDB from the CDB seed
Explore the structure of PDBs
Manage CDBs and PDBs

Manage PDB service names and connections
Manage startup, shutdown and availability of CDBs and PDBs
Change the different modes and settings of PDBs
Evaluate the impact of parameter value changes
Performance management in CDBs and PDBs
Control CDB and PDB resource usage with the Oracle Resource Manager
Backup and Duplicate

Perform Backup and Recover CDBs and PDBs
Duplicate an active PDB
Duplicate a Database
Upgrading and Transporting CDBs and Regular PDBs

Upgrade an Oracle Database
Transport Data
Backup Strategies and Terminology

Perform Full and Incremental Backups and Recoveries
Compress and Encrypt RMAN Backups
Use a media manager
Create multi-section backups of exceptionally large files
Create duplexed backup sets
Create archival backups
Backup of recovery files
Backup non database files
Back up ASM meta data
Restore and Recovery Concepts

Employ the best Oracle Database recovery technology for your failure situation
Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery
Using Flashback Technologies

Configure your Database to support Flashback
Perform flashback operations
Duplicating a Database

Duplicate Databases
Install Grid Infrastructure and Oracle Database

Install Grid Infrastructure for a Standalone server
Install Oracle Database software
Patching Grid Infrastructure and Oracle Database

Patch Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure

Upgrade Oracle Grid Infrastructure
Oracle Database 18c: New Features

Image and RPM based Database Installation
Using General Overall Database Enhancements

Install Oracle Database software
Create, Delete and Configure Databases using DBCA
Creating CDBs and Regular PDBs
Use Miscellaneous 19c New Features
Monitoring and Tuning Database Performance

Managing Memory Components
Understanding the Automatic Workload Repository (AWR)
Understanding the Advisory Framework
Monitoring Wait Events, Sessions, and Services
Managing Metric Thresholds and Alerts
Understanding and Using the Performance Tuning Methodology
Performing Performance Planning
Understanding the Automatic Database Diagnostic Monitor (ADDM)
Manage Application PDBs

Explain the purpose of application root and application seed
Define and create application PDBs
Install, upgrade and Patch applications
Create and administer Application PDBS
Clone PDBs and Application containers
Plug and unplug operations with PDBs and application containers
Comparing Local Undo Mode and Shared Undo Mode
Manage Security in Multitenant databases

Manage Security in Multitenant databases
Manage PDB lockdown profiles
Audit Users in CDBs and PDBs
Manage other types of policies in application containers
Recovery and Flashback

Restore and Recovering Databases with RMAN
Perform CDB and PDB flashback
Configuring and Using RMAN

Configure RMAN and the Database for Recoverability
Configure and Using an RMAN recovery catalog
Diagnosing Failures

Detect and repair database and database block corruption
Diagnosing Database Issues
Performing Recovery

Restore and Recovering Databases with RMAN
Perform Non RMAN database recovery
Transporting Data

Transport Data
RMAN Troubleshooting and Tuning

Interpret the RMAN message output
Diagnose RMAN performance issues
Creating an Oracle Database by using DBCA

Create, Delete and Configure Databases using DBCA
Oracle Restart

Configure and use Oracle Restart to manage components
Upgrade the Oracle Database

Plan for Upgrading an Oracle Database
Upgrade an Oracle Database
Perform Post-Upgrade tasks
Install Grid Infrastructure for a Standalone server

Rapid Home Provisioning
Using Availability Enhancements

Use an RMAN recovery catalog
Use Flashback Database
Tuning SQL Statements

Understanding the Oracle Optimizer
Using the SQL Tuning Advisor
Managing Optimizer Statistics
Using the SQL Access Advisor
Understanding the SQL Tuning Process
Additional course details:

Nexus Humans Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the ITS Data Analytics course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FAQ for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) Course

Available Delivery Options for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training.
  • Live Instructor Led Classroom Online (Live Online)
  • Traditional Instructor Led Classroom (TILT/ILT)
  • Delivery at your offices in London or anywhere in the UK
  • Private dedicated course as works for your staff.
How many CPD hours does the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training provide?

The 5 day. Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training course give you up to 30 CPD hours/structured learning hours. If you need a letter or certificate in a particular format for your association, organisation or professional body please just ask.

Which exam does the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training course prepare you for?

The Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) prepares you for the Yes official exam. You can take this exam at any exam center across UK including, England, Scotland, Cymru (Wales) or Northern Ireland or live online where ever you are. Exams vary in duration and if required you can request with the provider for any accommodations appropriate for you.

What is the correct audience for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training?

This hands-on course is geared for experienced DBAs with basic Oracle 19c skills.

Do you provide training for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619).

Yes we provide corporate training, dedicated training and closed classes for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619). This can take place anywhere in UK including, England, Scotland, Cymru (Wales) or Northern Ireland or live online allowing you to have your teams from across UK or further afield to attend a single training event saving travel and delivery expenses.

What is the duration of the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) program.

The Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training takes place over 5 day(s), with each day lasting approximately 8 hours including small and lunch breaks to ensure that the delegates get the most out of the day.

What other terms do people search for when looking for this course?

Popular related searched include Oracle DBA; Database.

Why are Nexus Human the best provider for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619)?
Nexus Human are recognised as one of the best training companies as they and their trainers have won and hold many awards and titles including having previously won the Small Firms Best Trainer award, national training partner of the year for UK on multiple occasions, having trainers in the global top 30 instructor awards in 2012, 2019 and 2021. Nexus Human has also been nominated for the Tech Excellence awards multiple times. Learning Performance institute (LPI) external training provider sponsor 2024.
Is there a discount code for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training.

Yes, the discount code PENPAL5 is currently available for the Oracle 19c Database Administration II (Oracle 19c DBA II) (TTOR20619) training. Other discount codes may also be available but only one discount code or special offer can be used for each booking. This discount code is available for companies and individuals.

Jump to dates

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable. To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

What people say about us


Top