Vertica 9.x Descriptive Analytics

The Vertica Descriptive Analytics course provides an overview of the standard SQL aggregate and analytic functions, as well as a comprehensive introduction to the Vertica-specific extensions to SQL.

Obsah školení

Upon successful completion of this course, you should be able to:

• Describe the difference between aggregate and analytic tasks
• Group data using aggregate functions
• Use the SQL OVER() clause to perform analytic functions
• Use the Vertica-specific SQL extensions to:
• Perform conditional analysis on data
• Interpolate the missing values in a data set
• Work with data in specified time slices
• Find patterns in your data