Database Management Technology

Ingres Programming Course Outline

1. Introduction (3 hours)
   1. Relational Data Model
   2. RDBMS Advantages
   3. Relational Data Model Components
      1. Structures
      2. Constraints
      3. Operations
   4. Sample Graphical Schema
   5. Database Desing Lifecycle
      
      
2. Ingres Subsystems Overview (1 hour)
   1. Subsystem Relationships
   2. Forms Runtime System (FRS)
   3. Visual Forms Editor (FRS)
   4. Query By Forms (QBF)
   5. Report By Forms (RBF)
   6. Report Writer
   7. Terminal Monitors
   8. Embedded Language Programming
   9. Application By Forms (ABF)
   10. Accessing Ingres/Menu
       
       
3. Visual Forms Editor (VIFRED) (3 hours)
   
   
4. Vision (6 hours)
   1. Concepts
   2. Vision Objects
   3. Creating Applications
      1. Frame Definition
      2. Frame Flow Editor
      3. Frame Flow Menu Option Summary
      4. Creating Frames
      5. Editing Frames
   4. Production Applications
   5. Command Line Parameters
      
      
5. SQL Data Manipulation (6 hours)
   1. Syntax Conventions
   2. SQL Help
   3. Command Components
      1. Expressions
      2. Result Columns
      3. Search Conditions
   4. Commands
      1. Select
      2. Insert
      3. Update
      4. Delete
   5. Transaction Management
      
      
6. SQL Database Procedures (3 hours)
   1. Implementation
   2. Command Syntax
   3. Error Handling
      
      
7. 4GL Programming (10 hours)
   1. Executing Operations
   2. Forms System Variables
   3. 4GL Variables
   4. Look-up Frame
   5. Using Data Manipulation Statements
   6. Field Operations
   7. Flow Control Commands
   8. Application Timeout
   9. Helpfile and Help_Forms
   10. Call Statements
   11. Array Function Summary
       
       
8. Embedded SQL (4 hours)
   1. Development Process
   2. ESQLC Preprocessor
   3. DCLGEN
   4. Error Handling
   5. Declare Section
   6. Database Access
   7. Data Manipulation Statements
   8. Using NULLs
   9. Database Cursors
   10. Executing Database Procedures
   11. Dynamic SQL
       
       
9. Query Performance (4 hours)
   1. Query Processing Overview
   2. Storage Structure Implications
   3. Modify Command
   4. Multi-Location Tables
   5. Seconday Indexes
   6. SYSMOD
   7. OPTIMIZEDB
   8. STATDUMP
   9. Query Execution Plans (QEPs)
   10. Server Performance Constants