This presentation demystifies usage of  OLAP Analytics function for TD 15.0 and previous releases.

It explains how to use all OLAP keywords, such as OVER, PARTITION BY, ORDER BY, ROWS UNBOUNDED, FOLLOWING, PRECEDING, CURRENT ROW and RESET WHEN. The material includes simple academic examples for clarity and real life SQL to understand how to apply OLAP in day to day situations.

Key Points:

  • Demystifies OLAP syntax
  • Understand how OLAP can answer business questions
  • Day to Day coding solution
  • Write better SQL

Note: This is a TD 15.0 updated presentation - updated 2016

Patrice Berube, Solution Architect - Teradata Corporation
Jeff Ohlman, Solution Architect - Teradata Corporation
This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Audience: Data Warehouse Technical Specialist, Database Administrator, Data Warehouse Analytical Modeler, Data Warehouse Application Specialist

Course number:40140
Training URL:
Format:Recorded webcast
Credit hours:1.00