Data Warehouses are known for storing data over time, both historical point-in-time transactions as well as temporal data that is valid over a range of time...

Storing this data is one thing, but retrieving it to answer critical business questions can be a Structured Query Language (SQL) challenge. For example, an insurance company may want to determine exactly how many active policies a customer has had over periods of time, and whether there were periods in which the customer had no active policies.  These types of temporal problems can be tricky to solve, but this session focuses on Teradata 14.10 SQL features which both simplify the SQL coding and perform well.  Key features to be used include 1) the NORMALIZE clause and 2) sequenced aggregation.  The business problems in this session span industries, so you are bound to see problems that apply to your organization and how to solve them.

Presenter: Darrin Gaines, Senior Consultant – 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 Analyst, Application Developer, Architect/Designer

Course number:51028
Training URL:
Format:Recorded webcast
Credit hours:1.50