|All Oracle Classes||
Learn How To Use Oracle Analytic Functions
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 a new class of SQL statements called Analytic Functions. This presentation 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.
Oracle 11g Training
Instructor-led and Hands-On.
Learn more about SkillBuilders Oracle training.