Course curriculum

  • 1

    Introduction

  • 2

    Creating Oracle Database 23ai

    • Creating Oracle Database 23ai
  • 3

    Preparing Course Environment

    • Preparing Course Environment
  • 4

    Database Administration New Features

    • Shrinking Tablespaces

    • Practice-Shrinking Tablespaces

    • Hybrid Read-Only Mode for PDBs

    • Practice-Hybrid Read-Only Mode for PDBs

    • Simplified Data Transport Using RMAN Backups
  • 5

    New Objects and Options

  • 6

    SQL and Development Improvements

    • Wide Tables

    • Practice-Wide Tables

    • SQL BOOLEAN Data Type

    • IF EXISTS Syntax Support

    • Automatic Transaction Rollback

    • Practice-Automatic Transaction Rollback

    • DML RETURNING Clause

    • Time and Date Handling Changes

    • Practice: Using SYSDATE and SYSTIMESTAMP with DB Time Zone

    • Practice-Aggregation over INTERVAL Data Types

    • Direct Joins for UPDATE and DELETE Statements

    • Practice-Restrictions Lifted After Direct Load

    • Table Value Constructors

    • Practice-Table Value Constructors

    • Practice-DEFAULT ON NULL for UPDATE INSERT Statements

    • Unrestricted Parallel DMLs

    • Restrictions Lifted After Direct Load

    • Using Schema Annotations

    • Practice-Using Schema Annotations
  • 7

    Database Security

    • Schema Privileges

    • Practice-Schema Privileges

    • SQL Firewall

    • Practice-Using SQL Firewall
  • 8

    New Technologies

    • Introduction to True Cache

    • AI Vector Search

    • Practice-AI Vector Search
  • 9

    Miscellaneous New Features

    • Miscellaneous New Features