| Course Topics: |
What is Progress: DBMS + Dictionary + Language + Appbuilder Database concepts: Logical vs. Physical view Programming and documentation standards Creating a database Defining a table Fields, and field properties: Formats, View-as phrases The unknown (null) value Indexes: Indexing rules, efficiency Flow of data: Prompt-for, assign, display, etc. The enable request & event-driven programming Find vs For each For each vs Query Event-driven programming concepts Message formatting Running procedures: propath, .ini files Include files and preprocessor variables Passing parameters Internal procedures Persistent procedures Strategies to separate user interface and business logic Sorting data Validating input Schema vs. session triggers When triggers fire Relational database structure Progress frames & record scope Record buffers Object vocabulary (fill-in, combo-box, editor, selection list, etc.) Object handles Dynamic objects System handles Methods Event driven programming - intensive Programming techniques for toggle boxes, radio sets, selection lists, browsers, etc. Applying events Return-no-apply Using indexed-reposition Defining menus Before-image and local before-image files Transactions and transaction scope Locking strategies: Progress defaults, optimistic locking Multi-user programming issues Importing and exporting data. Output headers and footers Reporting techniques: aggregating data, break by Basic database administration: startup, shutdown, backup, -B Appbuilder for character development |