Программа курса "Специализированный углубленный учебно-практический курс для продвинутых пользователей DBA Extreme"

Security

 Operating System Permissions
    UNIX
          Progress Executables
          File Types
          Permissions
    Progress Database Files
          Database Directory Permissions
          Database File Permissions
    Windows
          Progress Executables
          Progress Database Files
 Application Development Security
    Progress ABL (4GL) Applications
          Database Connection Authorization
          User Authentication
          SSL
          Schema Authorization
          Compile-Time Authorization
          Run-Time Authorization
          Cryptography
    .NET & Java Open Client Applications
          AppServer Access using SSL
          Digitally Signed Java Applets
 Application Deployment
    Secure Source Code
    WebClient Applications
    Report Builder User Authentication
    Application Portability
 Data Management
 Application Feature Authorization
 Application Service Security Features
 Integration Service Security Features
 WebSpeed Security Features
 Progress Dynamics Security Features
 Application Network Security Using SSL
    Secure Internet Access
    Secure Intranet Access
    Public-Key Infrastructure (PKI)
          Foundation Technologies & Terminology
          Features & Functions of SSL
          OpenEdge & SSL
 Auditing Security
 Core User Authentication & Authorization
    Establishing Authentication
    Creating UserIDs in the OE RDBMS _User Table
          OE Database Administration Tool
          Direct ABL Access
          Direct SQL Access
    Authenticating & Authorizing UserIDs in the OE RDBMS _User Table
          ABL Authentication
          SQL Authentication
    Asserting, Authorizing, & Validation of Trusted UserID Access
          Identity Management

Progress Auditing

 Progress Auditing
    Auditable Events
    Auditing States
    Enabling Auditing
    Auditing Tables
    Creating an Audit Policy
    Setting up an Audit Administrators
    Setting up Database Audit Options
    Audit Archiving

OpenEdge/Fathom Replication

 Overview of OE/Fathom Replication
 Configuring for TARGET and SOURCE
    Creating the TARGET properties file
    Creating the SOURCE Properties File
    Finalizing the SOURCE & TARGET databases
    Starting/Stopping Replication
          DBMAN
          Scripted
          Manual Intervention
 Monitoring Replication
 AI Management & Replication

After-Image (AI) Management

 Overview of AI Management
    Automatic mode
 Configuring automated AI File Management
 Monitoring and adjusting automated AI File Management
    Archived Extents
    Archive Log File
          Archive line
          Backup line
 AI Management Specific Commands
    RFUTIL AIARCHIVER DISABLE qualifier
    RFUTIL AIARCHIVER ENABLE qualifier
    RFUTIL AIARCHIVER END qualifier
    RFUTIL AIARCHIVER SETDIR qualifier
            RFUTIL AIARCHIVER SETINTERVAL qualifier
RFUTIL AIARCHIVE EXTENT qualifier

Progress to Non-Progress Connectivity

 Introduction to the DataServer
    ODBC
    Native
          MS SQL
          Oracle
    Components
    Security
          OpenEdge Security
          ODBC Data-source Security
          MS SQL Data Source Security
          ORACLE Security
    ROWID Support
 Setting up the Dataserver
    Creating the Foreign Schema:
          Connecting to an Existing Foreign Database
          Building a Foreign Database
    The Schema Holder
          Creating the Schema Holder
          Maintaining the Schema Holder
    DataServer for ODBC
          Setup
          Datatype Issues
    DataServer for Microsoft SQL Server
          Setup

SQL to Progress Connectivity

 Introduction
 Enabling the Progress SQL Engine
    Configuring Progress broker to accept SQL – Progress Explorer
    Configuring Progress broker to accept SQL – Command Line
 The ODBC Client
 Security
 Use SQL Explorer
 Tuning
    New Startup Options
    DBTool
    Update Statistics