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 (DBA II) (TTOR20619)

4.6 out of 5 rating Last updated 13/12/2024   English

Jump to outline

Click "Enquire" below to find out more about this course

Interested in available dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.


Duration

5 Days

30 CPD hours

Overview

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. 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 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.

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
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 (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 Oracle 19c Database Administration II (DBA II) (TTOR20619) 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 (DBA II) (TTOR20619) Course

Available Delivery Options for the Oracle 19c Database Administration II (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 (DBA II) (TTOR20619) training provide?

The 5 day. Oracle 19c Database Administration II (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.

What is the correct audience for the Oracle 19c Database Administration II (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 (DBA II) (TTOR20619).

Yes we provide corporate training, dedicated training and closed classes for the Oracle 19c Database Administration II (DBA II) (TTOR20619). This can take place anywhere in Ireland including, Dublin, Cork, Galway, Northern Ireland or live online allowing you to have your teams from across Ireland 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 (DBA II) (TTOR20619) program.

The Oracle 19c Database Administration II (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.

Why are Nexus Human the best provider for the Oracle 19c Database Administration II (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 Ireland 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 (DBA II) (TTOR20619) training.

Yes, the discount code PENPAL5 is currently available for the Oracle 19c Database Administration II (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

}