Database Management Technology

Database Administration Course Outline

1. Logical Database Design (6 hours)
   1. Table Design
      1. Normalization
         1. First Normal Form
         2. Second Normal Form
         3. Third Normal Form
      2. Abstraction
         1. General
         2. Specialized
      3. Data Integrity and Security
      4. Performance
   2. Relationships Between Tables
      1. Mappings
         1. 1:1 Mapping
         2. 1:Many Mapping
         3. Many:Many Mapping
      2. Establish Required Relationships
         1. Simple Relationships
         2. Comples Relationships
         3. Multiple Relationships
            
2. Ingres Multi-Server Architecture (4 hours)
   1. Ingres Architecture VMS
   2. Ingres Architecture Unix
   3. Name Server (II_GCN)
   4. Clients
   5. Database Server (IIDBMS)
   6. Logging and Recovery
   7. Ingres/Net
   8. Ingres/Star
      
      
3. Ingres Installation and Configuration (8 hours)
   1. Configuring Ingres Locations
   2. Installation Process (Unix)
      1. ingbuild
      2. Installed Products
      3. Installing Products
      4. Removing Installed Products
   3. Installation Process (VMS)
   4. ingstart
   5. ingstop
   6. Configuration By Forms (CBF)
      1. Configuration Repository
      2. Configuration Rules
      3. Startup Display
      4. Change Log
      5. Parameter Types
      6. Resizing Transaction Log
      7. Dual Logging
      8. Custom Server Classes
      9. Ingres/Net
   7. accessdb
      1. Creating Locations
      2. Multi-location Sorting
      3. Auxiliary Work Locations
      4. Creating Locations with SQL
      5. Database Relocation
   8. Defining Users
      1. accessdb User Definition
      2. SQL User Definition
      3. User Profiles
         
4. Ingres/Net (2 hours)
   1. Virtual Nodes
      1. Privatge and Global
      2. VNode Names
      3. Network Protocols
      4. Remote Node and Listen Address
   2. User Authorization
      1. Private and Global
      2. Installation Passwords
      3. Authorization Maintenance
   3. Netutil
      
      
5. System and Database Administrator Programs (2 hours)
   1. Name Server Utility (iimanu)
   2. DBMS Server Monitor (iimonitor)
   3. Logging & Recovery Configuration (rcpconfig)
   4. Logging System Monitor (logstat)
   5. Locking System Monitor (lockstat)
   6. Ingres Performance Monitor (ipm)
      
      
6. SQL Database Definition (6 hours)
   1. Object Naming Conventions
   2. Database Creation
   3. Table Creation
      1. Default Definition
      2. Null Definition
      3. Logical Key Maintenance
      4. Constraints
      5. Alter Table
      6. Create Table With Subselect
   4. Views
   5. Synonyms
   6. modify Command
   7. Secondary Indexes
   8. Database Security
      
      
7. Knowledge Management (5 hours)
   1. Privileges and Groups
   2. Privileges and Roles
   3. Enhanced Grants
   4. Rules and Procedures
      
      
8. Database Backup and Maintenance (4 hours)
   1. Database Unload
   2. Database Checkpoint
   3. Rollforward From Checkpoint
   4. Table Level Checkpoint
   5. Backup to Tape
   6. Custom Backups
   7. alterdb Command
   8. Archiver Failure Recovery
   9. acpexit Command
   10. Database Activity Audit
   11. Table Maintenance