SQL on Vertica

Topics:

• Vertica SQL Columnar Database

• Retrieve Data using the SQL SELECT Statement

• Learn to Restrict and Sort Data

• Usage of Functions to Customize Output

• Invoke Conversion Functions and Conditional Expressions

• Aggregate Data Using the Group Functions

• OLAP Functions

• Display Data From Multiple Tables Using Joins

• Use Sub-queries to Solve Queries

• Temp Tables

• Data Manipulation Statements

• Use of DDL Statements to Create and Manage Tables

• Schema Objects

• Manage Objects with Data Dictionary Views

• Manipulate Large Data Sets