Introduction to Oracle Database

Database Server Architecture

Accessing an Oracle Database

Accessing an Oracle Database

Usage of general Tools to Interact with Database

Creating an Oracle Database by Using DBCA

Creating a Database Using DBCA

Creating a New CDB

Creating a New CDB

Creating an Oracle Database by Using a SQL Command

Creating Database using SQL Command

Creating a New CDB

Starting Up and Shutting Down a Database Instance

Starting Up and Shutting Down a Database Instance

Opening and Closing PDBs

Shutting Down and Starting Up the Oracle Database

Managing Database Instances

Managing the Database

Investigating Initialization Parameter Files

Viewing Initialization Parameters by Using SQL*Plus (Part 01)

Viewing Initialization Parameters by Using SQL*Plus (Part 02)

Modifying Initialization Parameters by Using SQL*Plus

Viewing Diagnostic Information

Oracle Net Service: Overview

Configuring and Administering Oracle Net Service

Configuring Naming Methods

Oracle Net Components

Naming Method

Creating a Net Service Name for a PDB
Configuring and Administering the Listener

Configuring and Administering the Listener

Exploring the Default Listener

Creating a Second Listener

Connecting to a Database Service Using the New Listener

Configuring a Shared Server Architecture

Configuring a Shared Server Architecture

Configuring Shared Server Mode

Configuring Clients to Use a Shared Server

Configuring Oracle Connection Manager for Multiplexing and Access Control

Connection Manager

Installing Oracle Instant Client

Configuring the cman.ora File

Configuring the Database for Oracle Connection Manager

Configuring Clients for Oracle Connection Manager

Configuring the Oracle Database Server for Session Multiplexing

Creating PDBs from Seed

Creating PDBs from Seed

Provisioning New Pluggable Databases-(Continued)

Creating a New PDB from the PDB Seed

Using Other Techniques to Create PDBs

Using Other Techniques to Create PDBs

Method of Creating and Migrating PDBs

Cloning Remote PDBs in Hot Mode

Cloning Remote PDBs in Hot Mode (Part 02)

Relocating PDBs

Managing PDBs

Managing PDBs

Renaming a PDB

Setting Parameter Values for PDBs

Database Storage Overview

Database Storage Overview

Purpose of the Default Tablespaces

Storage of Data in Blocks

Advantage of Deferred Segment Creation

Creating and Managing Tablespaces

Creating and Managing Tablespaces

Viewing Tablespace Information

Viewing Tablespace Information

Creating a Tablespace

Managing Temporary and Permanent Tablespaces

Improving Space Usage

Space Management Features

Creating Global Temporary Tables

Managing Space in Tablespaces

Using Compression

Enabling the Resumable Space Allocation Feature New

Managing Undo Data

Managing the Undo

Enabling Temporary Undo

Managing Undo Tablespaces in a PDB

Creating and Managing User Accounts

Creating and Managing User Accounts

Creating Common Users in the CDB and PDBs

Assigning Quotas

Creating Common and Local Users

Creating a Local User for an Application

Exploring OS and Password File Authentication

Configuring Privilege and Roles Authorization

Configuring Privilege and Roles Authorization

Granting a Local Role (DBA) to PDBADMIN

Using SQL*Developer to Create Local Roles

Configuring User Resource Limits

Configuring User Resource Limits

Using SQL*Developer to Create a Local Profile

Using SQL*Developer to Create Local Users

Configuring a Default Role for a User

Implementing Oracle Database Auditing

Implementing Oracle Database Auditing

Configuring Auditing

Viewing Audit Policy Information

Enabling Unified Auditing

Creating Audit Users

Creating an Audit Policy

Introduction Loading and Transporting Data

Introduction Loading and Transporting Data

Loading Data

Loading Data

Loading Data into a PDB from an External File

Transporting Data

Transporting Data

Using the RMAN Convert Command

Moving Data from One PDB to Another PDB

Transporting a Tablespace
Using External Tables to Load and Transport Data

Using External Tables to load Transport Data

External Table Demo

Querying External Tables

Unloading External Tables

Automated Maintenance Tasks: Overview

Automated Maintenance Tasks: Overview

Automated Maintenance Tasks: Components

Automated Maintenance Tasks: Managing Tasks and Windows

Configuring Automated Maintenance Tasks

Enabling and Disabling Automated Maintenance Tasks

Modifying the Duration of a Maintenance Window

Database Backups

Manual Backups

RMAN Backups

Performing Different Types of backups

 

Database Recoveries

Manual Recoveries

RMAN Recoveries

Performing Different Types of Recoveries

Database Logical Backups and Recoveries using Datapump

Export operation

Import Operation

Performing Different Types of Export and Import operations

 

Database Monitoring and Performance Tuning Overview

Database Monitoring and Tuning Performance Overview

Monitoring Database Performance

Understanding What Database Performance is Monitored

Analyzing SQL and Optimizing Access Paths

Analyzing SQL and Optimizing Access Paths

Adaptive Execution Plans