Oracle 19c Database Administration 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.
Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs and skill-level.
Oracle Database Architecture
Oracle Database Server Architecture
Oracle Database Instance Configurations
Connecting to the Database Instance
Oracle Database Memory Structures
Creating DBCS Database Deployments
Automated Database Provisioning
Creating a Database Deployment
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
Managing DBCS Database Deployments
Managing the Compute Node
Scaling a Database Deployment
Patching DBCS
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
Oracle Net Services
Oracle Net Services
Oracle Net Listener
The Default Listener
Establishing Oracle Network Connections
Connecting to an Oracle Database
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
Creating PDBs
Creating a New PDB from PDB$SEED
Cloning PDBs
Unplugging and Plugging in PDBs
Plugging an Unplugged Regular PDB into a CDB
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
Managing Storage Space
Space Management Features
Block Space Management
Row Chaining and Migration
Types of Segments
Allocating Extents
Managing Undo Data
Undo Data
Moving Data
Oracle Data Pump
SQL Loader
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
Backup and Recovery Configuration
Configuring for Recoverability
Redo Log Files
Creating Database Backups
RMAN Backup
Backing Up Databases on DBCS
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
Monitoring and Tuning Database Performance
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
Advisory Framework
Tuning SQL
SQL Tuning Process
Oracle Optimizer
Optimizer Statistics
SQL Plan
What You'll Learn
Our engaging instructors and mentors are highly-experienced practitioners who bring years of current “on-the-job” experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will learn 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
Target Audience
This hands-on course is geared for experienced DBAs new to Oracle 19c.
Prerequisites
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
Inclusions
With CCS Learning Academy, you’ll receive:
Certified Instructor-led training
Official Training Seminar Student Handbook
Pre and Post assessments/evaluations
Collaboration with classmates (not currently available for self-paced course)
Real-world learning activities and scenarios
Exam scheduling support*
Enjoy job placement assistance for the first 12 months after course completion.
This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
Government and Private pricing available.*
*For more details call:Â 858-208-4141Â or email:Â training@ccslearningacademy.com; sales@ccslearningacademy.com
