EncartaLabs

Vertica Database Administration

( Duration: 4 Days )

The Vertica Database Administration training course provides database and system administrators information about, and practice in, maintaining an HPE Vertica cluster. In this course, delegates will learn to perform day-to-day database management tasks using an existing HPE Vertica cluster and HPE Vertica’s standard tools and interfaces.

By attending Vertica Database Administration workshop, Delegates will learn to:

  • Manage an HPE Vertica cluster
  • Perform day-to-day HPE Vertica database management tasks
  • Create and maintain database users
  • Collect and manage database performance metrics

  • HPE Vertica Essentials training course or equivalent experience
  • A working knowledge of SQL (e.g., understanding how to structure and interpret SELECT and CREATE statements)
  • Familiarity with database design concepts (e.g., understanding of database structures (schemas, tables, projections, constraints, etc.)
  • At least one year experience working in a Linux environment

  • Database administrators
  • System administrators

COURSE AGENDA

1

The Training Environment

  • Log in to the training environment
  • Review the training environment configuration
  • Log in to the Management Console
  • Start a database
2

Managing HPE Vertica Clusters

  • Import an existing cluster to the Management Console
  • View the database state in system tables
  • Shut down and restart a node in the Management Console
  • Review the cluster history in the Message Center
3

Loading Data

  • Load data into the database from a file
  • Identify and correct data parsing errors
  • Correct a projection for data skew
4

Monitoring Data

  • Monitor the ROS container count
  • Manually run the Tuple Mover tasks
  • Update the database statistics
5

Optimize the Database Design

  • Create a comprehensive database design using admintools
  • Review the Database Designer output files
  • Deploy the comprehensive database design
  • Create and deploy an incremental database design using Management Console
  • Review the database design logging tables
6

Epoch Management

  • Find and identify epochs using the SYSTEM table and database functions
  • Find the epoch in which data has been loaded
  • Use historical queries to find data loaded at different epochs
7

Database User Management

  • Create a new user password profile
  • Create new database users
  • Create new database user roles
  • Assign a role to a user
  • Create a role hierarchy
8

Table Access Privileges

  • Assign inheritable privileges to a database schema
  • Limit access to database columns by role
  • Restrict non-administrative access to system tables
9

Resource Management

  • Review the default resource pool
  • Create a new resource pool
  • Test the user access to the new resource pool
  • Analyze and correct a user resource issue
10

Database Backup and Recovery

  • Determine the required backup disk storage space
  • Back up the database
  • Review the database backups
  • Restore the database
11

Maintaining a Database and Cluster

  • Identify the HPE Vertica database version
  • Estimate the database size
  • Audit and update an HPE Vertica license
  • Add a host to a cluster
  • Add a node to a cluster
12

The Database Directory

  • Describe the contents of the database directory
  • View the vertica.log file in Management Console
  • Rotate the vertica.log file
13

System Maintenance

  • Determine the amount of system data saved in the Data Collector
  • Run the Workload Analyzer to find system tuning recommendations
  • Run the HPE Vertica performance tools to collect information for the Support organization
  • Run the HPE process scrutinize to collect information for the Support organization

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