Oracle 19c Database Administration

Trivera Technologies LLC
Training overview
Professional Course
5 days

Course description

Oracle 19c Database Administration

Oracle 19C Database Administration is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies.

Want to find out more?

Who should attend?

This hands-on course is geared for experienced DBAs new to Oracle 19c. Incoming students should possess:

  • Basic understanding of Oracle Database principles
  • Linux skills, including familiarity with command-line options such as ls, cd, cp, and su
  • Beginning to intermediate proficiency with SQL

Training content


  1. Oracle Database Architecture
    • Oracle Database Server Architecture
    • Oracle Database Instance Configurations
    • Connecting to the Database Instance
    • Oracle Database Memory Structures
  2. Creating DBCS Database Deployments
    • Automated Database Provisioning
    • Creating a Database Deployment
  3. Accessing an Oracle Database
    • Connecting to an Oracle Database Instance
    • Oracle Database Tools
    • SQL*Plus
    • Oracle SQL Developer
    • SQL Developer Command Line (SQLcl)
    • Database Configuration Assistant (DBCA)
    • Oracle Enterprise Manager Database Express
    • Enterprise Manager Cloud Control 13c Features
  4. Managing DBCS Database Deployments
    • Managing the Compute Node
    • Scaling a Database Deployment
    • Patching DBCS
  5. Managing Database Instances
    • Working with Initialization Parameters
    • Starting the Oracle Database Instance
    • Shutting Down an Oracle Database Instance
    • Opening and Closing PDBs
    • Alert Log
    • Trace Files
    • DDL Log File
  6. Oracle Net Services
    • Oracle Net Services
    • Oracle Net Listener
    • The Default Listener
    • Establishing Oracle Network Connections
    • Connecting to an Oracle Database
  7. User Security
    • Database User Accounts
    • Oracle-Supplied Administrator Accounts
    • Creating Oracle Database Users in a Multitenant Environment -9
    • Schema-Only Account
    • Authenticating Users
    • System Privileges for Administrators
    • Object Privileges
    • Granting Privileges in a Multitenant Environment
    • Granting and Revoking System Privileges
    • Granting and Revoking Object Privileges
  8. Creating PDBs
    • Creating a New PDB from PDB$SEED
    • Cloning PDBs
    • Unplugging and Plugging in PDBs
    • Plugging an Unplugged Regular PDB into a CDB
  9. Creating and Managing Tablespaces
    • Creating Tablespaces
    • Creating Permanent Tablespaces in a CDB
    • Altering and Dropping Tablespaces
    • Viewing Tablespace Information
    • Tablespace Encryption by Default in DBCS
  10. Managing Storage Space
    • Space Management Features
    • Block Space Management
    • Row Chaining and Migration
    • Types of Segments
    • Allocating Extents
  11. Managing Undo Data
    • Undo Data
  12. Moving Data
    • Oracle Data Pump
    • SQL Loader
  13. Backup and Recovery Concepts
    • Types of Failures
    • Instance Recovery
    • The Checkpoint (CKPT) Process
    • Redo Log Files and the Log Writer (LGWR)
    • Automatic Instance Recovery or Crash Recovery
    • Using the MTTR Advisor
    • Complete Recovery Process
    • The Point-in-Time Recovery Process
    • Flashback
  14. Backup and Recovery Configuration
    • Configuring for Recoverability
    • Redo Log Files
  15. Creating Database Backups
    • RMAN Backup
    • Backing Up Databases on DBCS
  16. Performing Database Recovery
    • Data Recovery Advisor
    • Loss of a Control File
    • Loss of a Redo Log File
    • DBCS: Performing Recovery by Using the Console
    • dbaascli Utility
  17. Monitoring and Tuning Database Performance
    • Automatic Workload Repository (AWR)
    • Automatic Database Diagnostic Monitor (ADDM)
    • Advisory Framework
  18. Tuning SQL
    • SQL Tuning Process
    • Oracle Optimizer
    • Optimizer Statistics
  19. SQL Plan

Costs

  • Price: 2,595.00
  • Discounted Price: 1,686.75

Why choose Trivera Technologies LLC?

Over 25 years of technology training expertise.

Robust portfolio of over 1,000 leading edge technology courses.

Guaranteed to run courses and flexible learning options.

About Trivera Technologies LLC

Trivera Technologies

Trivera Technologies is a IT education services & courseware firm that offers a range of wide professional technical education services including: end to end IT training development and delivery, skills-based mentoring programs,new hire training and re-skilling services, courseware licensing and...


Read more and show all training delivered by this supplier

Contact this provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

Country *

Contact info

Trivera Technologies LLC

7862 West Irlo Bronson Highway
STE 626
Kissimmee FL 34747

 Show phone number
www.triveratech.com

Learn more!

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available