Actian Ingres 12.0 New and Updated Features

Actian Ingres 12.0 New and Updated Features

Many new features and functionality upgrades have been provided with the release of Actian Ingres 12.0. During this course you will learn about each of the new or updated features to ensure that you continue to extract the very best from these flagship database products.

rate limit

Code not recognized.

About this course

Course Outcome:
With an ever changing set of use cases and requirements database products must keep up to date with the latest business trends to ensure the product remains relevant, stable and as reliable as it always has been.  Our flagship database products, Actian Ingres 12.0, editions bring to you numerous mission critical new features and functionality updates.  During this course we provide you with the information you require to extract the very best from these new or updated features. 
Course Style:
The training is provided in a step by step style providing you with best practice advice and guidance.
Audience:
For System or Database Administrators who have responsibility for maintaining the Corporate database estate.
Prerequisites:
  • You are using the minimum version of database software which is: Actian Ingres 12.0
  • You have the correct database access permissions to take advantage of the new features showcased here. 
Supplementary Resources:

Curriculum264 min

  • What's new in Actian Ingres 12.0. 14 min
  • New Features
  • Data Loading and Load Outcome Information for COPY VWLOAD Processes 6 min
  • UUID Support 6 min
  • Actian X JDBC and ODBC Connectors for Tableau 6 min
  • Automatic Log Rotation 6 min
  • Protected user and IMA read-only privileges 6 min
  • Query Result Caching including Spill to Disk 9 min
  • Configuration of Smart MinMax Index 7 min
  • IngresSync Tool 16 min
  • Backup to Cloud Storage Locations 8 min
  • Ad hoc Auto Partitioning 4 min
  • Table Cloning using the SQL 'CLONE' command 7 min
  • Containerisation
  • Actian X into Kubernetes Using Helm 17 min
  • How to install Actian X into Kubernetes with DR turned on. 16 min
  • SQL Features
  • Data Loading using Table Synonyms 4 min
  • Group by Timestamp with Timezone 6 min
  • Element and Element Count functions 7 min
  • 'Similar To' Pattern Matching 5 min
  • lengthb() Function 4 min
  • CopyDB -with_vwload 8 min
  • Cryptographic Hash Functions for X100 tables 8 min
  • Extended Timezone Support 1 min
  • IS [NOT] BOOLEAN Predicate 2 min
  • First N, After M and ORDER BY in Subselects 8 min
  • LIKE_REGX support 4 min
  • Remote File System Support for COPY VWLOAD/INSERT INTO EXTERNAL CSV 7 min
  • Smart Min/Max feature updates 7 min
  • IngresDate vs AnsiDate Explainer 4 min
  • Workload Management
  • Work Load Management - Overview 6 min
  • Work Load Management - Create Queues and Configurations 8 min
  • Work Load Management - Enable, Disable, Audit and Monitor 7 min
  • UDF
  • UDF Functionality Overview and using DBeaver to execute UDF functionality. 7 min
  • UDF Engine Startup 2 min
  • Manually Install and Configure the UDF Container Runtime after installation of Actian X 12.0 or Vector 7.0 8 min
  • Using the UDF Installer 2 min
  • UDF Query Cancelling 2 min
  • UDF Log Output & Importing Libraries into the UDF Execution Environment 7 min
  • Extending UDF Accessibility 3 min
  • Installing Actian Ingres
  • Getting Started with Actian Ingres 12.0 8 min

    If you are new to the Actian Ingres product then use this video as a guide for installing Actian Ingres 12.0 in a best practice supported manner.

  • Feedback
  • Take Course Survey 1 min

About this course

Course Outcome:
With an ever changing set of use cases and requirements database products must keep up to date with the latest business trends to ensure the product remains relevant, stable and as reliable as it always has been.  Our flagship database products, Actian Ingres 12.0, editions bring to you numerous mission critical new features and functionality updates.  During this course we provide you with the information you require to extract the very best from these new or updated features. 
Course Style:
The training is provided in a step by step style providing you with best practice advice and guidance.
Audience:
For System or Database Administrators who have responsibility for maintaining the Corporate database estate.
Prerequisites:
  • You are using the minimum version of database software which is: Actian Ingres 12.0
  • You have the correct database access permissions to take advantage of the new features showcased here. 
Supplementary Resources:

Curriculum264 min

  • What's new in Actian Ingres 12.0. 14 min
  • New Features
  • Data Loading and Load Outcome Information for COPY VWLOAD Processes 6 min
  • UUID Support 6 min
  • Actian X JDBC and ODBC Connectors for Tableau 6 min
  • Automatic Log Rotation 6 min
  • Protected user and IMA read-only privileges 6 min
  • Query Result Caching including Spill to Disk 9 min
  • Configuration of Smart MinMax Index 7 min
  • IngresSync Tool 16 min
  • Backup to Cloud Storage Locations 8 min
  • Ad hoc Auto Partitioning 4 min
  • Table Cloning using the SQL 'CLONE' command 7 min
  • Containerisation
  • Actian X into Kubernetes Using Helm 17 min
  • How to install Actian X into Kubernetes with DR turned on. 16 min
  • SQL Features
  • Data Loading using Table Synonyms 4 min
  • Group by Timestamp with Timezone 6 min
  • Element and Element Count functions 7 min
  • 'Similar To' Pattern Matching 5 min
  • lengthb() Function 4 min
  • CopyDB -with_vwload 8 min
  • Cryptographic Hash Functions for X100 tables 8 min
  • Extended Timezone Support 1 min
  • IS [NOT] BOOLEAN Predicate 2 min
  • First N, After M and ORDER BY in Subselects 8 min
  • LIKE_REGX support 4 min
  • Remote File System Support for COPY VWLOAD/INSERT INTO EXTERNAL CSV 7 min
  • Smart Min/Max feature updates 7 min
  • IngresDate vs AnsiDate Explainer 4 min
  • Workload Management
  • Work Load Management - Overview 6 min
  • Work Load Management - Create Queues and Configurations 8 min
  • Work Load Management - Enable, Disable, Audit and Monitor 7 min
  • UDF
  • UDF Functionality Overview and using DBeaver to execute UDF functionality. 7 min
  • UDF Engine Startup 2 min
  • Manually Install and Configure the UDF Container Runtime after installation of Actian X 12.0 or Vector 7.0 8 min
  • Using the UDF Installer 2 min
  • UDF Query Cancelling 2 min
  • UDF Log Output & Importing Libraries into the UDF Execution Environment 7 min
  • Extending UDF Accessibility 3 min
  • Installing Actian Ingres
  • Getting Started with Actian Ingres 12.0 8 min

    If you are new to the Actian Ingres product then use this video as a guide for installing Actian Ingres 12.0 in a best practice supported manner.

  • Feedback
  • Take Course Survey 1 min