Test theme
Managing Actian X Installations and Databases  (Instructor-led)

Managing Actian X Installations and Databases (Instructor-led)

This paid for instructor led course covers all aspects of planning, installation, configuration, and day to day running of the Actian X installation. It also covers all aspects of database administration including: managing database objects such as tables, indexes, applications etc.; data integrity; security; backup and recovery; table maintenance and optimization.

Not currently available

There are no seats available for purchase at this time.

About this course

Instructor-led Yes
Duration 5 days
Course charge Yes.  Please email the Actian Education team to discuss further
Product version Actian X 11.x
Course code IngresDBM

Course Style

This course is aimed at delegates who will be responsible for managing an Actian X database and installation under Linux, UNIX, VMS, or Windows. 
It covers all aspects of planning, installation, configuration, and day to day running of the Actian X installation. It also covers all aspects of database administration including: managing database objects such as tables, indexes, applications etc.; data integrity; security; backup and recovery; table maintenance and optimization. 
The course employs lectures, demonstrations and practicals to reinforce the course contents. The course does not focus on a particular operating system but uses examples for the Linux, Unix, Windows and VMS operating systems throughout the course material.

Who Should Attend

This course is for Database and System Administrators who are responsible for the maintenance of Actian X databases.

Prerequisites

Attendance at the Actian XSQL training, or equivalent experience and skill

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

  • Build, reconfigure and monitor your Actian X installation
  • Be aware of the vital tasks that need to be performed to ensure the efficient running of the installation
  • Understand the roles within Actian X
  • Use the DBA tools
  • Understand the major tasks that need to be performed to ensure the efficient running of your Actian X databases

Key Topics

  • Roles of the Actian X systems and database administrator
  • Actian X architecture components
  • Planning an Actian X Installation
  • Performing an Actian X Installation
  • Starting and stopping Actian X
  • Communications facilities
  • Logging system
  • Locking system
  • The Recovery System
  • Logging and the Recovery Server
  • The DBMS Server
  • Configuring Actian X
  • Configuration-By-Forms
  • Rules Files
  • The Master Database
  • User maintenance
  • Location maintenance
  • Environment variables
  • Customising Backup and Recovery
  • IMA
  • Creating and destroying databases
  • System catalogs
  • Unloading and reloading databases
  • Managing tables, secondary indexes, views
  • Managing user interface objects
  • Data integrity and security
  • Database object access
  • Authorising and monitoring access
  • Database and installation privileges
  • Backing up databases
  • Journaling
  • Recovering databases
  • Maintaining and optimizing databases
  • Overflow
  • Optimizer and statistics
  • Benchmarking queries
  • Maintenance scripts
  • Managing disk space

About this course

Instructor-led Yes
Duration 5 days
Course charge Yes.  Please email the Actian Education team to discuss further
Product version Actian X 11.x
Course code IngresDBM

Course Style

This course is aimed at delegates who will be responsible for managing an Actian X database and installation under Linux, UNIX, VMS, or Windows. 
It covers all aspects of planning, installation, configuration, and day to day running of the Actian X installation. It also covers all aspects of database administration including: managing database objects such as tables, indexes, applications etc.; data integrity; security; backup and recovery; table maintenance and optimization. 
The course employs lectures, demonstrations and practicals to reinforce the course contents. The course does not focus on a particular operating system but uses examples for the Linux, Unix, Windows and VMS operating systems throughout the course material.

Who Should Attend

This course is for Database and System Administrators who are responsible for the maintenance of Actian X databases.

Prerequisites

Attendance at the Actian XSQL training, or equivalent experience and skill

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

  • Build, reconfigure and monitor your Actian X installation
  • Be aware of the vital tasks that need to be performed to ensure the efficient running of the installation
  • Understand the roles within Actian X
  • Use the DBA tools
  • Understand the major tasks that need to be performed to ensure the efficient running of your Actian X databases

Key Topics

  • Roles of the Actian X systems and database administrator
  • Actian X architecture components
  • Planning an Actian X Installation
  • Performing an Actian X Installation
  • Starting and stopping Actian X
  • Communications facilities
  • Logging system
  • Locking system
  • The Recovery System
  • Logging and the Recovery Server
  • The DBMS Server
  • Configuring Actian X
  • Configuration-By-Forms
  • Rules Files
  • The Master Database
  • User maintenance
  • Location maintenance
  • Environment variables
  • Customising Backup and Recovery
  • IMA
  • Creating and destroying databases
  • System catalogs
  • Unloading and reloading databases
  • Managing tables, secondary indexes, views
  • Managing user interface objects
  • Data integrity and security
  • Database object access
  • Authorising and monitoring access
  • Database and installation privileges
  • Backing up databases
  • Journaling
  • Recovering databases
  • Maintaining and optimizing databases
  • Overflow
  • Optimizer and statistics
  • Benchmarking queries
  • Maintenance scripts
  • Managing disk space