Managing Ingres / ActianX Installations and Databases
Code: IngresDBM
Days: 5
Ingres Version: ActianX (11.0)
You will learn:
At the end of this course you will be able to:
- Build, reconfigure and monitor your Ingres installation
- Be aware of the vital tasks that need to be performed to ensure the efficient running of the installation
- Understand the roles within Ingres
- Use the DBA tools
- Understand the major tasks that need to be performed to ensure the efficient running of your Ingres databases
Course Style
This course is aimed at delegates who will be responsible for managing an Ingres database and installation under Linux, UNIX, VMS, or Windows.
It covers all aspects of planning, installation, configuration, and day to day running of the Ingres 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 Ingres databases.
Prerequisites
Attendance at the IngresSQL training, or equivalent experience and skill
Key Topics
- Roles of the Ingres systems and database administrator
- Ingres architecture components
- Planning an Ingres Installation
- Performing an Ingres Installation
- Starting and stopping Ingres
- Communications facilities
- Logging system
- Locking system
- The Recovery System
- Logging and the Recovery Server
- The DBMS Server
- Configuring Ingres
- 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
Next Course
Optimizing Ingres Performance (Performance)
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 / ActianX Database Administrator
Course Description |
Duration |
IngresSQL Introduction to the Ingres / ActianX Product and Ingres SQL |
5 Days |
IngresDBM Managing Ingres / ActianX Installations and Database |
5 Days |
Performance Optimizing Ingres / ActianX Performance [Recommended] |
5 Days |
OpenROAD Developer/ Maintainer
Course Description |
Duration |
IngresSQL Introduction to the Ingres / ActianX Product and Ingres SQL |
5 Days |
OpenROAD |
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 / ActianX Product and Ingres SQL |
5 Days |
ABF |
4 Days |
IRW Ingres Reportwriter [Recommended] |
2 Days |
Report Developer / Maintainer
Course Description |
Duration |
IngresSQL Introduction to the Ingres / ActianX Product and Ingres SQL |
5 Days |
IRW - Ingres Reportwriter [Recommended] | 2 Days |
E-Learning Training Courses
Course | Code |
Training Room Classes
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 |
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 - Slough, UK
Course | Code | Date |
Vector and VectorH for Developers | VWDEV | 27-mar-2018 |
Managing Vector and VectorH Installations and Databases | VDBM | 23-apr-2018 |
OpenROAD Application Development and Maintenance | OPROAD | 30-apr-2018 |
OpenROAD 1-Day Overview | OOVVIEW | 30-apr-2018 |
Managing Ingres Installations and Databases | INGDBM | 11-jun-2018 |
OpenROAD Application Development and Maintenance | OPROAD | 18-jun-2018 |
OpenROAD 1-Day Overview | OOVVIEW | 18-jun-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
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.