This course is designed for senior programmers who will
write queries using the advanced features of SQL. It covers
advanced syntax and techniques used to retrieve and
manipulate data using both actual ISO Standard SQL
conventions and Teradata extensions. This class includes
both lecture and hands-on labs. Topics include: Windows
aggregate (OLAP) functions, advanced rankings & samples,
correlated sub-queries, derived tables, extended grouping
functions, temporary tables, recursive queries