Matrix Architecture and Application Development

Code: MTXSQL
Days: 3
Version: 5.2

You will learn:

At the end of this course you will be able to:

  • Understand Matrix concepts and architecture
  • Configure your Matrix systems
  • Gain an appreciation of Statistics, including multi-column (KVM)
  • Set up Matrix Security: users, groups, types of permission by object type, superusers
  • Obtain a good knowledge of Matrix SQL
  • Use Matrix ODIs to interface with external data sources and protocols
  • Understand Query Execution Plans and resource management
  • Write basic User Defined Functions

 Course Style

The course consists of lecture, presented as slides and whiteboard, and demonstrations.  It's very interactive, and everyone is encouraged to ask questions and offer insights.

 Who Should Attend

This course is for developers and super users.  DBAs and more technical managers would benefit from the first day, where architecture and concepts are covered.

 Prerequisites

      • A good knowledge of SQL
      • Attendance at the MatrixDBM training, or equivalent experience and skill.

Key Topics

        • Matrix concepts and architecture
          • MPP, role of multiple machines
          • Raw storage
          • Key terms: block, slice, superblock
          • Columnar storage
          • Distribution keys, sort keys
          • Concurrency model
          • Vacuum
          • Compiled queries
          • Important files and directories in a Matrix cluster
        • Configuration
          • Main config file
          • Client access
        • Getting started
          • Basic database operations with cqi
          • Access the database with psql, including slash commands
          • Search path
        • Statistics, including multi-column (KVM)
        • Security: users, groups, types of permission by object type, superusers
        • SQL
          • Matrix datatypes
          • Typecasts
          • LIMIT
          • Best practices (common table expressions, OLAP functions)
          • Immediate use of aliases
        • System catalog
        • Loading and unloading data
        • ODIs
        • Query execution
          • Planner, compilation, cache
          • Execution plans
          • Query working memory, spilling to disk
          • Workload management
        • Backup and restore
        • User Defined Functions
          • Language: SQL
          • Language: PLPGSQL
          • Language: C++ (scalar, table)

 



Please Note

This course requires access to Amazon Web Services (AWS) or similar for practical sessions and therefore for external courses access to the internet is required and all associated AWS costs will be passed onto the customer. 

We have clear learning paths, so there is an appropriate course whatever your current expertise and knowledge. You can continuously advance your understanding and skills with Actian solutions by following the learning paths below.


Ingres Database Administrator

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days
IngresDBM
Managing Ingres Installations and Database
5 Days
Performance
Optimizing Ingres Performance [Recommended]
5 Days

OpenROAD Developer/ Maintainer

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days

OpenROAD
OpenROAD Application Development and Maintenance

5 Days
ORAdv
Advanced Techniques in OpenROAD
3 Days
OReServer
OpenROAD Server and EClient for Developers [Option]
3 Days

Vector and VectorH Database Administrator

Course Description

Duration

IngresSQL
Introduction to SQL [Recommended]
5 Days
VectorDBM
Managing Vector / VectorH Installations and Databases
4-5 Days

Vector and VectorH Developer

Course Description

Duration

IngresSQL
Introduction to SQL [Recommended]
5 Days
VectorDEV
Vector / VectorH for Developers
1-2 Days

DataConnect v11 Data Integrator

Course Description

Duration

DataConnectCore
DataConnect v11 Core
4 Days
DataConnectIT
EDI/HIPAA Integration Techniques
1 Day

Versant Database System Administrator

Course Description

Duration

VersantDBM
Managing Versant Installations and Database
3 Days

ABF Developer/ Maintainer

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days

ABF
Application Development in Ingres ABF

4 Days
IRW
Ingres Reportwriter [Recommended]
2 Days

Report Developer / Maintainer

Course Description

Duration

IngresSQL
Introduction to the Ingres Product and Ingres SQL
5 Days
IRW - Ingres Reportwriter [Recommended] 2 Days
We have a number of scheduled runnings for core classes in EMEA, APAC and North America. Other courses are offered on an on-demand basis. Please contact education@actian.com for further information.

E-Learning Training Courses

Course Code

Training Room Classes

Course Code
DataConnect v11 Core Training DATA11
DataConnect v10 Core DATACON
Ingres Database Management For Oracle DBAs DBMORA
Managing Ingres Installations and Databases INGDBM
Introduction to the Ingres Product and Ingres SQL INGSQL
New Features in Ingres INGUPD
Ingres 1-Day Overview IOVVIEW
OpenROAD 1-Day Overview OOVVIEW
OpenROAD Application Development and Maintenance OPROAD
Optimising Ingres Performance PERFORM
Managing Vector and VectorH Installations and Databases VDBM
Versant Object Database Administration VERDBM
Vector and VectorH for Developers VWDEV
Please use the following list to jump to a regional schedule

Whether you are new to Ingres or an old hand, our education courses are designed to make sure you learn how to make best use of the advanced features and functionality in the latest release. For inquiries about our education programs, please email education@actian.com, or formations@actian.com (FR).

America

Location - Austin, USA

