SkillBuilders Welcome  |  Log in
All Oracle Tutorials

How To Use Oracle Analytic Functions

Oracle Consultants Available

This tutorial will show you how to use Oracle's Analytic Function extensions to SQL to produce efficient solutions to complex analysis of data.

SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena.

These questions can be easily answered via SQL statements that incorporate Analytic Functions. 

Dec 4 - SkillBuilders Oracle 11g PL/SQL Programming Workshop

Date: Apr 27, 2011

View video now - Free Online Registration required

Advanced SQL Queries for Oracle10g and 11g Databases:
21-Hour Online Class and Hands-On Workshop