Oracle Database 18c: Administration Workshop

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database.

In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Objectives:

• Describe Oracle Database architecture
• Explain 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

Content

• Module 1: Introduction
• Sample HR Schema
• Oracle Cloud Overview
• Oracle Database Editions, Options, and Management Packs
• Module 2: Oracle Database Architecture
• Automatic Storage Management (ASM) Overview
• Oracle Database Instance Configurations
• Oracle Database Memory and Process Structures
• Connecting to the Database Instance
• Logical and Physical Database Structures
• Multitenant Architecture
• Oracle Database Server Architecture
• Module 3: Introduction to Oracle Database Cloud
• Automated Database Provisioning
• Oracle Database Cloud Service Architecture
• Features and Tooling
• Module 4: Creating Oracle Database Cloud Service (DBCS) Deployments
• SSH Key Pairs
• Database File Storage
• Input to the Creation Wizard
• Module 5: Accessing an Oracle Database
• Oracle Database Cloud Service Tools
• Database Configuration Assistant (DBCA)
• Oracle Enterprise Manager Cloud Control
• Oracle enterprise Manager Database Express
• SQL Developer
• SQL*Plus
• Module 6: Managing DBCS Database Deployments
• Managing Network Access to DBCS
• Managing the Compute Node
• Scaling a Database Deployment
• Patching a Database Deployment
• Module 7: Managing Database Instances
• Starting Up Oracle Database Instances
• Data Dictionary Views
• Shutting Down Oracle Database Instances
• Dynamic Performance Views
• Automatic Diagnostic Repository (ADR)
• Alert Log and Trace Files
• Initialization Parameter Files
• Module 8: Oracle Net Services
• Oracle Net Services Administration Tools
• Configuring Communication Between Database Instances
• Oracle Net Listener Overview
• Connecting to an Oracle Database Instance
• and more.

Prerequisites:

• A working knowledge of SQL and PL/SQL packages is very helpful in the course.
• Basic knowledge of Linux operating system