|
Synopsis |
This course familiarizes the experienced Ingres user
with the Ingres visual management tools: VDBA, IJA (the journal analyzer), and
IIA (the import assistant). The use of VDBA to manage Ingres installations on a
daily basis is emphasised, as well as a number of features that are not
supported by any command-line utilities.
This course is intended for users who are already familiar
with the principles of Ingres database administration, and is not suitable
for those needing DBA training. (For DBA training, see
Ingres Database
Administration.) This course is especially suitable for those who will have
responsibility for supporting other users who will be expected to use these
tools ("training the trainer"). |
 Customers in the US/Canada should
contact KB
Computer Associates to schedule this course |
|
Duration and Cost |
2 days, £700 / $1,370USD / €1,040, per seat, ex
VAT |
Price excludes VAT and other applicable local taxes |
|
Location |
London, Manchester, Dublin, and
on-site world-wide |
|
|
Format |
Lecture and labs |
|
Course
Code |
IVM |
|
|
Prerequisites |
A strong knowledge of Ingres database
administration (or successful completion of
Ingres Database
Administration). This class assumes a high level of Ingres expertise from
the outset. |
|
|
Outline
Day 1 |
| Chapter 1 |
Getting Started |
| |
what VDBA is
/ exploring the interface / VDBA terminology / connecting to an
installation / starting RMCMD / the VDBA architecture / solving common
RMCMD problems |
| Chapter 2 |
Managing Databases
and Database Objects |
| |
creating a
database / creating tables / creating views / granting public access
rights / copying a database / drag-and-drop / adding and removing
columns |
| Chapter 3 |
Constraints,
Procedures and Rules |
| |
check
constraints / primary key constraints / database procedures / rules
|
| Chapter 4 |
Users, Groups and
Roles |
| |
creating and
managing users / groups / roles / database and installation privileges /
security auditing |
| Chapter 5 |
Testing and Tuning
Queries |
| |
the SQL
monitor / testing and benchmarking queries / display query execution
plans (QEPs) / generating and displaying column statistics / changing
the physical organization of a table |
| Chapter 6 |
Monitoring and
Resource Utilization |
| |
monitoring
an installation / diagnosing locking problems / identifying blocking
locks / examining performance and resource statistics |
| Chapter 7 |
Checkpoints,
Rollforwards, and Other Backups |
| |
performing
checkpoints / performing a rollforward recovery / unloading and
reloading databases / controlling journaling / maintaining system
catalogues / verifying database integrity |
|
|
|
Day 2 |
| Chapter 8 |
Ingres Journal
Analyzer (IJA) |
| |
introduction
to IJA / viewing transactions / recovering transactions |
| Chapter 9 |
Recovering
Transactions |
| |
recovering
individual rows / re-doing transactions |
| Chapter 10 |
Salvage |
| |
impersonating users / generating recovery scripts |
| Chapter 11 |
Ingres Import
Assistant (IIA) |
| |
using the
import assistant / loading and saving import parameters |
| Chapter 12 |
Specifying
Import/Export Formats |
| |
specifying
delimiters and embedded strings / column
specifications |
| Chapter 13 |
Loading Data |
| |
previewing,
appending, and replacing data |
|
Contact us
 |
|
|
Discounts are available for large
blocks of training or training credits bought at once. Contact us for
details. |
|
