Create Oracle specific tables

Contents

• Introduction Introduction

  • Learning Oracle Database SQL: Why 19c?

    1m 7s
  • What you should know

    2m 1s
• 1. Client Tools 1. Client Tools

  • (Locked)
    SQL*Plus

    4m 3s
  • (Locked)
    SQLcl

    5m 14s
  • (Locked)
    SQL Developer

    5m
• 2. SELECT Statements 2. SELECT Statements

  • (Locked)
    Data types overview

    5m 21s
  • (Locked)
    SELECT statement clauses

    2m 53s
  • (Locked)
    Expressions in SELECT and WHERE clauses

    5m 18s
  • (Locked)
    Column aliases

    4m 9s
  • (Locked)
    Subqueries

    3m 55s
• 3. Data Dictionary 3. Data Dictionary

  • (Locked)
    Using DESCRIBE in SQL*Plus

    3m 2s
  • (Locked)
    Using the DDL command in SQLcl

    4m 8s
• 4. String Manipulation 4. String Manipulation

  • (Locked)
    Literals

    6m 53s
  • (Locked)
    Concatenation

    3m 38s
  • (Locked)
    Alternative quoting

    4m 15s
• 5. Filtering Rows 5. Filtering Rows

  • (Locked)
    WHERE clause syntax

    5m 36s
  • (Locked)
    Subqueries in the WHERE clause

    3m 19s
  • (Locked)
    How table joins work and filter rows in the result set

    5m 20s
• 6. Sorting Rows 6. Sorting Rows

  • (Locked)
    ORDER BY clauses

    4m 11s
  • (Locked)
    Collation rules

    4m 5s
• 7. Single-Row Functions 7. Single-Row Functions

  • (Locked)
    Numeric functions

    3m 12s
  • (Locked)
    Character functions returning character values

    5m 16s
  • (Locked)
    Character functions returning numeric values

    4m 53s
  • (Locked)
    Datetime functions

    5m 12s
  • (Locked)
    Conversion functions

    5m 26s
  • (Locked)
    General functions

    3m 48s
  • (Locked)
    Listing functions with SQL Developer

    2m 58s
• 8. Aggregation and Multiple-Row Functions 8. Aggregation and Multiple-Row Functions

  • (Locked)
    GROUP BY clause

    6m 6s
  • (Locked)
    HAVING clause

    1m 38s
  • (Locked)
    Using DISTINCT

    6m 42s
• 9. Joining Tables 9. Joining Tables

  • (Locked)
    ANSI joins versus Oracle join syntax

    3m 55s
  • (Locked)
    (INNER) JOIN

    3m 46s
  • (Locked)
    LEFT (OUTER) JOIN

    4m 41s
  • (Locked)
    RIGHT (OUTER) JOIN

    4m 38s
  • (Locked)
    FULL (OUTER) JOIN

    3m 21s
  • (Locked)
    NATURAL JOIN

    4m 35s
  • (Locked)
    CROSS JOIN

    3m
• 10. Using the Oracle Data Dictionary 10. Using the Oracle Data Dictionary

  • (Locked)
    Understanding the data dictionary

    5m 6s
  • (Locked)
    Querying the data dictionary

    5m 13s
• 11. DML: INSERT 11. DML: INSERT

  • (Locked)
    Inserting single rows

    4m 11s
  • (Locked)
    Inserting multiple rows

    7m 58s
  • (Locked)
    UPDATE table rows

    4m 18s
  • (Locked)
    DELETE rows with or without WHERE

    4m 45s
• 12. DDL: Creating Objects 12. DDL: Creating Objects

  • (Locked)
    Creating tables

    5m 21s
  • (Locked)
    Creating indexes

    5m 27s
  • (Locked)
    Create Oracle specific tables

    5m 35s
• 13. Dropping Objects 13. Dropping Objects

  • (Locked)
    Dropping tables

    4m 50s
  • (Locked)
    Dropping indexes

    3m 58s
  • (Locked)
    Drop Oracle specific tables

    1m 53s
• Conclusion Conclusion

  • (Locked)
    Next steps

    41s