HP Vertica SQL Training in Malta

HP Vertica is SQL database analytics platform used to efficiently manage and analyze large and rapidly accumulating amounts of structured and semi-structured data.

Accelerates Vertica Architecture and SQL training course teaches students the Vertica Architecture and SQL skills needed to use this powerful big data platform to its full potential.

The Building Blocks of Vertica: Learn about the physical architecure of a Vertica cluster, and the six foundation elements of Vertica that make it a unique and powerful platform. Installation and Setup:

• Installing Vertica and the Management Console: Learn how to unpack and install the Vertica Analytics platform and the Management Console tool.
• Creating a Database: Learn how to create a new database using both the admintools interface and the Management Console tool, and how to create a schema into a database using vsql.
• Loading Data: Learn how Vertica’s Hybrid Storage Architecture is used to speed the loading of data; how to monitor a data load in progress; and how to troubleshoot data loading issues. Vertica Storage Architecture.
• Introduction to Projections: Receive an overview of the Vertica storage architecture and how to create the key elements within that architecture to contain data.
• Query Execution: Learn how queries are managed by Vertica’s distributed database, using the least resource-intensive method to execute them quickly and efficiently. Vertica Analytics Functions .
• Introduction to Analytics: Learn how to structure an analytic query, and become acquainted with the advantages of analytic queries; understand the order in which analytic functions process database information.
• Event-Based Analytics: Event-based analytics functions are Vertica-proprietary extensions beyond the ANSI-99 supported analytics tools. Learn about the features, benefits, and usage of Vertica’s event-based analytics functions to evaluate data.
• Timeseries Analytics: When data with a timestamp is gathered, it often has gaps between events. Vertica provides analytic tools that allow you to interpolate values of missing data. Learn how Vertica interpolates the intervals and values for missing time series data. Vertica Workload Management .
• The Vertica Resource Manager: In order to most efficient process queries, Vertica assigns each query to a built-in resource pool. Learn about how query workloads are managed used the built-in pools, and the configuration parameters for each of these pools.
• User-Defined Resource Pools: Learn how to create a new resource pool, and how to assign the queries from specific users to a particular pool. We recommend you first take the Vertica Resource Manager web-based module.

Basics of SQL queries will help you.

1. Introduction 

Class Introductions

2. Architecture Overview 

Vertica Analytics Platform

Projections

query Execution

Transaction and Locking

Hybrid Data Store

3. Demo 

Installing Vertica

4. Lab 

Start and Connect to DB

Load Data

5. Projections and Database Designer 

Projection Fundamentals

Projection and Table Properties

Database design

Manual Projection Design

Projection Management

6. Lab 

Running DBD

Loading Data into Vertica via INSERT, COPY and MERGE

Post Loading Tasks

7. Removing Data 

Delete Purge

Partitioning

Tuple Mover Operations

8. Lab 

Removing Data

9. Logical Design and Security 

Schema

Table and Views

Constraints

User

Roles

External Procedures

10. Lab 

Roles and Priviledges

11. Cluster and High Availability 

Management Console

Node Management

Disk Management

Fault Group

12. Backup and Restores 

Backup and Restore

Copy Vertica Database

13. Resource Management 

Resource Manager

Resource Pools

Resource Pool Parameters

User Defined Resource pools

Monitoring Resource Pools

14. Lab 

Resource Management

15. Monitoring and Troubleshooting Vertica 

Monitoring Server and Network

Monitoring Vertica

Troubleshooting Vertica

16. Vertica Cluster Expansion 

Adding nodes

Deleting nodes

Rebalance data

17. Understanding Query Plans 

Explain Plan

Profiling database performance

18. Profiling Database Performance 

Real time query profiling and analyzing Executions Engine Profile

19. Cluster Upgrade 

Lab

20. Audience Questionnaire 

Audience Questionnaire