Loading Data into Vectorwise; E-Learning Course

Code: IVW_E20
Days: 0.5
Version: Vectorwise V2.5

You will learn:

After attending this Instructor-Led Online training course, you will be able to:

  • Create databases and Vectorwise tables
  • Load data, export and import data into a Vectorwise database
  • Setup a benchmark to run against Vectorwise

Course Style

This "e-learning" ILO training course is aimed at delegates who will be responsible for managing a Vectorwise database and installation. It offers an interactive environment for students to gain expertise via the web.

The ILO course employs lectures, demonstrations and hands-on labs to reinforce the course contents. The course focuses on the 64 bit Linux operating system.

Who Should Attend

This course is for Database and System Administrators who are responsible for the maintenance of Vectorwise databases. This course is also for System Architects responsible for data loading and benchmarking.

Prerequisites

IngresSQL training, or equivalent experience and skill.

To gain an overview the Vectorwise and to learn how to install the product, we recommend the e-learning course IVW_E10 Installing Vectorwise.

This e-learning course is delivered via the web to the student's PC. The student will require an audio connection to hear the instructor and a web browser to see the course delivery. Prior to the course, a list of PC technical prerequisites for will be issued.

Key Topics

  • Loading data into Vectorwise
  • Merging data into Vectorwise
  • Managing tables and indexes
  • Data integrity
  • Optimizer and statistics
  • Benchmarking

Next Course

Instructor-Led Online Training

This e-learning course forms part of an e-learning path for Vectorwise.
The next course in this path is IVW_E30 Vectorwise Backup and Maintenance.

Instructor-Led Classroom Training

This e-learning course provides an overview of the skills required to become an Vectorwise Database Administrator.
To gain more detailed instruction about how to manage an Ingres installation, we recommend either:

  • The IngresDBM course - Managing Ingres Installations and Databases
  • The DBMORA course - Ingres Database Management for Oracle DBAs