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, a business may want to identify suspicious credit card behavior by selecting all 4-hour time periods in which a card member's dollars purchased exceeded a threshold. These types of temporal problems can be tricky to solve, but this session focuses on Teradata 13.10 SQL features which both simplify the SQL coding and perform well. Key features to be used include: 1) Temporal Constraints, 2) EXPAND ON clause, and 3) Period Table Functions. 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.

Note: This was a 2011 Teradata Partners Conference session.

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 Warehouse Analytical Modeler, Data Warehouse Application Specialist, Data Warehouse Architect/Designer

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