nobody Have a Question? Help Login
  • Home
  • Content Details

SQL Analytics Overview Video Series


1 user(s) recommend this content
  • Watch this set of videos to learn about Oracle SQL Analytics!

    • This content is intended for the following job role(s): Data Scientist , Business Analyst , PL/SQL Developer , Business Intelligence Developer , Data Warehouse Developer
  • 12-DEC-13 12.00.00.000000 AM
  • 50 minutes
  • Keith Laker

Content List (click links below to view content)

12-DEC-2013 8 mins

SQL Analytics - Overview

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.

12-DEC-2013 2 mins

SQL Analytics - Part 1.1 Key Concepts

In this podcast we review some of the key concepts around the way data sets are processed by SQL analytics

12-DEC-2013 3 mins

SQL Analytics - Part 1.2 Key Concepts (continued)

In this podcast we continue our review some of the key concepts around the way data sets are processed by SQL analytics

12-DEC-2013 4 mins

SQL Analytics - Part 1.3 Key Concepts Demo

In this simple demo we explore how to calculate the average 90 day stock balance using SQL analytics.

12-DEC-2013 3 mins

SQL Analytics - Part 1.4 Optimizations

In this podcast we review some of the optimizations included in the database to support the SQL analytics

12-DEC-2013 8 mins

SQL Analytics - Part 1.5 Analytical Windows

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.

12-DEC-2013 10 mins

SQL Analytics - Part 1.6 SQL for Reporting Examples

In this podcast we explore some examples of how to use SQL analytics to answer some typical business questions.

12-DEC-2013 9 mins

SQL Analytics - Part 2 Aggregations

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.

Please Log In to Bookmark this Video

Bookmarked 3 times

 
1 user(s) recommend this content

Hide/Show Reviews

Hide/Show Additional Resources

Information about Related Products