Data Warehouses often contain data in effect for a time period, denoted by Start and End dates within a row. With time-period data comes a set of frequently asked business questions. For example, of home, auto, and life insurance policies, for what ranges of time have my customers 1) had zero policies active, or 2) at least one active, or 3) multiple active? Solutions to business questions of this type are not obvious using SQL. However, this session will show how to solve this class of problems efficiently with SQL instead of using stored procedures or exporting to another tool. See unique ways to apply correlated subqueries and the Ordered Analytical Functions SUM(), ROW_NUMBER(), and MIN() to this class of problems.

Key Points

  • SQL solutions for time-period/date-range business problems
  • Using SQL Ordered Analytical functions as an alternative to stored procedures
  • Creative SQL techniques

Note: This is a 2007 Partners Conference presentation.

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

Course number 40143
Training URL http://www.teradata.com/t/ten/
Format Recorded webcast
Price $195.00
Credit hours 1.00