Oracle SQL Analytics

Duration: 
1 days
Codes: 
SQL

Overview

This course is highly interactive and consists of theory coupled with plenty of practical sessions. It will introduce delegates to the use of analytic, hierarchical and modelling functions within an Oracle database.

Together with Oracle SQL, this course provides the perfect prerequisite knowledge to embark on training for Oracle PL/SQL Programming, or administrative roles such as Oracle Database Administration.

On completion of the course delegates will be able to:

  • Use the Oracle SQL analytic summary functions
  • Use Oracle SQL to create and analyse dynamic hierarchical data structures
  • Use the set of Oracle SQL MODEL functions to produce spreadsheet-like reports and analyses

Audience

This course is aimed at those already experienced with SQL for data retrieval. It covers a range of the more advanced Oracle SQL functions required for extensive analysis and reporting.

This course is suitable for all recent versions of Oracle, up to and including 12c.

Prerequisites

Delegates should have a good basic understanding of Oracle SQL. Previous attendance of our Oracle SQL course is highly recommended.

Course Outline

  • Analytic Functions
  • Analytic summary functions
  • Analytic non-summary functions
  • Use of the OVER clause
  • Use of PARTITION clause with the OVER clause
  • Use of WINDOW clause with the OVER clause
  • Hierarchical Queries
  • CONNECT BY, PRIOR and START WITH
  • LEVEL pseudo column
  • ORDER SIBLINGS BY PRIOR
  • CONNECT BY PATH, ROOT, LOOP, ISCYCLE, ISLEAF
  • Model Function Components
  • Measures
  • Dimensions
  • Partitions
  • Rules
  • CV function
  • Reference models
  • Iterative models
  • Ordered rules

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Somerset Bath1 400 £400 2019-11-07