Cloud Database - Oracle Database Tutorial

Contents

• Introduction Introduction

  • Learn Oracle Database: Why 19c?

    56s
  • What you should know

    1m 5s
• 1. Oracle Database Architecture 1. Oracle Database Architecture

  • (Locked)
    Memory, storage, and processes

    4m 47s
  • (Locked)
    Startup and shutdown

    3m 54s
  • Dynamic performance views (V$)

    2m 14s
• 2. Database Setup on Linux 2. Database Setup on Linux

  • (Locked)
    Prepare the OS for installation

    6m 23s
  • (Locked)
    Run the Oracle 19c installer (Grid Infrastructure)

    5m 2s
  • (Locked)
    Run the Oracle 19c installer (Database)

    5m 59s
  • (Locked)
    RPM Install

    3m 22s
• 3. Database Navigation 3. Database Navigation

  • (Locked)
    SQLcl command-line tool

    3m 57s
  • (Locked)
    SQL Developer GUI

    3m 56s
  • (Locked)
    Database Express

    3m 54s
  • (Locked)
    Cloud Database

    4m 10s
• 4. The Oracle SQL Language 4. The Oracle SQL Language

  • (Locked)
    The ANSI SQL language standard

    2m 46s
  • (Locked)
    PL/SQL

    3m 23s
• 5. SELECT Statements 5. SELECT Statements

  • (Locked)
    SELECT statements: Capabilities and columns

    3m 26s
  • (Locked)
    Use the WHERE clause

    4m 5s
  • (Locked)
    SELECT statement transformations

    5m 27s
  • (Locked)
    What are NULL values?

    3m 34s
  • (Locked)
    How to use NULL values

    3m 41s
• 6. DML Statements 6. DML Statements

  • (Locked)
    Add rows to a table

    3m 43s
  • (Locked)
    Delete rows from a table

    3m 15s
  • (Locked)
    Update rows in a table

    4m 56s
• 7. DDL Statements 7. DDL Statements

  • (Locked)
    Create a table

    5m 56s
  • (Locked)
    Drop a table

    5m 4s
  • (Locked)
    Add or remove columns

    4m 30s
• 8. Managing Tablespaces 8. Managing Tablespaces

  • (Locked)
    Create a tablespace

    7m 1s
  • (Locked)
    Assign tablespaces to users

    3m 22s
  • (Locked)
    Drop tablespaces

    3m 17s
• 9. Security 9. Security

  • (Locked)
    Create a user account

    4m 34s
  • (Locked)
    Drop a user account

    2m 19s
  • (Locked)
    Lock a user account

    2m 59s
• Conclusion Conclusion

  • Next steps

    36s