Oracle Database 19c: Administration Workshop

1: Introduction to Oracle Database

      Database Server Architecture

      Course Practice Environment: Security Credentials

2: Accessing an Oracle Database

       Accessing an Oracle Database

       Demonstration: Usage of general DBCA Tools to Interact with Database

3: Creating an Oracle Database by Using DBCA

         Creating a Database Using DBCA

4: Creating an Oracle Database by Using a SQL Command

           Creating Database using SQL Command

5: Starting Up and Shutting Down a Database Instance

          Starting Up and Shutting Down a Database Instance

          Opening and Closing PDBs

6: Managing Database Instances

         Managing the Database

7: Oracle Net Service: Overview

        Configuring and Administering Oracle Net Service

        Course Practice Environment: Security Credentials

8: Configuring Naming Methods

        Oracle Net Components

        Naming Method

9: Configuring and Administering the Listener

       Configuring and Administering the Listener

10: Configuring a Shared Server Architecture

       Configuring a Shared Server Architecture

       Configuring Shared Server Mode

       Configuring Clients to Use a Shared Server

11: Configuring Oracle Connection Manager for Multiplexing and Access Control

      Connection Manager

12: Creating PDBs from Seed

     Creating PDBs from Seed

     Provisioning New Pluggable Databases

13: Using Other Techniques to Create PDBs

     Using Other Techniques to Create PDBs

     Method of Creating and Migrating PDBs

14: Managing PDBs

     Managing PDBs

15: Database Storage Overview

    Database Storage Overview

    Purpose of the Default Tablespaces

    Storage of Data in Blocks

    Advantage of Deferred Segment Creation

16: Creating and Managing Tablespaces

    Creating and Managing Tablespaces

    Viewing Tablespace Information

17: Improving Space Usage

    Space Management Features

    Creating Global Temporary Tables

18: Managing Undo Data

    Managing the Undo

    Enabling Temporary Undo

19: Creating and Managing User Accounts

    Creating and Managing User Accounts

    Creating Common Users in the CDB and PDBs

    Assigning Quotas

20: Configuring Privilege and Roles Authorization

    Configuring Privilege and Roles Authorization

21: Configuring User Resource Limits

    Configuring User Resource Limits

22: Implementing Oracle Database Auditing

    Implementing Oracle Database Auditing

    Configuring Auditing

    Viewing Audit Policy Information

23: Introduction Loading and Transporting Data

     Introduction Loading and Transporting Data

    Course Practice Environment: Security Credentials

24: Loading Data

     Loading Data

25: Transporting Data

    Transporting Data

    Using the RMAN Convert Command

26: Using External Tables to Load and Transport Data

    Using External Tables to load Transport Data

27: Automated Maintenance Tasks: Overview

    Automated Maintenance Tasks: Overview

    Automated Maintenance Tasks: Components

    Course Practice Environment: Security Credentials

28: Automated Maintenance Tasks: Managing Tasks and Windows

    Configuring Automated Maintenance Tasks

29: Database Monitoring and Performance Tuning Overview

    Database Monitoring and Tuning Performance Overview

30: Monitoring Database Performance

     Understanding What Database Performance is Monitored

31: Tuning Database Performance

     Tuning Database Performance

32: Analyzing SQL and Optimizing Access Paths

     Analyzing SQL and Optimizing Access Paths

     Adaptive Execution Plans