Appeon PowerBuilder Training

 

PowerBuilder Training Course Overview

This training course is designed to progressively build knowledge and skills in Appeon PowerBuilder through three structured levels: Introduction, Intermediate, and Advanced. It can be delivered either via web meeting (online) or onsite (in-person), depending on organizational needs.

Delivery Options

  • Web Meeting (Online): Live virtual sessions with interactive elements such as Q&A, screen sharing, and collaborative exercises.
  • Onsite (In-Person): Face-to-face training with enhanced interaction, group activities, direct engagement. Topics will be tailored using customer’s infrastructure and test Database, thus writing code and building apps that can be readily delivered to production at the end of the training.

INTRODUCTION

Objective:
Provide participants with foundational knowledge and core concepts.

Content Includes:

  • Basic principles and terminology
  • Overview of key tools, processes, or frameworks
  • Simple practical examples or demonstrations

Outcome:
Participants gain a clear understanding of the fundamentals and are prepared to engage with more complex topics.

Topics:

A brief history of PowerBuilder

PB IDE

    • Code Editor
    • Workspace vs Solution
    • PB Event-driven programming
    • Window object and types
    • DB connection

DataWindow

    • Data sources
    • DB Retrieve/Update
    • Presentation styles
      • Tabular vs Grid
      • Freeform
      • Graph
      • Treeview
      • Crosstab
      • …and more
    • Static/Dynamic dataobject binding
    • Update clauses
    • Server-side vs client-side operations
    • Buffers
    • Computed fields
    • Master/Detail DW
    • DataStore
    • DropDown DW
    • GetChild
    • GetFullState
    • Dynamic DW
    • ShareData

OO programming in PB

    • Inheritance
    • Encapsulation
    • Polymorphism

PB project upgrade

    • Migration from older versions
    • Discontinued/Obsolete features

Development Support

    • Compiler
    • Debugger
    • Runtime
    • PBD vs DLL
    • Resource file
    • PBAutoBuild
    • Package Manager

User Objects

    • Menu
    • Visual vs non-Visual UO
    • Static/Dynamic creation
    • Shared Objects
      • Multi-threaded programming

INTERMEDIATE

Objective:
Develop practical skills and deepen understanding of the subject.

Content Includes:

  • Applied techniques and real-world scenarios
  • Hands-on exercises or case studies
  • Problem-solving approaches and best practices

Outcome:
Participants are able to apply concepts independently and handle common challenges.

Topics:

PowerClient Project

    • Application automatic delivery
    • App Launcher

PDF Support

    • PB Native PDF generation
    • Set PDF properties
    • Set user/master password
    • Restrict PDF content
    • PDF Builder
    • PDF Merge

Security

    • Data Encoding: HEX, Base64, Base32, URL
    • Data Encryption: Symmetry and Asymmetric
    • Data Hashing: MD5, SHA, HMAC
    • Data Compression and Extraction
    • DB Connection Encryptor

UI Themes

    • Apply builtin themes
      • Entire application vs specific objects
    • Custom Themes

RibbonBar

    • RB Builder
    • Event handling
    • Dynamic RB generation
    • Convert Menu to Ribbon

JSON manipulation

    • DW Export/Import to JSON
    • JSONParser
    • JSONGenerator
    • JSONPackage

XML manipulation

    • DW export/import to XML
    • PBDOM library

Cloud programming

    • Background knowledge
    • HTTP Protocol
      • OpenURL function
    • REST vs SOAP
    • JSON vs XML
    • HTTPClient object
      • Access Web URL
      • Access SOAP WS
      • Access REST API
    • RESTClient object

Application Techniques

    • .NET DLL Importer
    • SMTP Client
    • MDI TabbedView
    • DropDown Autocomplete and Filter
    • RichText Editor

Web Browser Control

    • A powerful Preview tool
    • Execute JS
    • Generate JS-aware Graphs
      • Apache ECharts

Source Control

    • GIT vs SVN
    • A practical scenario: GIT
      • Connect to Workspace
      • Add to Source Control
      • Commit, Push, Pull, Revert
      • Diff and Log
      • Branches
      • Merge
    • Resolve Conflicts

ADVANCED

Objective:
Master complex topics and achieve a high level of proficiency.

Content Includes:

  • Advanced methodologies and strategies
  • In-depth case studies and analysis
  • Custom scenarios tailored to participant needs

Outcome:
Participants are capable of tackling complex situations, optimizing performance, and making strategic decisions.

Topics:

PowerServer Project

    • Design Installable Cloud App (ICA)
    • Setup
    • Frontend and backend separation
    • DB connection pooling
    • Dynamic vs Static DB cache binding
    • Security

.NET Datastore Project

    • Build REST API in PB
    • C# DataModel
    • C# Datastore
    • Controller and Service Scaffolding
    • Swagger
    • Master HTTP Get, Post, Put, Ddelete
    • Design RESTful API
    • Remote API Deployment
      • WebDeploy
      • Docker

Extend the API

    • Secure with JWT
    • OAuth 2.0
    • Asynchronous programming
    • PowerScript to C# Generator
    • SnapObject ORM
      • SQLGenerator
      • SQLExecutor
    • .NET Datastore limitations
      • SQLModelMapper
      • Nested models
      • Understanding Transactions
      • Tracking DB changes