Database Management Technology

Database Administration

Acquire the Ingres System Administrator, Database Administrator, and System Manager skills necessary for a complete understanding of the "Database Administration" process.

OBJECTIVES:

• Identify the fundamentals for the Relational Data Model
• Conduct a database design project
• Configure and perform an Ingres installation
• Monitor and enhance the database server, locking, and logging systems
• Use the various Ingres System Administrator utilities
• Install and Configure Ingres/Net and Ingres/Star
• Use the accessdb utility to update the master database
• Create and maintain database schemas
• Create rules and resource limits using Knowledge Managment
• Perform database backup, recovery, and auditing operations

Learn to make your Ingres installation perform at its peak. This class integrates Ingres and operating system performance into a single, cohesive tuning strategy.

OBJECTIVES:

• Understand the Ingres architecture with emphasis on host operating system interaction
• Measure resource usage using Ingres, Unix, VMS, and Windows tools
• Diagnose performance problems using trace points, log files, and operating system measurement tools
• Identify tools and techniques used to measure and evaluate effectiveness of specific parameter settings
• Reduce I/O bottlenecks through disk load balancing
• Modify logging, locking, server, and OS parameters for optimal operation
• Evaluate session level load balancing strategies in multi-server configurations
• Associate database server facilities with the appropriate startup parameters
• Identify and resolve concurrency conflicts
• Understand the Ingres query processing system

This class is designed to update the skills of experienced programmers who are new to Ingres and to instill Ingres system development skills in new programmers.

OBJECTIVES:

• Use all Structured Query Language (SQL) statements
• Use the Visual Forms Editor (VIFRED) to build forms
• Use ABF and/or Vision to compile, link, and execute Ingres-based systems
• Use the Ingres embedded languages and the forms run-time system (FRS)
• Develop and use Ingres error handlers
• Control lock timeout and deadlock situations under program control
• Solve application performance problems using QEPs, storage structures, alternate locations, secondary indexes, repeated queries, database procedures . . .