1-6001 – Vertica Essentials

EDU Trainings s.r.o.

Popis kurzu

Obsah kurzu

Module 1: Course Introduction
• Overview of course structure
• How to request a training lab environment
• Contact information
Module 2: 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 3: Vertica Overview
• Describe the building blocks of the Vertica platform
Module 4: Introduction to Projections
• Identify basic projection types
• Read a projection DDL to determine its structure
• Describe the benefits of projections
Module 5: 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
• Contrast data loading in Enterprise and Eon mode
Module 6: Query Execution
• Generate a query plan
• Time a query
• Profile a query
• Identify the database epochs
Module 7: Optimizing Database Design
• Create a comprehensive database design using Management Console
Module 8: Partitioning Table Data
• Introduction to partitioning
• Create partitioned tables
• Load data into partitions
• Move partitioned data into archive tables
• Hierarchical partitioning
Module 9: Removing Data
• Remove data by dropping and truncating tables
• Bulk delete data from tables
• Purge delete vectors
• Remove data by dropping partitions
Module 10: Database User Management
• Create new database users
• Create new database user roles
• Assign a role to a user
• Create a role hierarchy
Module 11: 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 12: Resource Management
• The importance of resource management
• How Vertica allocates resources to queries
• The built-in resource pools
• The resource pool parameters
Module 13: Database Backup and Restore
• Create a backup configuration file
• Back up and restore the database
• Monitor database backups
• Replicating objects
• Duplicating a cluster
Module 14: Flex Tables and Semi-Structured Data
• Define and describe semi-structured data
• Create flex tables and their supporting objects
• Load data in different formats into flex tables
• Explore data stored in flex tables
• Creating views
• Updating attributes

Cílová skupina

Database Administrators

Certifikát Na dotaz.

Hodnocení