Oracle SQL Advanced Training Course

Overview

Listeners

This course is designed for people who want to use the advanced features of SQL in Oracle

The course answers the questions

  • How to build advanced queries?
  • How to create advanced reports?

Course Outline

Control user access

  • User Management
  • System permissions and object
  • Granting
  • Receiving permission
  • Roles
  • Using the links

Managing schema objects

  • ALTER TABLE command
  • Adding, modifying, and deleting columns
  • Add, remove, turn off constraint√≥w
  • Create indexes
  • Flashback operations
  • External tables

Operations on large data sets

  • MERGE command
  • DML operations of podzapytaniami
  • DML operations with RETURNING clause
  • INSERT command multi tables

Conditional expressions

  • CASE expression
  • DECODE expression

Generate reports by grouping related data

  • The GROUP BY clause
  • The HAVING clause
  • Aggregating data – ROLLUP and CUBE operators
  • Identification summaries – GROUPING function
  • Aggregating data – GROUPING SETS operator

Managing data in different time zones

  • Time zones
  • Variations TIMESTAMP
  • Differences between DATE and TIMESTAMP
  • Conversion operations

Advanced subqueries

  • Subqueries
  • Multi-column subqueries
  • The subquery in the FROM clause
  • Correlated subqueries
  • WITH clause – re-use query blocks

Join tables

  • Inequality in the WHERE clause and the FROM clause
  • Semijoin
  • Antijoin

The processing of hierarchical data

  • The tree structure
  • hierarchical Queries
  • Pseudo column
  • Sort data in a hierarchical query
  • Useful functions

Regular expressions

  • Simple and complex patterns

Leave a Reply

Your email address will not be published. Required fields are marked *