Watch this set of videos to learn about Oracle SQL Analytics!
Duration: 50 minutes
This content is intended for the following job role(s): Data Scientist, PL/SQL Developer, Data Warehouse Developer, Business Intelligence Developer, Business Analyst
Release Date: 12-DEC-2013
Created by: Keith Laker
This podcast is the first in a series of podcasts that will look at the core concepts behind Oracle’s in-database SQL analytics and examine, in detail, some of the key features and functions.
Duration: 8 minutes
In this podcast we review some of the key concepts around the way data sets are processed by SQL analytics
Duration: 2 minutes
In this podcast we continue our review some of the key concepts around the way data sets are processed by SQL analytics
Duration: 3 minutes
In this simple demo we explore how to calculate the average 90 day stock balance using SQL analytics.
Duration: 4 minutes
In this podcast we review some of the optimizations included in the database to support the SQL analytics
In an earlier podcast we introduced the concepts of windows in this podcast we are going to look a little deeper at how analytical windows work.
In this podcast we explore some examples of how to use SQL analytics to answer some typical business questions.
Duration: 10 minutes
In this podcast we review the extensions to the SQL GROUP BY clause, which allow developers and business users to add subtotals and grand-totals to their result sets. These can range from simple row/column subtotals to the creation of sophisticated hierarchical, multi-dimensional cubes.
Duration: 9 minutes