Vertica EssentialsVERTEMFOpenTextMF-VERTE23.3<p>On completion of this course, participants should be able to:</p>
<ul>
<li>Describe Vertica&rsquo;s database and data storage structures</li><li>Load and remove data from a Vertica database</li><li>Optimize the database to improve query performance</li><li>Create and manage database users</li><li>Back up and restore a Vertica database</li></ul><p>To be successful in this course, you should have the following prerequisites or knowledge:</p>
<ul>
<li>Knowledge of RDBMS concepts (understanding databases and schemas, database normalization, etc.)</li><li>Familiarity with basic SQL syntax, ability to troubleshoot syntax errors, etc.</li><li>Experience with the Linux operating system (how to change directories, list directory contents, view and edit files, etc.)</li></ul><p>Database Administrators</p><ul>
<li>Module 1: Introduction to the Training Environment</li><li>Module 2: Vertica Overview</li><li>Module 3: Introduction to Projections</li><li>Module 4: Loading Data</li><li>Module 5: Query Execution</li><li>Module 6: Optimizing Database Design</li><li>Module 7: Removing Data</li><li>Module 8: Database User Management</li><li>Module 9: Table Access Privileges</li><li>Module 10: Database Backup and Restore</li></ul><h5>Module 1: Introduction to the Training Environment</h5><ul>
<li>Log in to the training environment</li><li>Review the training environment configuration</li><li>Introduction to Management Console</li><li>Using the valab utility</li></ul><h5>Module 2: Vertica Overview</h5><ul>
<li>Describe the building blocks of the Vertica platform</li></ul><h5>Module 3: Introduction to Projections</h5><ul>
<li>Identify basic projection types</li><li>Read a projection DDL to determine its structure</li><li>Describe the benefits of projections</li></ul><h5>Module 4: Loading Data</h5><ul>
<li>Review the structure of tables and projections</li><li>Load data using the COPY command</li><li>Manually run the Tuple Mover mergeout task</li><li>Monitor data loads using Management Console and vsql</li></ul><h5>Module 5: Query Execution</h5><ul>
<li>Generate a query plan</li><li>Time a query</li><li>Profile a query</li><li>Identify the database epochs</li></ul><h5>Module 6: Optimizing Database Design</h5><ul>
<li>Create a comprehensive database design using Management Console</li></ul><h5>Module 7: Removing Data</h5><ul>
<li>Remove data by dropping and truncating tables</li><li>Bulk delete data from tables</li><li>Purge delete vectors</li></ul><h5>Module 8: Database User Management</h5><ul>
<li>Create new database users</li><li>Create new database user roles</li><li>Assign a role to a user</li><li>Create a role hierarchy</li></ul><h5>Module 9: Table Access Privileges</h5><ul>
<li>Assign inheritable privileges to a database schema</li><li>Limit access to database columns and rows by role</li><li>Restrict non-administrator access to system tables</li></ul><h5>Module 10: Database Backup and Restore</h5><ul>
<li>Create a backup configuration file</li><li>Back up and restore the database</li><li>Monitor database backups</li><li>Replicating objects</li><li>Duplicating a cluster</li></ul>On completion of this course, participants should be able to:
- Describe Vertica’s database and data storage structures
- Load and remove data from a Vertica database
- Optimize the database to improve query performance
- Create and manage database users
- Back up and restore a Vertica databaseTo be successful in this course, you should have the following prerequisites or knowledge:
- Knowledge of RDBMS concepts (understanding databases and schemas, database normalization, etc.)
- Familiarity with basic SQL syntax, ability to troubleshoot syntax errors, etc.
- Experience with the Linux operating system (how to change directories, list directory contents, view and edit files, etc.)Database Administrators- Module 1: Introduction to the Training Environment
- Module 2: Vertica Overview
- Module 3: Introduction to Projections
- Module 4: Loading Data
- Module 5: Query Execution
- Module 6: Optimizing Database Design
- Module 7: Removing Data
- Module 8: Database User Management
- Module 9: Table Access Privileges
- Module 10: Database Backup and RestoreModule 1: Introduction to the Training Environment
- Log in to the training environment
- Review the training environment configuration
- Introduction to Management Console
- Using the valab utility
Module 2: Vertica Overview
- Describe the building blocks of the Vertica platform
Module 3: Introduction to Projections
- Identify basic projection types
- Read a projection DDL to determine its structure
- Describe the benefits of projections
Module 4: Loading Data
- Review the structure of tables and projections
- Load data using the COPY command
- Manually run the Tuple Mover mergeout task
- Monitor data loads using Management Console and vsql
Module 5: Query Execution
- Generate a query plan
- Time a query
- Profile a query
- Identify the database epochs
Module 6: Optimizing Database Design
- Create a comprehensive database design using Management Console
Module 7: Removing Data
- Remove data by dropping and truncating tables
- Bulk delete data from tables
- Purge delete vectors
Module 8: Database User Management
- Create new database users
- Create new database user roles
- Assign a role to a user
- Create a role hierarchy
Module 9: Table Access Privileges
- Assign inheritable privileges to a database schema
- Limit access to database columns and rows by role
- Restrict non-administrator access to system tables
Module 10: Database Backup and Restore
- Create a backup configuration file
- Back up and restore the database
- Monitor database backups
- Replicating objects
- Duplicating a cluster3 days2400.00