Oracle 19c Database Administration I (Oracle DBA I)

Explore Oracle 19c DB Architecture, DBCS Deployments, Managing Database Security, Backup and Recovery, Monitoring and More

TTOR02019

Introductory

5 Days

Course Overview

Oracle 19C Database Administration I (Oracle DBA I)  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.

NOTE: This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas.  This course is for 19c. It may also available for earlier editions (11g, 12c, etc). Please inquire for details.

Course Objectives

This course is approximately 50% hands-on, 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 learn how to:

  • Describe Oracle Database architecture
  • Describe Oracle Database Cloud Service (DBCS) architecture and features
  • Create and manage DBCS database deployments
  • Configure the database to support your applications
  • 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

Need different skills or topics?  If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate.  We offer additional Oracle, database, scripting, administration and other related topics that may be blended with this course for a track that best suits your needs.

Course Prerequisites

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

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

Please see the Related Courses tab for specific Pre-Requisite courses, Related Courses that offer similar skills or topics, and next-step Learning Path recommendations.

Course Agenda

  1. Oracle Database Architecture
  • Oracle Database Server Architecture
  • Oracle Database Instance Configurations  
  • Connecting to the Database Instance   
  • Oracle Database Memory Structures   
  1. Creating DBCS Database Deployments
  • Automated Database Provisioning   
  • Creating a Database Deployment   
  1. 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   
  1. Managing DBCS Database Deployments
  • Managing the Compute Node 
  • Scaling a Database Deployment   
  • Patching DBCS   
  1. 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   
  1. Oracle Net Services
  • Oracle Net Services
  • Oracle Net Listener
  • The Default Listener   
  • Establishing Oracle Network Connections   
  • Connecting to an Oracle Database   
  1. 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   
  1. Creating PDBs
  • Creating a New PDB from PDB$SEED   
  • Cloning PDBs   
  • Unplugging and Plugging in PDBs   
  • Plugging an Unplugged Regular PDB into a CDB    
  1. 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   
  1. Managing Storage Space
  • Space Management Features   
  • Block Space Management   
  • Row Chaining and Migration   
  • Types of Segments   
  • Allocating Extents   
  1. Managing Undo Data
  • Undo Data
  1. Moving Data
  • Oracle Data Pump
  • SQL Loader
  1. 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 
  1. Backup and Recovery Configuration
  • Configuring for Recoverability
  • Redo Log Files 
  1. Creating Database Backups
  • RMAN Backup
  • Backing Up Databases on DBCS  
  1. 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  
  1. Monitoring and Tuning Database Performance
  • Automatic Workload Repository (AWR)   
  • Automatic Database Diagnostic Monitor (ADDM)   
  • Advisory Framework   
  1. Tuning SQL
  • SQL Tuning Process 
  • Oracle Optimizer 
  • Optimizer Statistics  
  • SQL Plan

Course Materials

Student Materials: Each participant will receive a Student Guide with course notes, code samples, software tutorials, step-by-step written lab instructions, diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Setup Made Simple. All course labs and solutions, data sets, Oracle software (limited version, for course use only), detailed courseware, lab guides and resources (as applicable) are provided for attendees in our easy access, no installation required, remote lab environment for the duration of the course. Our tech team will help set up, test and verify lab access for each attendee prior to the course start date, ensuring a smooth start to class and successful hands-on course experience for all participants.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Attend a Course

Please see the current upcoming available open enrollment course dates posted below. Please feel free to Register Online below, or call 844-475-4559 toll free to connect with our Registrar for assistance. If you need additional date options, please contact us for scheduling.

Course Title Days Date Time Price
Oracle 19c Database Administration I (Oracle DBA I) 5 Days Sep 13 to Sep 17 10:00 AM to 06:00 PM EST $2,595.00 Enroll
Oracle 19c Database Administration I (Oracle DBA I) 5 Days Nov 15 to Nov 19 10:00 AM to 06:00 PM EST $2,595.00 Enroll

New Site, BIG Savings!
We're celebrating the launch of our lonnngggg awaited new site with with *50% off all 2021 Public Classes* booked by April 30!  Check out our Current Offers for Individuals, Teams and Organizations to Learn for Less!

See our latest Offers and Promotions

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More