Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Vertica Advanced Analytics

( Duration: 2 Days )

The Vertica Advanced Analytics training course provides you with an in-depth introduction and hands-on experience with Vertica Analytics tools and concepts. The course provides a comprehensive understanding of general c analytic functions (including SQL analytics, as well as a comprehensive introduction to the Vertica-interpolation, event series joins, and pattern matching).

Attend a training on Vertica Essentials or equivalent experience with the Vertica Analytics platform and Intermediate knowledge of SQL.

This Vertica Advanced Analytics class is suitable for Data Analysts, Business Analysts, Application Developers, and Database Administrators.

COURSE AGENDA

1

Introductions

  • Class Introductions
2

Introduction to SQL Analytics

  • Analytic Basics, The Analytic OVER Clause, Named Windows, Minimizing Sort Operations
3

Event Based Windows

  • Event Based Windows, Use Cases, Sessionization
4

Place

  • Place Basics, Geospacial Basics, Place Functions, Spatial Joins
5

Pulse

  • Pulse Basics, Sentiment Analysis Function, Pulse Dictionaries
6

Time Series

  • Time Series, Time Slice, Interpolation, Gap Filling, Treatment of Nulls
7

Event Series Joins

  • Event Series Joins, INTERPOLATE keyword
8

Pattern Matching

  • Pattern Matching, Funnel Analysis, Pattern

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X