Advanced PowerBuilder for Professionals picks up where PowerBuilder Essentials course leaves off, providing seventeen, in-depth topics spanning the breadth and depth of the PowerBuilder Classic platform. Each topic is presented in-depth and is accompanied by supporting hands-on lab exercises that guide a developer in honing their skills. The course includes lab exercises support versions 12.0 and 12.5, 12.6 Appeon PB 2017 and Appeon PB 2019R2.

Along with helping developers master language constructs, APIs and tooling, the course demonstrates best practice approaches to PowerBuilder software development in the context of a real-world application. Developers will get answers to the Why and When questions in addition to the usual How and What covered by most training courses.

PowerBuilder Training Prerequisites

This intensive hands-on course is designed for application programmers responsible for the design and implementation of client/server applications using PowerBuilder 2017/2019

PowerBuilder Training Course Duration

5 days. You can pick and choose topics from and create a custom shorter course

Powerbuilder Training Course Outline

Advanced PowerBuilder for Professionals goes beyond the core concepts introduced in the PowerBuilder Essentials course with these modules:

1. Custom Class User Objects: Future-proofing your logic for maintainability, reuse and portability
2. User Objects: Building reusable and dynamic GUI and framework code elements
3. Object Orientation: Coding for reuse, efficiency and maintainability
4. Error and Exceptions: Writing robust handlers using built-in platform APIs
5. MDI Presentation Style: Enhancing the user experience through effective, consistent user interfaces
6. Stored Procedure DataWindow Objects: Accessing and updating the database in a secure, high performance way
7. DataWindow Buffer Access APIs: Acquiring an arsenal of tools for interacting with client-side data sets
8. DataWindow Object Expression Language: Creating dynamic, informative and responsive data presentations
9. Dynamic DataWindow Expression API: Adding runtime modifiable behaviors to DataWindow presentations
10. Child DataWindow Objects: Achieving enhanced DataWindow data entry and providing effective data presentations in a pure PowerBuilder way
11. Providing a rich user experience using a wide range of techniques and complex controls, including
    1. Tab folder paradigm
    2. TreeView navigation
12. Supporting intuitive user gestures by providing Drag and Drop navigation
13. Improving application performance by Adding multithreaded background processing and polling using window timers and timing objects
14. Using DataWindow technology to provide an end user dynamic report creation tool
15. Using dynamic Libraries to store and load reports coupled with DataWindow synchronization for passing data between application tiers
16. Improving DataWindow and Database performance by Controlling DB driver behavior and limiting transaction scope; performance tuning database calls; monitoring generated SQL using DB Tracing and SQL monitoring and controlling DataWindow SQL generation by manipulating item status flags
17. Extending your application's reach by Using XML coupled with the power of DataWindow technology to transfer data between applications