|
Synopsis |
A 3-day class in Ingres database administration.
Includes creating and destroying databases, Ingres utilities; internal structure
of tables and choosing a structure; resource management and resource limiting, and backup and recovery.
This course covers all versions up to Ingres 2006.
|
 Customers in the US/Canada should
contact KB
Computer Associates to schedule this course |
|
Duration and Cost |
3 days, £1,050 / $2,050USD / €1,560, 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 |
DBA |
|
|
Prerequisites |
Some familiarity with SQL and an operating
system such as Linux, Unix, W2K/W2K3, or OpenVMS. Some previous experience in the role
of a DBA would be beneficial, but not essential.
This course will typically be taken
after completing the 2-day Ingres System Administration course. |
|
|
Outline
Day 1 |
| Chapter 1 |
Databases |
| |
creating a
database / constituents of a database / directory structure / areas and
locations / symbol table / destroying a database / unloading a database
/ displaying the database configuration file |
| Chapter 2 |
Users |
| |
creating
Ingres users / installation passwords / various system catalogues / user
attributes & privileges / default & requestable privileges / user
profiles / creating, altering, & dropping profiles / impersonating a
user |
| Chapter 3 |
Tables |
| |
creating
tables / Ingres naming rules / column specifications / controlling
physical characteristics / CREATE TABLE...AS SELECT / schemas & table
ownership / data files & iifile_info catalogue / physical storage /
tuple identifiers / free space management / rule-based table
partitioning / automatic partitioning / hash partitioning / list
partitioning / range partitioning / temporary tables / copying
tables / XML import & export |
|
|
|
Day 2 |
| Chapter 4 |
Storage Structures
I |
| |
pages /
storage structures / physical keys / heaps / duplicate rows / heapsort
tables / overflow pages / hash tables / ISAM tables / B-tree tables /
compression / uniqueness / page size |
| Chapter 5 |
Storage Structures
II |
| |
MODIFY
statement / secondary indices / create index / parallel index build /
dropping an index / index persistence / the query optimizer / statistics
/ optimizedb & statdump
|
| Chapter 6 |
Integrity
Constraints |
| |
constraints
/ check constraints / column-level constraints / named constraints /
table-level constraints / adding check constraints / entity integrity
(unique) constraints / primary key constraints / constraint WITH clause
/ surrogate keys and entity integrity / referential integrity /
referential constraint actions / discovering constraints / system
catalogues |
|
|
|
Day 3 |
| Chapter 7 |
Other Database
Objects |
| |
synonyms /
comments / views / creating a view / updateable views / views and
security / database events / database procedures / database rules / row-
& statement-level rules / tracing rules / suppressing rules
|
| Chapter 8 |
Backup & Recovery |
| |
review of
backup strategies / operating system backups / unloaddb & copydb /
checkpoints / user backup privileges / ckpdb / off-line checkpoints /
checkpoint procedure / on-line checkpoints / parallel checkpoints /
table-level checkpoints / checkpoint status / checkpointing master
database / journaling / recovery using a checkpoint / rollforwarddb /
table-level recovery / auditdb / customizing the checkpoint procedure /
disaster recovery |
| Chapter 9 |
Security |
| |
GRANT
statement / insert. update, select, delete, references privileges /
delegating security administration / grants on non-table objects /
REVOKE statement / propagated revocation / user groups / scope of groups
/ creating groups / iiusergroup / granting a privilege to a group /
exploiting group privileges / altering group privileges / dropping a
group / user roles / scope of roles / creating roles / altering a role /
controlling
access using views / database & installation privileges / disabling
privileges / interaction of privileges / resource limiting / iipermits /
security auditing / security events / security alarms / creating
security alarms / using security auditing to trace SQL |
|
Contact us
 |
|
|
Discounts are available for large
blocks of training or training credits bought at once. Contact us for
details. |
|
