Vertica 9.x Descriptive Analytics

Popis kurzu

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.

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.

Určeno pro

This course is intended for data analysts and business analysts.

Obsah kurzu

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

Předpoklady

To be successful in this course, you should have the following prerequisites or knowledge:

• A basic understanding of UNIX (finding and changing directories, listing directory contents, editing files, etc.)


• Intermediate understanding of SQL (creating tables, loading data, selecting specific data from a table, common column data types, SQL join functionality, etc.)

Studijní materiály