Course Code Date
Managing Ingres Installations and Databases INGDBM 27-nov-2017
DataConnect v11 Core Training DATA11 11-dec-2017
DataConnect v10 Core DATACON 15-jan-2018
DataConnect v11 Core Training DATA11 05-feb-2018
DataConnect v11 Core Training DATA11 19-mar-2018
DataConnect v11 Core Training DATA11 23-apr-2018
DataConnect v11 Core Training DATA11 11-jun-2018
DataConnect v11 Core Training DATA11 16-jul-2018
DataConnect v11 Core Training DATA11 20-aug-2018
DataConnect v11 Core Training DATA11 01-oct-2018
DataConnect v11 Core Training DATA11 03-dec-2018

Europe, Middle East, Africa

Location - Hamburg, Germany (English materials with German instructor)

Course Code Date
Versant Object Database Administration VERDBM 14-nov-2017
New Features in Ingres INGUPD 23-nov-2017
Managing Ingres Installations and Databases INGDBM 11-dec-2017

Location - Slough, UK

Course Code Date
Optimising Ingres Performance PERFORM 20-nov-2017
Ingres 1-Day Overview IOVVIEW 15-jan-2018
Introduction to the Ingres Product and Ingres SQL INGSQL 15-jan-2018
Managing Ingres Installations and Databases INGDBM 05-feb-2018
OpenROAD Application Development and Maintenance OPROAD 05-mar-2018
OpenROAD 1-Day Overview OOVVIEW 05-mar-2018
Managing Vector and VectorH Installations and Databases VDBM 12-mar-2018
Vector and VectorH for Developers VWDEV 27-mar-2018
Ingres 1-Day Overview IOVVIEW 30-apr-2018
Introduction to the Ingres Product and Ingres SQL INGSQL 30-apr-2018
Managing Ingres Installations and Databases INGDBM 11-jun-2018
OpenROAD Application Development and Maintenance OPROAD 02-jul-2018
OpenROAD 1-Day Overview OOVVIEW 02-jul-2018
Optimising Ingres Performance PERFORM 30-jul-2018
Ingres 1-Day Overview IOVVIEW 03-sep-2018
Introduction to the Ingres Product and Ingres SQL INGSQL 03-sep-2018
Managing Ingres Installations and Databases INGDBM 17-sep-2018
OpenROAD Application Development and Maintenance OPROAD 01-oct-2018
OpenROAD 1-Day Overview OOVVIEW 01-oct-2018
Vector and VectorH for Developers VWDEV 06-nov-2018
Managing Vector and VectorH Installations and Databases VDBM 19-nov-2018

Australia, New Zealand and Asia Pacific

Location - APAC, Australia

Course Code Date
Optimising Ingres Performance PERFORM 20-nov-2017
Ingres Database Management For Oracle DBAs DBMORA 12-feb-2018
Ingres 1-Day Overview IOVVIEW 19-feb-2018
Introduction to the Ingres Product and Ingres SQL INGSQL 19-feb-2018
Managing Ingres Installations and Databases INGDBM 19-mar-2018
OpenROAD Application Development and Maintenance OPROAD 09-apr-2018
OpenROAD 1-Day Overview OOVVIEW 09-apr-2018
Ingres 1-Day Overview IOVVIEW 07-may-2018
Introduction to the Ingres Product and Ingres SQL INGSQL 07-may-2018
Optimising Ingres Performance PERFORM 21-may-2018
Managing Ingres Installations and Databases INGDBM 18-jun-2018
OpenROAD Application Development and Maintenance OPROAD 02-jul-2018
OpenROAD 1-Day Overview OOVVIEW 02-jul-2018
Ingres 1-Day Overview IOVVIEW 16-jul-2018
Introduction to the Ingres Product and Ingres SQL INGSQL 16-jul-2018
Optimising Ingres Performance PERFORM 23-jul-2018
Managing Ingres Installations and Databases INGDBM 06-aug-2018
OpenROAD Application Development and Maintenance OPROAD 20-aug-2018
OpenROAD 1-Day Overview OOVVIEW 20-aug-2018
Ingres 1-Day Overview IOVVIEW 03-sep-2018
Introduction to the Ingres Product and Ingres SQL INGSQL 03-sep-2018
Optimising Ingres Performance PERFORM 17-sep-2018
Ingres Database Management For Oracle DBAs DBMORA 08-oct-2018
Optimising Ingres Performance PERFORM 22-oct-2018
OpenROAD Application Development and Maintenance OPROAD 12-nov-2018
OpenROAD 1-Day Overview OOVVIEW 12-nov-2018
Optimising Ingres Performance PERFORM 19-nov-2018

ONLINE

The Ingres Instructor-Led Online Training environment is an alternative to our traditional in-class training, without the need for expensive travel.

Ingres ILO Environment

Our ILO environment provides

  • Interactive, instructor led training
  • Live demos
  • Pre-configured remote lab environment
  • Classes available to suit your timezone
  • PDF handouts of course material

"Closed" ILO Class

Efficient training for coworkers across multiple locations. If your team is geographically dispersed you can also request that our instructor-led online format be delivered as a "Closed" course for your company.