How To Use Oracle Analytic Functions
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.
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.
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.