Oracle 19c Database Administration I

*Looking for flexible schedule (after hours or weekend)? Please call or email us: 858-208-4141 or sales@ccslearningacademy.com.

Student financing options are available.
Looking for group training? Contact Us
Category:

Download PDF of Course Details

Course Description:

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.

Format

Instructor-Led

Topic

Vendor

Oracle

Length

Course Topics

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
  • 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

 

Shopping Cart
en_USEnglish