Test theme
Managing Actian X Installations and Databases (self-paced)

Managing Actian X Installations and Databases (self-paced)

This course provides insight into 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.

About this course

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

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.

Curriculum14 hr 30 min

  • Installing Actian X 1 hr 4 min
  • Activity 0 hr 9 min
  • Ingres Architecture 0 hr 35 min
  • Activity 0 hr 2 min
  • Ingres Query Tools 0 hr 27 min
  • Activity 0 hr 9 min
  • Ingres Databases 0 hr 44 min
  • Activity 0 hr 10 min
  • Tables 0 hr 41 min
  • Activity 0 hr 8 min
  • Table Management 0 hr 37 min
  • Activity 0 hr 7 min
  • Storage Structures 0 hr 45 min
  • Activity 0 hr 6 min
  • Secondary Indexes 0 hr 10 min
  • Activity 0 hr 4 min
  • The Logging and Recovery System 0 hr 53 min
  • Activity 0 hr 9 min
  • The Locking System 0 hr 48 min
  • Activity 0 hr 4 min
  • Data Security 0 hr 43 min
  • Activity 0 hr 12 min
  • Data Integrity 0 hr 29 min
  • Activity 0 hr 14 min
  • Other Database Objects 0 hr 38 min
  • Activity 0 hr 5 min
  • Database Backup and Recovery 0 hr 58 min
  • Activity 0 hr 9 min
  • Ingres DBMS Server 0 hr 34 min
  • Activity 0 hr 5 min
  • Ingres Configuration 0 hr 12 min
  • Activity 0 hr 12 min
  • IMA, Visual DBA and Director 0 hr 13 min
  • Database Optimisation 0 hr 27 min
  • Activity 0 hr 10 min
  • Ingres Locations 0 hr 16 min
  • Activity 0 hr 7 min
  • Maintenance 0 hr 30 min
  • Activity 0 hr 6 min
  • Take Course Survey
  • Course Activity Content

About this course

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

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.

Curriculum14 hr 30 min

  • Installing Actian X 1 hr 4 min
  • Activity 0 hr 9 min
  • Ingres Architecture 0 hr 35 min
  • Activity 0 hr 2 min
  • Ingres Query Tools 0 hr 27 min
  • Activity 0 hr 9 min
  • Ingres Databases 0 hr 44 min
  • Activity 0 hr 10 min
  • Tables 0 hr 41 min
  • Activity 0 hr 8 min
  • Table Management 0 hr 37 min
  • Activity 0 hr 7 min
  • Storage Structures 0 hr 45 min
  • Activity 0 hr 6 min
  • Secondary Indexes 0 hr 10 min
  • Activity 0 hr 4 min
  • The Logging and Recovery System 0 hr 53 min
  • Activity 0 hr 9 min
  • The Locking System 0 hr 48 min
  • Activity 0 hr 4 min
  • Data Security 0 hr 43 min
  • Activity 0 hr 12 min
  • Data Integrity 0 hr 29 min
  • Activity 0 hr 14 min
  • Other Database Objects 0 hr 38 min
  • Activity 0 hr 5 min
  • Database Backup and Recovery 0 hr 58 min
  • Activity 0 hr 9 min
  • Ingres DBMS Server 0 hr 34 min
  • Activity 0 hr 5 min
  • Ingres Configuration 0 hr 12 min
  • Activity 0 hr 12 min
  • IMA, Visual DBA and Director 0 hr 13 min
  • Database Optimisation 0 hr 27 min
  • Activity 0 hr 10 min
  • Ingres Locations 0 hr 16 min
  • Activity 0 hr 7 min
  • Maintenance 0 hr 30 min
  • Activity 0 hr 6 min
  • Take Course Survey
  • Course Activity Content