Vertica 9.x Essentials (VT120)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt
 

Kursüberblick

The Vertica Essentials course explores the capabilities of the Vertica platform solution, and prepares you to manage the operational success of your deployment.

During this course, you will learn:

  • The architectural elements of a Vertica cluster
  • How to load and manage data in the database
  • How to manage database users and resources
  • How to back up and restore the database
  • Introductory information about Vertica’s built-in analytic functions
  • How to work with semi-structured data
  • Database security environment concerns

This class combines lectures with hands-on laboratory exercises performed in a live Verica database cluster.

Zielgruppe

This course is intended for database administrators, database architects, data analysts, and application developers.

Voraussetzungen

To be successful in this course, you should have the following prerequisites or knowledge:

  • 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.)

Kursziele

Upon successful completion of this course, you 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 and resources
  • Back up and restore a Vertica database
  • Find additional information and resources for working with Vertica

Kursinhalt

  • Introduction to the Training Environment
  • Vertica Overview
  • Introduction to Projections
  • Loading Data
  • Query Execution
  • Optimizing the Database
  • Partitioning Data
  • Removing Data
  • Database User Management
  • Table Access Privileges
  • Resource Management
  • Database Backup and Restore
  • Overview of Analytic Functions
  • Securing the Database
  • Flex Tables and Semi-Structured Data
  • Introduction to Vertica SQL on Hadoop
  • Next Steps
Classroom Training
Modality: G

Dauer 4 Tage

Preis (exkl. MwSt.)
  • Deutschland: 2.400,- €
Termine und Buchen
Online Training
Modality: U

Dauer 4 Tage

Preis (exkl. MwSt.)
  • Deutschland: 2.400,- €
Termine und Buchen
 
Zum Buchen bitte auf den Ortsnamen klicken Kurstermine
Dies ist ein Instructor-led Online Training, das über WebEx in einer VoIP Umgebung durchgeführt wird. Sollten Sie Fragen zu einem unserer Online-Kurse haben, können Sie uns jederzeit unter +49 (0)40 25334610 oder per E-Mail an info@flane.de kontaktieren.
Deutschland

Zur Zeit sind keine Termine verfügbar.  Fragen Sie an via info@flane.de.

Europa
Frankreich
19.11. - 22.11.2018 Online Training Zeitzone: Europe/Paris Kurssprache: französisch
 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.