25,000+ Courses Nationwide
0345 4506120

Oracle 18c DBA Fundamentals 1

Oracle 18c hands on practical course for database administrators.

Oracle 18c hands on training course for database administrators  that provides attendees with the essential skills and in depth product knowledge to undertake the day-to-day administration tasks required of an Oracle 18c database administrator.

Delegates will explore the Oracle 18c Database architecture and within this context understand how best to manage enterprise database resources effectively to create and manage Database Cloud Service database deployments.

On course attendees will explore how to manage an 18c Oracle Database instances and configure the Oracle Network environment, manage storage structures, data, and undertake proactive monitoring and performance tasks. 

Oracle 18c DBA Fundamentals I can be delivered as a closed course on your site or a third party location. As company specific training, we will work with you to tailor content to your organisation and project's  specific requirement and objectives. Please contact our Sales Team should you require a closed course/on site quotation to deliver this course to multiple delegates.

Who Should Attend?

  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Those upgrading from earlier versions

Select specific date to see price, venue and full details.

Pre-Requisites

The following skills are recommended:

  • Oracle SQL Fundamentals
  • Oracle PL/SQL Fundamentals is preferable

Course Content

Introduction

  • Oracle Database Editions, Options, and Management Packs
  • Oracle Cloud Overview
  • Sample HR Schema

Oracle Database Architecture 

  • Oracle Database Server Architecture
  • Oracle Database Instance Configurations
  • Connecting to the Database Instance
  • Oracle Database Memory and Process Structures
  • Logical and Physical Database Structures
  • Multitenant Architecture
  • Automatic Storage Management (ASM) Overview

Introdction to Oracle Database Cloud

  • Oracle Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning

Creating Oracle Database Cloud Service (DBCS) Deployments 

  • Input to the Creation Wizard
  • SSH Key Pairs
  • Database File Storage

Accessing an Oracle Database 

  • SQL*Plus
  • SQL Developer
  • Database Configuration Assistant (DBCA)
  • Oracle enterprise Manager Database Express
  • Oracle Enterprise Manager Cloud Control
  • Oracle Database Cloud Service Tools

Managing DBCS Database Deployments 

  • Managing the Compute Node
  • Managing Network Access to DBCS
  • Scaling a Database Deployment
  • Patching a Database Deployment

Managing Database Instances 

  • Initialization Parameter Files
  • Starting Up Oracle Database Instances
  • Shutting Down Oracle Database Instances
  • Automatic Diagnostic Repository (ADR)
  • Alert Log and Trace Files
  • Dynamic Performance Views
  • Data Dictionary Views

Oracle Net Services

  • Oracle Net Listener Overview
  • Connecting to an Oracle Database Instance
  • Naming Methods
  • Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • Comparing Dedicated and Shared Server Configurations

Administering User Security

  • Managing Oracle Cloud Users, Privileges, and Roles
  • Managing Oracle Database Users, Privileges, and Roles
  • User Authentication
  • Creating and Assigning Profiles
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege

Creating PDBs

  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed
  • Cloning PDBs
  • Unplugging and Plugging in PDBs
  • Dropping PDBs

Creating Master Encryption Keys for PDBs

  • Encryption in Oracle Database Cloud Service
  • Overview of Transparent Data Encryption (TDE)
  • CDB and PDB Master Encryption Keys
  • Creating and Activating an Encryption Key

Creating and Managing Tablespaces

  • Table Data Storage
  • Creating, Altering and Dropping Tablespaces
  • Viewing Tablespace Information
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files
  • Tablespace Encryption by Default in DBCS

Managing Storage Space

  • Oracle Database Space Management Features
  • Block Space Management
  • Types of Segments
  • Deferred Segment Creation
  • Space-Saving Features
  • Table and Row Compression
  • Shrinkable Segments
  • Resumable Space Allocation

Managing Undo Data

  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Comparing Local Undo Mode and Shared Undo Mode
  • Configuring Undo Rentention
  • Temporary Undo

Moving Data

  • Oracle Data Pump
  • SQL*Loader
  • External Tables
  • Migrating to Oracle Database Cloud Service

Backup and Recovery Concepts

  • Categories of Failure
  • Instance Recovery
  • Complete Recovery
  • Point-in-time Recovery
  • Flashback Technology

Backup and Recovery Configuration

  • Configuring and Monitoring the Fast Recovery Area
  • Multiplexing Control Files
  • Multiplexing Redo Log Files
  • Archive Redo Log Files
  • Configuring ARCHIVELOG Mode

Creating Database Backups

  • Backup Terminology
  • Using Recovery Manager (RMAN)
  • RMAN Backup Types
  • Automatic Backups on Database Cloud Service (DBCS)
  • On-Demand Backups on DBCS

Performing Database Recovery

  • Database Recovery Advisor
  • Recovering Data Files in NOARCHELOG Mode
  • Recovering Data Files in ARCHIVELOG Mode
  • Recovery Options in Database Cloud Service (DBCS)

Monitoring and Tuning Database Performance

  • Performance Planning Considerations
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Managing Metric Thresholds and Alerts
  • Monitoring Wait Events, Sessions, and Services
  • Performance Tuning Methodology
  • Managing Memory Components

SQL Tuning

  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best