Oracle SQL Training covers the following topics:

Oracle Architectural Components

  • Relational databases - introduction
  • Relational operators
  • SQL Syntax
  • DML, DDL, DCL, DQL language description
  • SELECT query definition
    • tables, column aliases, etc.
    • date format in queries - functions, formatting,
    • selecting data from multiple tables,
    • clustering,
    • nesting sub-queries,
    • combining tables,
    • UNION operator.
  • DML language (Data Modification Language)
    • INSERT - insert rows (directly and by request,
    • UPDATE - modify the contents of rows,
    • DELETE - delete rows.
  • DDL language - (Data Definition Language)
    • CREATE - creating objects,
    • ALTER - changing objects properties,
    • DROP - delete tables,
    • CREATE TABLE ... AS SELECT ... - creation of tables by a query.
  • Integrity bonds (constraints)
    • NULL and NOT NULL options,
    • CONSTRAINT clause, DEFAULT,
    • PRIMARY KEY, UNIQUE, FOREIGN KEY condition.
  • The definition of transaction
    • COMMIT,
    • ROLLBACK,
    • SAVEPOINT.
  • DCL language (Data Control Language)
    • GRANT giving authorization,
    • REVOKE getting back authorization,
    • roles,
    • creating users,
    • sequences,
    • synonyms,
    • views (perspectives).