|
|
|
|
Training Services
The following courses are available at our Corporate Training Facility, as well as on-site, world-wide. |
|
D3/AP Courses |
|
Compatibility: All versions of D3, AP (Advanced Pick), and OA (Open Architecture), IBM/RT, PickBlue |
|
Course# 100-D: Introduction to D3 |
|
|
Benefits: | Understand the major features of this powerful database |
Audience: | Anyone who needs an overall understanding of D3 |
Method: | Lecture |
Length: | Half day |
Pre-requisites: | None |
Topics Covered: |
The History of Pick; Terminology; Benefits and Features; System Architecture: Hardware, Firmware, and Software; The System Processors; Data Hierarchy and Organization; System Provided Utilities and Data; Introduction to ACCESS, Dictionaries, and PROC. |
|
Course# 115-D: In-Depth ACCESS |
Benefits: | Gain a working knowledge of the report writer language, and to recognize the power of the Data Dictionary. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 2 Days |
Pre-requisites: | None |
Topics Covered: | Overview of the Database Hierarchy; Files and Items; ACCESS Sentence Structure; Verbs; Filenames; Output Specifications; Item Lists; Selection Criteria; Sort Keys; Modifiers; Options; Finding and Understanding Dictionaries: Dictionary Type; Attribute Number; Column Heading; Conversions; Correlatives; Justification; and Column Width. |
| |
Course# 135-D: D3 Fundamentals |
Benefits: | Gain a comprehensive working knowledge of the system; learn how to harness its inherent power, and light day-to-day administration. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | None |
Topics Covered: | All those in course #100, plus: System and File Structure; Database Fundamentals; TCL Commands and Utilities; Creating Accounts, Files, and Dictionaries; The System Editor; Data Retrieval Using ACCESS; Data Manipulation: Dictionaries, Conversions/Correlatives; Sorting; Control Breaks and Totals; Modifiers; List Processing; The PROC Language; Saving Report Sentences; Creating Menus; Architecture; Start-up and Shut-down; Printer Management: the Spooler; Backups and Restores; Performance: File Sizing Techniques. |
| |
Course# 235-D: Structured Programming in D3 |
Benefits: | Learn how to effectively use this language for all aspects of programming tasks, using structured techniques. |
Audience: | All programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #135-D |
Topics Covered: | History and Features of PICK/BASIC; Source and Object Code; Compile, Run, and Catalog; Program Variables, Constants, and Expressions; Input and Output Statements; Conditional and Loop Statements; Project Analysis, Design, and Specification; Software Design/Maintenance Considerations; PICK/BASIC Statements and Directives; Structured BASIC Programming; Human Design Factors; Interface with Other System Processors; Intrinsic Statements; Debugger Techniques; Conditional Statements; Data Verification; Screen I/O; File I/O; Transaction Processing; Batch Processing; Report Programs; Character Masking; Headings and Footings. |
| |
Course# 300-D: Advanced ACCESS |
Benefits: | Learn advanced techniques and commands to gather the specific data that suits your needs more closely, more accurately, and more quickly without relying on outside assistance. |
Audience: | All advanced users, administrators, managers, executives, programmers, analysts, operators, etc. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #135-D |
Topics Covered: | Review of ACCESS, Dictionaries, and Internal Timings; Advanced Conversions/Correlatives; Processing Sequence: The F-Correlative; "IF-THEN-ELSE" A-Correlatives; Multiple Conversions and Correlatives; Multi-line Output Within a Column; Special Multi-Value Handling: Explosion, Print Limiting, Controlling/ Dependencies; Conditional/Bucket Processing; Average/Percent Totalling; Invisible Fields; Comparing Attributes; Reformatting Files; Multi-pass Output; Sorting on Totals; Internal Functions. |
| |
Course# 310-D: Advanced PROC |
Benefits: | This course helps the student understand existing PROCs and how to make changes, as well as write new PROCs that utilize advanced commands. |
Audience: | All advanced users, programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #135-D |
Topics Covered: | Covered: Review of the Four Buffers; Using the STACK; Resetting Buffers; Terminal Control and Visual Effects; Looping and Iteration; Inter-PROC linkage; Subroutines and GOtos; Structured PROC Programming; Debugging Techniques; Interfacing with PICK/BASIC; Step Checkpointing/Debugging. |
| |
Course# 320-D: Advanced Programming |
Benefits: | Learn "what goes in inside the system" and how to take full advantage of the features and structures of the language. The results: less programmer time spent for more productive programming and more efficient run-time. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #235-D |
Topics Covered: | Structured Analysis, Design and Coding; Program Ergonomics; Operating System Structure and Internals; Virtual Memory Considerations: Performance and Efficiency Studies; Benchmarks and Performance Enhancements; File Cross Referencing: Inversions, B-trees, Soundexing; Interface with Other System Processors and External Devices; Advanced Coding Techniques; Time-Saving Shortcuts. |
| |
Course# 330-D: Advanced Programming Workshop |
Benefits: | Get answers and solutions to your own questions and projects by bringing them to class and working on them one-on-one with the instructor. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #320-D |
Topics Covered: | Each student brings in his/her own topics. |
| |
Pick Courses |
|
Compatibility: All versions of Pick, including Mentor, MOE, Ultimate, Reality, Reality-X, mvBase, mvPRO, mvEnterprise, R-91, Power 95, UniVision |
|
Course# 100-P: Introduction to Pick |
Benefits: | Understand the major features of this powerful database |
Audience: | Anyone who needs an overall understanding of Pick |
Method: | Lecture |
Length: | Half day |
Pre-requisites: | None |
Topics Covered: | The History of Pick; Terminology; Benefits and Features; System Architecture: Hardware, Firmware, and Software; The System Processors; Data Hierarchy and Organization; System Provided Utilities and Data; Introduction to ACCESS, Dictionaries, and PROC. |
|
Course# 115-P: In-Depth ACCESS (Info/Access, Recall, etc) |
Benefits: | Gain a working knowledge of the report writer language, and to recognize the power of the Data Dictionary. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 2 Days |
Pre-requisites: | None |
Topics Covered: | Overview of the Database Hierarchy; Files and Items; ACCESS Sentence Structure; Verbs; Filenames; Output Specifications; Item Lists; Selection Criteria; Sort Keys; Modifiers; Options; Finding and Understanding Dictionaries: Dictionary Type; Attribute Number; Column Heading; Conversions; Correlatives; Justification; and Column Width. |
| |
Course# 135-P: Pick Fundamentals |
Benefits: | Gain a comprehensive working knowledge of the system; learn how to harness its inherent power, and light day-to-day administration. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | None |
Topics Covered: | All those in course #100, plus: System and File Structure; Database Fundamentals; TCL Commands and Utilities; Creating Accounts, Files, and Dictionaries; The System Editor; Data Retrieval Using ACCESS; Data Manipulation: Dictionaries, Conversions/Correlatives; Sorting; Control Breaks and Totals; Modifiers; List Processing; The PROC Language; Saving Report Sentences; Creating Menus; Architecture; Start-up and Shut-down; Printer Management: the Spooler; Backups and Restores; Performance: File Sizing Techniques. |
| |
Course# 235-P: Structured Programming in Pick |
Benefits: | Learn how to effectively use this language for all aspects of programming tasks, using structured techniques. |
Audience: | All programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #135 |
Topics Covered: | History and Features of PICK/BASIC; Source and Object Code; Compile, Run, and Catalog; Program Variables, Constants, and Expressions; Input and Output Statements; Conditional and Loop Statements; Project Analysis, Design, and Specification; Software Design/Maintenance Considerations; PICK/BASIC Statements and Directives; Structured BASIC Programming; Human Design Factors; Interface with Other System Processors; Intrinsic Statements; Debugger Techniques; Conditional Statements; Data Verification; Screen I/O; File I/O; Transaction Processing; Batch Processing; Report Programs; Character Masking; Headings and Footings. |
| |
Course# 300-P: Advanced ACCESS (Info/Access, Recall, etc.) |
Benefits: | Learn advanced techniques and commands to gather the specific data that suits your needs more closely, more accurately, and more quickly without relying on outside assistance. |
Audience: | All advanced users, administrators, managers, executives, programmers, analysts, operators, etc. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Review of ACCESS, Dictionaries, and Internal Timings; Advanced Conversions/Correlatives; Processing Sequence: The F-Correlative; "IF-THEN-ELSE" A-Correlatives; Multiple Conversions and Correlatives; Multi-line Output Within a Column; Special Multi-Value Handling: Explosion, Print Limiting, Controlling/ Dependencies; Conditional/Bucket Processing; Average/Percent Totalling; Invisible Fields; Comparing Attributes; Reformatting Files; Multi-pass Output; Sorting on Totals; Internal Functions. |
| |
Course# 310-P: Advanced PROC |
Benefits: | This course helps the student understand existing PROCs and how to make changes, as well as write new PROCs that utilize advanced commands. |
Audience: | All advanced users, programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #135 |
Topics Covered: | Covered: Review of the Four Buffers; Using the STACK; Resetting Buffers; Terminal Control and Visual Effects; Looping and Iteration; Inter-PROC linkage; Subroutines and GOtos; Structured PROC Programming; Debugging Techniques; Interfacing with PICK/BASIC; Step Checkpointing/Debugging. |
| |
Course# 320-P: Advanced Programming |
Benefits: | Learn "what goes in inside the system" and how to take full advantage of the features and structures of the language. The results: less programmer time spent for more productive programming and more efficient run-time. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #235 |
Topics Covered: | Structured Analysis, Design and Coding; Program Ergonomics; Operating System Structure and Internals; Virtual Memory Considerations: Performance and Efficiency Studies; Benchmarks and Performance Enhancements; File Cross Referencing: Inversions, B-trees, Soundexing; Interface with Other System Processors and External Devices; Advanced Coding Techniques; Time-Saving Shortcuts. |
| |
Course# 330-P: Advanced Programming Workshop |
Benefits: | Get answers and solutions to your own questions and projects by bringing them to class and working on them one-on-one with the instructor. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #320 |
Topics Covered: | Each student brings in his/her own topics. |
| |
jBase Courses |
|
Compatibility: All versions of jBase |
|
Course# 100-J: Introduction to jBase |
Benefits: | Understand the major features of this powerful database |
Audience: | Anyone who needs an overall understanding of jBase |
Method: | Lecture |
Length: | Half day |
Pre-requisites: | None |
Topics Covered: | Terminology; Benefits and Features; System Architecture: Hardware, Firmware, and Software; The System Processors; Data Hierarchy and Organization; System Provided Utilities and Data; Introduction to ACCESS, Dictionaries, and PROC. |
|
Course# 115-J: In-Depth Query |
Benefits: | Gain a working knowledge of the report writer language, and to recognize the power of the Data Dictionary. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 2 Days |
Pre-requisites: | None |
Topics Covered: | Overview of the Database Hierarchy; Files and Items; ACCESS Sentence Structure; Verbs; Filenames; Output Specifications; Item Lists; Selection Criteria; Sort Keys; Modifiers; Options; Finding and Understanding Dictionaries: Dictionary Type; Attribute Number; Column Heading; Conversions; Correlatives; Justification; and Column Width. |
| |
Course# 135-J: jBase Fundamentals |
Benefits: | Gain a comprehensive working knowledge of the system; learn how to harness its inherent power, and light day-to-day administration. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | None |
Topics Covered: | All those in course #100, plus: System and File Structure; Database Fundamentals; TCL Commands and Utilities; Creating Accounts, Files, and Dictionaries; The System Editor; Data Retrieval Using ACCESS; Data Manipulation: Dictionaries, Conversions/Correlatives; Sorting; Control Breaks and Totals; Modifiers; List Processing; The PROC Language; Saving Report Sentences; Creating Menus; Architecture; Start-up and Shut-down; Printer Management: the Spooler; Backups and Restores; Performance: File Sizing Techniques. |
| |
Course# 235-J: Structured Programming in jBasic |
Benefits: | Learn how to effectively use this language for all aspects of programming tasks, using structured techniques. |
Audience: | All programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Features of jBASIC; Source and Object Code; Compile, Run, and Catalog; Program Variables, Constants, and Expressions; Input and Output Statements; Conditional and Loop Statements; Project Analysis, Design, and Specification; Software Design/Maintenance Considerations; PICK/BASIC Statements and Directives; Structured BASIC Programming; Human Design Factors; Interface with Other System Processors; Intrinsic Statements; Debugger Techniques; Conditional Statements; Data Verification; Screen I/O; File I/O; Transaction Processing; Batch Processing; Report Programs; Character Masking; Headings and Footings. |
| |
Course# 300-J: Advanced Query |
Benefits: | Learn advanced techniques and commands to gather the specific data that suits your needs more closely, more accurately, and more quickly without relying on outside assistance. |
Audience: | All advanced users, administrators, managers, executives, programmers, analysts, operators, etc. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Review of Query, Dictionaries, and Internal Timings; Advanced Conversions/Correlatives; Processing Sequence: The F-Correlative; "IF-THEN-ELSE" A-Correlatives; Multiple Conversions and Correlatives; Multi-line Output Within a Column; Special Multi-Value Handling: Explosion, Print Limiting, Controlling/ Dependencies; Conditional/Bucket Processing; Average/Percent Totalling; Invisible Fields; Comparing Attributes; Reformatting Files; Multi-pass Output; Sorting on Totals; Internal Functions. |
| |
Course# 310-J: Advanced PROC |
Benefits: | This course helps the student understand existing PROCs and how to make changes, as well as write new PROCs that utilize advanced commands. |
Audience: | All advanced users, programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #135 |
Topics Covered: | Covered: Review of the Four Buffers; Using the STACK; Resetting Buffers; Terminal Control and Visual Effects; Looping and Iteration; Inter-PROC linkage; Subroutines and GOtos; Structured PROC Programming; Debugging Techniques; Interfacing with jBASIC; Step Checkpointing/Debugging. |
| |
Course# 320-J: Advanced Programming |
Benefits: | Learn "what goes in inside the system" and how to take full advantage of the features and structures of the language. The results: less programmer time spent for more productive programming and more efficient run-time. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #235 |
Topics Covered: | Structured Analysis, Design and Coding; Program Ergonomics; Operating System Structure and Internals; Virtual Memory Considerations: Performance and Efficiency Studies; Benchmarks and Performance Enhancements; File Cross Referencing: Inversions, B-trees, Soundexing; Interface with Other System Processors and External Devices; Advanced Coding Techniques; Time-Saving Shortcuts. |
| |
Course# 330-J: Advanced Programming Workshop |
Benefits: | Get answers and solutions to your own questions and projects by bringing them to class and working on them one-on-one with the instructor. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #320 |
Topics Covered: | Each student brings in his/her own topics. |
| |
Caché Courses |
|
Compatibility: All versions of Caché |
|
Course# 100-C: Introduction to Caché |
Benefits: | Understand the major features of this powerful database |
Audience: | Anyone who needs an overall understanding of Caché |
Method: | Lecture |
Length: | Half day |
Pre-requisites: | None |
Topics Covered: | Terminology; Benefits and Features; System Architecture: Hardware, Firmware, and Software; The System Processors; Data Hierarchy and Organization; System Provided Utilities and Data; Introduction to ACCESS, Dictionaries, and PROC. |
|
Course# 115-C: In-Depth Query |
Benefits: | Gain a working knowledge of the report writer language, and to recognize the power of the Data Dictionary. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 2 Days |
Pre-requisites: | None |
Topics Covered: | Overview of the Database Hierarchy; Files and Items; ACCESS Sentence Structure; Verbs; Filenames; Output Specifications; Item Lists; Selection Criteria; Sort Keys; Modifiers; Options; Finding and Understanding Dictionaries: Dictionary Type; Attribute Number; Column Heading; Conversions; Correlatives; Justification; and Column Width. |
| |
Course# 135-C: Caché Fundamentals |
Benefits: | Gain a comprehensive working knowledge of the system; learn how to harness its inherent power, and light day-to-day administration. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | None |
Topics Covered: | All those in course #100, plus: System and File Structure; Database Fundamentals; TCL Commands and Utilities; Creating Accounts, Files, and Dictionaries; The System Editor; Data Retrieval Using ACCESS; Data Manipulation: Dictionaries, Conversions/Correlatives; Sorting; Control Breaks and Totals; Modifiers; List Processing; The PROC Language; Saving Report Sentences; Creating Menus; Architecture; Start-up and Shut-down; Printer Management: the Spooler; Backups and Restores; Performance: File Sizing Techniques. |
| |
Course# 235-C: Structured Programming in CachéBASIC |
Benefits: | Learn how to effectively use this language for all aspects of programming tasks, using structured techniques. |
Audience: | All programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Features of CachéBASIC; Source and Object Code; Compile, Run, and Catalog; Program Variables, Constants, and Expressions; Input and Output Statements; Conditional and Loop Statements; Project Analysis, Design, and Specification; Software Design/Maintenance Considerations; PICK/BASIC Statements and Directives; Structured BASIC Programming; Human Design Factors; Interface with Other System Processors; Intrinsic Statements; Debugger Techniques; Conditional Statements; Data Verification; Screen I/O; File I/O; Transaction Processing; Batch Processing; Report Programs; Character Masking; Headings and Footings. |
| |
Course# 300-C: Advanced Query |
Benefits: | Learn advanced techniques and commands to gather the specific data that suits your needs more closely, more accurately, and more quickly without relying on outside assistance. |
Audience: | All advanced users, administrators, managers, executives, programmers, analysts, operators, etc. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Review of Query, Dictionaries, and Internal Timings; Advanced Conversions/Correlatives; Processing Sequence: The F-Correlative; "IF-THEN-ELSE" A-Correlatives; Multiple Conversions and Correlatives; Multi-line Output Within a Column; Special Multi-Value Handling: Explosion, Print Limiting, Controlling/ Dependencies; Conditional/Bucket Processing; Average/Percent Totalling; Invisible Fields; Comparing Attributes; Reformatting Files; Multi-pass Output; Sorting on Totals; Internal Functions. |
| |
Course# 310-C: Advanced PROC |
Benefits: | This course helps the student understand existing PROCs and how to make changes, as well as write new PROCs that utilize advanced commands. |
Audience: | All advanced users, programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #135 |
Topics Covered: | Covered: Review of the Four Buffers; Using the STACK; Resetting Buffers; Terminal Control and Visual Effects; Looping and Iteration; Inter-PROC linkage; Subroutines and GOtos; Structured PROC Programming; Debugging Techniques; Interfacing with jBASIC; Step Checkpointing/Debugging. |
| |
Course# 320-C: Advanced Programming |
Benefits: | Learn "what goes in inside the system" and how to take full advantage of the features and structures of the language. The results: less programmer time spent for more productive programming and more efficient run-time. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #235 |
Topics Covered: | Structured Analysis, Design and Coding; Program Ergonomics; Operating System Structure and Internals; Virtual Memory Considerations: Performance and Efficiency Studies; Benchmarks and Performance Enhancements; File Cross Referencing: Inversions, B-trees, Soundexing; Interface with Other System Processors and External Devices; Advanced Coding Techniques; Time-Saving Shortcuts. |
| |
Course# 330-C: Advanced Programming Workshop |
Benefits: | Get answers and solutions to your own questions and projects by bringing them to class and working on them one-on-one with the instructor. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #320 |
Topics Covered: | Each student brings in his/her own topics. |
| |
UniVerse Courses |
|
Compatibility: All versions of UniVerse |
|
Course# 100-V: Introduction to UniVerse |
Benefits: | Understand the major features of this powerful database |
Audience: | Anyone who needs an overall understanding of UniVerse |
Method: | Lecture |
Length: | Half day |
Pre-requisites: | None |
Topics Covered: | Terminology; Benefits and Features; System Architecture: Hardware, Firmware, and Software; The System Processors; Data Hierarchy and Organization; System Provided Utilities and Data; Introduction to reTrieve, Dictionaries, and PROVERB. |
|
Course# 115-V: In-Depth reTrieve |
Benefits: | Gain a working knowledge of the report writer language, and to recognize the power of the Data Dictionary. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 2 Days |
Pre-requisites: | None |
Topics Covered: | Overview of the Database Hierarchy; Files and Items; reTrieve Sentence Structure; Verbs; Filenames; Output Specifications; Item Lists; Selection Criteria; Sort Keys; Modifiers; Options; Finding and Understanding Dictionaries: Dictionary Type; Attribute Number; Column Heading; Conversions; Correlatives; Justification; and Column Width. |
| |
Course# 135-V: UniVerse Fundamentals |
Benefits: | Gain a comprehensive working knowledge of the system; learn how to harness its inherent power, and light day-to-day administration. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | None |
Topics Covered: | All those in course #100, plus: System and File Structure; Database Fundamentals; TCL Commands and Utilities; Creating Accounts, Files, and Dictionaries; The System Editor; Data Retrieval Using ACCESS; Data Manipulation: Dictionaries, Conversions/Correlatives; Sorting; Control Breaks and Totals; Modifiers; List Processing; The PROC Language; Saving Report Sentences; Creating Menus; Architecture; Start-up and Shut-down; Printer Management: the Spooler; Backups and Restores; Performance: File Sizing Techniques. |
| |
Course# 235-V: Structured Programming in UniVerseBASIC |
Benefits: | Learn how to effectively use this language for all aspects of programming tasks, using structured techniques. |
Audience: | All programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Features of UniVerseBASIC; Source and Object Code; Compile, Run, and Catalog; Program Variables, Constants, and Expressions; Input and Output Statements; Conditional and Loop Statements; Project Analysis, Design, and Specification; Software Design/Maintenance Considerations; PICK/BASIC Statements and Directives; Structured BASIC Programming; Human Design Factors; Interface with Other System Processors; Intrinsic Statements; Debugger Techniques; Conditional Statements; Data Verification; Screen I/O; File I/O; Transaction Processing; Batch Processing; Report Programs; Character Masking; Headings and Footings. |
| |
Course# 300-V: Advanced reTrieve |
Benefits: | Learn advanced techniques and commands to gather the specific data that suits your needs more closely, more accurately, and more quickly without relying on outside assistance. |
Audience: | All advanced users, administrators, managers, executives, programmers, analysts, operators, etc. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Review of reTrieve, Dictionaries, and Internal Timings; Advanced Conversions/Correlatives; Processing Sequence: The F-Correlative; "IF-THEN-ELSE" A-Correlatives; Multiple Conversions and Correlatives; Multi-line Output Within a Column; Special Multi-Value Handling: Explosion, Print Limiting, Controlling/ Dependencies; Conditional/Bucket Processing; Average/Percent Totalling; Invisible Fields; Comparing Attributes; Reformatting Files; Multi-pass Output; Sorting on Totals; Internal Functions. |
| |
Course# 310-V: Advanced PROVERB |
Benefits: | This course helps the student understand existing PROCs and how to make changes, as well as write new PROVERBs that utilize advanced commands. |
Audience: | All advanced users, programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #135 |
Topics Covered: | Covered: Review of the Four Buffers; Using the STACK; Resetting Buffers; Terminal Control and Visual Effects; Looping and Iteration; Inter-PROC linkage; Subroutines and GOtos; Structured PROC Programming; Debugging Techniques; Interfacing with jBASIC; Step Checkpointing/Debugging. |
| |
Course# 320-V: Advanced Programming |
Benefits: | Learn "what goes in inside the system" and how to take full advantage of the features and structures of the language. The results: less programmer time spent for more productive programming and more efficient run-time. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #235 |
Topics Covered: | Structured Analysis, Design and Coding; Program Ergonomics; Operating System Structure and Internals; Virtual Memory Considerations: Performance and Efficiency Studies; Benchmarks and Performance Enhancements; File Cross Referencing: Inversions, B-trees, Soundexing; Interface with Other System Processors and External Devices; Advanced Coding Techniques; Time-Saving Shortcuts. |
| |
Course# 330-V: Advanced Programming Workshop |
Benefits: | Get answers and solutions to your own questions and projects by bringing them to class and working on them one-on-one with the instructor. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #320 |
Topics Covered: | Each student brings in his/her own topics. |
| |
Course# 720-V: Migration to UniVerse from Pick |
Benefits: | Learn how to utilize, operate, and manage the UniVerse environment more quickly by highlighting the differences and the new features. |
Audience: | Users, programmers, analysts, operators, and systems staff who are familiar with the Pick system. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #235 |
Topics Covered: | Evolution and Architecture of UniVerse; New Files; File Structure Differences; VOC vs. MD Differences; the VI Editor; TCL Flavors; RETRIEVE Differences; Phrases, Sentences, and Paragraphs (PCL); Dictionary Differences; New Conversions/Correlatives; UniVerse/BASIC Differences; File Paths; System Provided Data; COMO Files; Incremental Saves; System Administration Shell; Interfacing with Unix; and more |
| |
UniData Courses |
|
Compatibility: All versions of UniData |
|
Course# 100-U: Introduction to UniData |
Benefits: | Understand the major features of this powerful database |
Audience: | Anyone who needs an overall understanding of UniData |
Method: | Lecture |
Length: | Half day |
Pre-requisites: | None |
Topics Covered: | Terminology; Benefits and Features; System Architecture: Hardware, Firmware, and Software; The System Processors; Data Hierarchy and Organization; System Provided Utilities and Data; Introduction to UniQuery, Dictionaries, and PROC. |
|
Course# 115-U: In-Depth UniQuery |
Benefits: | Gain a working knowledge of the report writer language, and to recognize the power of the Data Dictionary. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 2 Days |
Pre-requisites: | None |
Topics Covered: | Overview of the Database Hierarchy; Files and Items; reTrieve Sentence Structure; Verbs; Filenames; Output Specifications; Item Lists; Selection Criteria; Sort Keys; Modifiers; Options; Finding and Understanding Dictionaries: Dictionary Type; Attribute Number; Column Heading; Conversions; Correlatives; Justification; and Column Width. |
| |
Course# 135-U: UniDataFundamentals |
Benefits: | Gain a comprehensive working knowledge of the system; learn how to harness its inherent power, and light day-to-day administration. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | None |
Topics Covered: | All those in course #100, plus: System and File Structure; Database Fundamentals; TCL Commands and Utilities; Creating Accounts, Files, and Dictionaries; The System Editor; Data Retrieval Using UniQuery; Data Manipulation: Dictionaries, Conversions/Correlatives; Sorting; Control Breaks and Totals; Modifiers; List Processing; The PROC Language; Saving Report Sentences; Creating Menus; Architecture; Start-up and Shut-down; Printer Management: the Spooler; Backups and Restores; Performance: File Sizing Techniques. |
| |
Course# 235-U: Structured Programming in UniBASIC |
Benefits: | Learn how to effectively use this language for all aspects of programming tasks, using structured techniques. |
Audience: | All programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Features of UniBASIC; Source and Object Code; Compile, Run, and Catalog; Program Variables, Constants, and Expressions; Input and Output Statements; Conditional and Loop Statements; Project Analysis, Design, and Specification; Software Design/Maintenance Considerations; PICK/BASIC Statements and Directives; Structured BASIC Programming; Human Design Factors; Interface with Other System Processors; Intrinsic Statements; Debugger Techniques; Conditional Statements; Data Verification; Screen I/O; File I/O; Transaction Processing; Batch Processing; Report Programs; Character Masking; Headings and Footings. |
| |
Course# 300-U: Advanced UniQuery |
Benefits: | Learn advanced techniques and commands to gather the specific data that suits your needs more closely, more accurately, and more quickly without relying on outside assistance. |
Audience: | All advanced users, administrators, managers, executives, programmers, analysts, operators, etc. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #135 |
Topics Covered: | Review of UniQuery, Dictionaries, and Internal Timings; Advanced Conversions/Correlatives; Processing Sequence: The F-Correlative; "IF-THEN-ELSE" A-Correlatives; Multiple Conversions and Correlatives; Multi-line Output Within a Column; Special Multi-Value Handling: Explosion, Print Limiting, Controlling/ Dependencies; Conditional/Bucket Processing; Average/Percent Totalling; Invisible Fields; Comparing Attributes; Reformatting Files; Multi-pass Output; Sorting on Totals; Internal Functions. |
| |
Course# 310-U: Advanced PROC |
Benefits: | This course helps the student understand existing PROCs and how to make changes, as well as write new PROVERBs that utilize advanced commands. |
Audience: | All advanced users, programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #135 |
Topics Covered: | Covered: Review of the Four Buffers; Using the STACK; Resetting Buffers; Terminal Control and Visual Effects; Looping and Iteration; Inter-PROC linkage; Subroutines and GOtos; Structured PROC Programming; Debugging Techniques; Interfacing with jBASIC; Step Checkpointing/Debugging. |
| |
Course# 320-U: Advanced Programming |
Benefits: | Learn "what goes in inside the system" and how to take full advantage of the features and structures of the language. The results: less programmer time spent for more productive programming and more efficient run-time. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 3 Days |
Pre-requisites: | Course #235 |
Topics Covered: | Structured Analysis, Design and Coding; Program Ergonomics; Operating System Structure and Internals; Virtual Memory Considerations: Performance and Efficiency Studies; Benchmarks and Performance Enhancements; File Cross Referencing: Inversions, B-trees, Soundexing; Interface with Other System Processors and External Devices; Advanced Coding Techniques; Time-Saving Shortcuts. |
| |
Course# 330-U: Advanced Programming Workshop |
Benefits: | Get answers and solutions to your own questions and projects by bringing them to class and working on them one-on-one with the instructor. |
Audience: | All advanced programmers, analysts, and systems staff. |
Method: | Lecture and Hands-on |
Length: | 1 Day |
Pre-requisites: | Course #320 |
Topics Covered: | Each student brings in his/her own topics. |
| |
Course# 720-U: Migration to UniData from Pick |
Benefits: | Learn how to utilize, operate, and manage the UniData environment more quickly by highlighting the differences and the new features. |
Audience: | Users, programmers, analysts, operators, and systems staff who are familiar with the Pick system. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | Course #235 |
Topics Covered: | The Conversion Process; Various Topics From Courses 120-U, 140-U, 200-U, plus: Architectural Differences; File structure Differences; VOC vs. MD Files: ED vs. AE and vi; ECL Differences; UniQuery Differences; Dictionary Differences; Phrases and Sentences; COMO Files; PCL; UEntry, and UReport; UniBasic Differences and New Features; System Administration under UniData. |
|
| |
Unix Courses |
|
Compatibility: Most versions of Unix, AIX, and Linux |
|
Course# 100-X: Introduction to Unix |
Benefits: | Understand the major features of this powerful Operating System |
Audience: | Anyone who needs a brief overview of Unix |
Method: | Lecture |
Length: | Half day |
Pre-requisites: | None |
Topics Covered: | The History of Unix; Benefits and Features; Comparison to other systems; Major system components; Unix file structure; Shell commands. |
|
Course# 135-X: Unix Fundamentals |
Benefits: | Gain a comprehensive working knowledge of the system; learn how to harness its inherent power, and light day-to-day administration. |
Audience: | All users, administrators, managers, executives, programmers, analysts, operators, systems staff, etc. |
Method: | Lecture and Hands-on |
Length: | 5 Days |
Pre-requisites: | None |
Topics Covered: | All topics covered in course #100-X, plus; Files and Directories; Logins; Security; Using the vi Editor; File manipulation; Cut; Sort; Pagination; Data extraction; Output formatting; I/O manipulation; I/O commands and redirection; Piping; Shell scripts; Managing Processes; Device assignment and usage. |
|
|