SkillBuilders Welcome  |  Log in
All Oracle Tutorials

How To Use Oracle Analytic Functions

Oracle Consultants Available

What are Oracle analytic functions? How and why do you use them? Learn this and more in this free vdeo tutorial from SkillBuilders.

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 Business Intelligence questions that standard aggregate functions cannot answer at all or would require very complex and inefficient SQL statements. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex BI queries such as Top-N within a group and aggregates over a range also fall in this arena.

These questions can be easily answered Oracle Analytic Functions. This tutorial will show you how to use Oracle's Analytic Function extensions to SQL to answer these questions simply and efficiently.

Want to learn more Oracle? Check out our scheduled Oracle classes!

Audience: Anyone familiar with an Oracle database.

Language: English

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

Date: Jun 17, 2010

This video experiences some intermittent audio quality issues....
But stick with it, there's a lot of great information!
Thank you from the SkillBuilders team.

View video now - Free Online Registration required

Oracle 12c Training

Instructor-led / Hands-On. Online or On-Site.

12c Class Calendar