{"course":{"productid":34937,"modality":6,"active":true,"language":"en","title":"Vertica Essentials","productcode":"VERTE","vendorcode":"MF","vendorname":"OpenText","fullproductcode":"MF-VERTE","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/opentext-verte","objective":"<p>On completion of this course, participants should be able to:<\/p>\n<ul>\n<li>Describe Vertica&amp;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>","essentials":"<p>To be successful in this course, you should have the following prerequisites or knowledge:<\/p>\n<ul>\n<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>","audience":"<p>Database Administrators<\/p>","contents":"<ul>\n<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>","outline":"<h5>Module 1: Introduction to the Training Environment<\/h5><ul>\n<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>\n<li>Describe the building blocks of the Vertica platform<\/li><\/ul><h5>Module 3: Introduction to Projections<\/h5><ul>\n<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>\n<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>\n<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>\n<li>Create a comprehensive database design using Management Console<\/li><\/ul><h5>Module 7: Removing Data<\/h5><ul>\n<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>\n<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>\n<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>\n<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>","summary":"<p>The Vertica Essentials course covers the architecture and capabilities of Vertica Analytics in Enterprise mode. This course is a prerequisite to all advanced courses and will prepare you for the operational success of your deployment.<\/p>\n<p>Highlights:<\/p>\n<ul>\n<li>Describe the Vertica data architecture<\/li><li>Manage data within a Vertica database, including loading and removing data<\/li><li>Describe how SQL queries are executed<\/li><li>Modify the database structure for optimal query execution<\/li><li>Manage database users<\/li><\/ul>","objective_plain":"On completion of this course, participants should be able to:\n\n\n- Describe Vertica&rsquo;s database and data storage structures\n- Load and remove data from a Vertica database\n- Optimize the database to improve query performance\n- Create and manage database users\n- Back up and restore a Vertica database","essentials_plain":"To be successful in this course, you should have the following prerequisites or knowledge:\n\n\n- Knowledge of RDBMS concepts (understanding databases and schemas, database normalization, etc.)\n- Familiarity with basic SQL syntax, ability to troubleshoot syntax errors, etc.\n- Experience with the Linux operating system (how to change directories, list directory contents, view and edit files, etc.)","audience_plain":"Database Administrators","contents_plain":"- Module 1: Introduction to the Training Environment\n- Module 2: Vertica Overview\n- Module 3: Introduction to Projections\n- Module 4: Loading Data\n- Module 5: Query Execution\n- Module 6: Optimizing Database Design\n- Module 7: Removing Data\n- Module 8: Database User Management\n- Module 9: Table Access Privileges\n- Module 10: Database Backup and Restore","outline_plain":"Module 1: Introduction to the Training Environment\n\n\n- Log in to the training environment\n- Review the training environment configuration\n- Introduction to Management Console\n- Using the valab utility\nModule 2: Vertica Overview\n\n\n- Describe the building blocks of the Vertica platform\nModule 3: Introduction to Projections\n\n\n- Identify basic projection types\n- Read a projection DDL to determine its structure\n- Describe the benefits of projections\nModule 4: Loading Data\n\n\n- Review the structure of tables and projections\n- Load data using the COPY command\n- Manually run the Tuple Mover mergeout task\n- Monitor data loads using Management Console and vsql\nModule 5: Query Execution\n\n\n- Generate a query plan\n- Time a query\n- Profile a query\n- Identify the database epochs\nModule 6: Optimizing Database Design\n\n\n- Create a comprehensive database design using Management Console\nModule 7: Removing Data\n\n\n- Remove data by dropping and truncating tables\n- Bulk delete data from tables\n- Purge delete vectors\nModule 8: Database User Management\n\n\n- Create new database users\n- Create new database user roles\n- Assign a role to a user\n- Create a role hierarchy\nModule 9: Table Access Privileges\n\n\n- Assign inheritable privileges to a database schema\n- Limit access to database columns and rows by role\n- Restrict non-administrator access to system tables\nModule 10: Database Backup and Restore\n\n\n- Create a backup configuration file\n- Back up and restore the database\n- Monitor database backups\n- Replicating objects\n- Duplicating a cluster","summary_plain":"The Vertica Essentials course covers the architecture and capabilities of Vertica Analytics in Enterprise mode. This course is a prerequisite to all advanced courses and will prepare you for the operational success of your deployment.\n\nHighlights:\n\n\n- Describe the Vertica data architecture\n- Manage data within a Vertica database, including loading and removing data\n- Describe how SQL queries are executed\n- Modify the database structure for optimal query execution\n- Manage database users","skill_level":"Intermediate","version":"23.3","duration":{"unit":"d","value":3,"formatted":"3 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":2400}}},"lastchanged":"2025-07-29T12:18:36+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/34937","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/opentext-verte"}}