Walkthrough: Cloning a pluggable database - Oracle Database Tutorial

Contents

• Introduction Introduction

  • Oracle 23ai: Future-proof your tech journey

    52s
  • (Locked)
    An update about Oracle 23ai

    35s
  • (Locked)
    What you should know

    2m 10s
  • (Locked)
    Getting set up for the final project

    2m 18s
• 1. Why Oracle? 1. Why Oracle?

  • Why Oracle?

    3m 59s
  • New in Oracle 23ai

    3m 3s
  • (Locked)
    New data types

    4m 41s
  • (Locked)
    Miscellaneous new features

    2m 10s
• 2. Oracle Basics: Schema Objects 2. Oracle Basics: Schema Objects

  • Schema objects: All about tables

    2m 43s
  • (Locked)
    Indexing in Oracle 23ai

    4m 4s
  • (Locked)
    Views, object views, JSON views, and materialized views

    2m 50s
  • (Locked)
    Segment partitioning

    2m 18s
  • (Locked)
    The data dictionary and dynamic performance views

    3m 20s
  • (Locked)
    Final project countdown: Schema objects recap

    40s
• 3. Oracle Basics: Transactions 3. Oracle Basics: Transactions

  • What is ACID?

    2m 7s
  • (Locked)
    Data concurrency

    2m 59s
  • (Locked)
    Data consistency

    3m 57s
  • (Locked)
    Data integrity

    3m 12s
  • (Locked)
    SQL language

    3m 17s
  • (Locked)
    PL/SQL

    4m 28s
  • (Locked)
    Interacting with the database

    6m 30s
  • (Locked)
    Final project countdown: Transactions recap

    31s
• 4. Oracle Architecture 4. Oracle Architecture

  • Oracle physical architecture

    5m 11s
  • (Locked)
    Oracle logical architecture

    6m 2s
  • (Locked)
    Database configuration and logging

    7m 57s
  • (Locked)
    Oracle memory and processes

    10m 24s
  • (Locked)
    Final project countdown: architecture recap

    32s
• 5. Instance vs. Container Database (CDB) 5. Instance vs. Container Database (CDB)

  • What is an Oracle instance?

    4m 8s
  • (Locked)
    Container database (CDB)

    2m 40s
  • (Locked)
    Pluggable databases (PDBs)

    3m 6s
  • (Locked)
    Oracle Real Application Clusters (RAC)

    4m 21s
  • (Locked)
    Oracle Data Guard

    3m 24s
  • (Locked)
    Sharding architecture

    4m 35s
  • (Locked)
    Oracle Net Services and application architecture

    4m 19s
  • (Locked)
    Final project countdown: Instance vs. container database recap

    38s
• 6. Database Administration 6. Database Administration

  • Role of a database administrator

    4m 28s
  • (Locked)
    Overview of maximum availability architecture

    3m 32s
  • (Locked)
    Understanding Oracle high availability

    4m 21s
  • (Locked)
    Disaster recovery options

    5m
  • (Locked)
    Backing up and recovering using RMAN

    3m 46s
  • (Locked)
    Final project countdown: Database administration recap

    30s
• 7. Security 7. Security

  • Security basics

    2m 29s
  • (Locked)
    Authentication

    3m 19s
  • (Locked)
    Authorization

    3m 16s
  • (Locked)
    Account management

    4m 31s
  • (Locked)
    Auditing

    3m 10s
  • (Locked)
    Data governance in Oracle

    3m 13s
  • (Locked)
    New security features with 23ai

    2m 46s
  • (Locked)
    Final project countdown: Security recap

    27s
• 8. Advanced Security 8. Advanced Security

  • Reversible and irreversible data protection

    2m 20s
  • (Locked)
    Data obfuscation

    2m 57s
  • (Locked)
    Data masking

    3m
  • (Locked)
    Transparent Data Encryption (TDE)

    3m 35s
  • (Locked)
    Network encryption

    3m 49s
  • (Locked)
    Database Firewall

    2m 56s
  • (Locked)
    Final project countdown: Advanced security recap

    28s
• 9. Optimizing Performance 9. Optimizing Performance

  • Introduction to performance optimization

    2m 35s
  • (Locked)
    Instance tuning

    5m 10s
  • (Locked)
    Understanding the AWR report

    4m 9s
  • (Locked)
    ASH, ADDM, and the rest of AWR

    3m 46s
  • (Locked)
    SQL tuning

    5m 49s
  • (Locked)
    SQL tracing

    3m 16s
  • (Locked)
    Cost-based optimizer

    5m 5s
  • (Locked)
    Performing an optimization exercise

    4m 26s
  • (Locked)
    Final project countdown: Optimizing performance recap

    36s
• 10. Oracle 23ai Final Project: Getting Prepared 10. Oracle 23ai Final Project: Getting Prepared

  • (Locked)
    Final project introduction and prerequisites

    9m 27s
  • (Locked)
    Assignment: Navigating the database hierarchy

    1m 46s
  • (Locked)
    Walkthrough: Navigating the database hierarchy

    8m 55s
• 11. Oracle 23ai Final Project: Admin Tasks 11. Oracle 23ai Final Project: Admin Tasks

  • (Locked)
    Assignment: Starting and stopping databases

    55s
  • (Locked)
    Walkthrough: Starting and stopping databases

    4m 50s
  • (Locked)
    Assignment: Configuring and managing space

    1m 8s
  • (Locked)
    Walkthrough: Configuring and managing space

    4m 23s
  • (Locked)
    Assignment: User management

    1m 28s
  • (Locked)
    Walkthrough: User management

    6m 6s
• 12. Oracle 23ai Final Project: Cloning a Database 12. Oracle 23ai Final Project: Cloning a Database

  • (Locked)
    Assignment: Cloning a pluggable database

    1m 4s
  • (Locked)
    Walkthrough: Cloning a pluggable database

    5m 6s
• 13. Oracle 23ai Final Project: Archiving for Point-in-Time Recovery 13. Oracle 23ai Final Project: Archiving for Point-in-Time Recovery

  • (Locked)
    Assignment: Turning on archiving for point-in-time recovery

    2m 44s
  • (Locked)
    Walkthrough: Turning on archiving for point-in-time recovery

    8m 28s
• 14. Oracle 23ai Final Project: Working with Data 14. Oracle 23ai Final Project: Working with Data

  • (Locked)
    Assignment: Create a sales summary schema owner user

    1m 15s
  • (Locked)
    Walkthrough: Create a sales summary schema owner user

    6m 56s
  • (Locked)
    Assignment: Create reporting data

    2m 13s
  • (Locked)
    Walkthrough: Create reporting data

    8m 53s
  • (Locked)
    Assignment: Manipulate data

    2m 58s
  • (Locked)
    Walkthrough: Manipulate data

    10m 32s
• 15. Oracle 23ai Final Project: Managing the Optimizer 15. Oracle 23ai Final Project: Managing the Optimizer

  • (Locked)
    Assignment: Create an explain plan

    1m 29s
  • (Locked)
    Walkthrough: Create an explain plan

    6m 57s
• Conclusion Conclusion

  • (Locked)
    Further learning with Oracle 23ai

    58s