EncartaLabs

Vertica Essentials

( Duration: 3 Days )

The Vertica Essentials training course explores the capabilities of the HPE Vertica platform solution, and prepares delegates to manage the operational success of deployment.

By attending Vertica Essentials workshop, Delegates will learn to:

  • Describe HPE Vertica’s database and data storage structures
  • Load and remove data from an HPE Vertica database
  • Optimize the database to improve query performance
  • Create and manage database users and resources
  • Backup and restore an HPE Vertica database
  • Find additional information and resources for working with HPE Vertica

  • Intermediate knowledge of RDBMS concepts (understanding databases and schemas, database normalization, etc.)
  • Basic understanding of SQL (familiarity with basic SQL syntax, ability to troubleshoot syntax errors, etc.)
  • Basic experience with the Linux operating system (how to change directories and list the contents, how to view and edit files, etc.)

  • Database Administrators
  • Database Architects
  • Data Analysts
  • Application Developers

COURSE AGENDA

1

HPE Vertica Overview

  • Understand the building blocks of the HPE Vertica platform
2

Introduction to Projections

  • Read a projection DDL to determine its structure
  • Identify replicated and segmented projections
  • Use the database K-safety value to identify independent nodes
3

Loading Data

  • Review the structure of tables and projections
  • Load data using HPE Vertica’s hybrid storage model
  • Manually run the moveout and mergeout tasks
4

Query Execution

  • Generate a query plan
  • Time a query
  • Profile a query
  • Identify the database epochs
  • Find data loaded at different epochs
5

Optimizing the Database

  • Create a comprehensive database design using Management Console
  • Review the Database Designer output files
  • Deploy the comprehensive database design
6

Partitioning Data

  • Create partitioned tables
  • Load data into partitions
  • Move partitioned data into archived tables
7

Deleting Data

  • Remove data by dropping and truncating tables
  • Bulk delete data from tables
  • Purge delete vectors
  • Remove data by dropping partitions
8

Database User Management

  • Create new database users
  • Create new database user roles
  • Assign a role to a user
  • Create a role hierarchy
9

Resource Management

  • Review the default resource pools
  • Create a new resource pool
  • Test the user access to the new resource pool
10

Database Backup and Recovery

  • Create a backup configuration file
  • Back up the database
  • Review the database backups
  • Restore the database

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules 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 http://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