Core PowerBuilder Courses

Type

Days

PowerBuilder Deep Dive Series

Type

Days

DataWindow Deep Dive Series

Type

Days

Development Process and Practices Series

Type

Days

PowerBuilder Jump Start

5 days, € 2’975.-

Purpose

This fast paced course introduces you to PowerBuilder’s programming language, the unique DataWindow technology for data processing, and the IDE. After this course you have sufficient all-round understanding of PowerBuilder and DataWindow technology to participate in a PowerBuilder based development project.

Main Learning Points

• Develop and debug code effectively using the PowerBuilder IDE
• General features of the PowerScript language including its object-oriented and event-driven characteristics
• Access data stored in SQL databases
• The DataWindow technology’s concepts and practical usage for data presentation, editing, and processing including access to SQL databases
• Develop user interfaces using PowerBuilder and DataWindows

Prerequisites

• Experience developing in an object-oriented language (EX: C# or Java)
• Experience accessing data in a SQL database (EX: Microsoft or Oracle)

Developer’s Guide to DataWindow Technology

3 days, € 1’785.-

Purpose

This advanced course expands your knowledge of the DataWindow technology so that you can leverage all its benefits and lead less experienced developers. After this course you have a both broad and deep understanding of all major areas of the DataWindow technology.

Main Learning Points

• Internal structure of a DataWindow object
• Edit styles and validation process for data entry
• Retrieve and save data across different data sources
• Computed columns, fields, and properties
• Dynamic changes to a DataWindow object
• Exchanging data with external system
• Performance considerations

Prerequisites

• PowerBuilder Jump Start, Appeon-U’s PowerBuilder Fundamentals (online course), or similar
• 1-3 months of PowerBuilder programming

Object-Oriented PowerBuilder Development

3 days, € 1’785.-

Purpose

This advanced course expands your knowledge of PowerBuilder’s object-oriented features while introducing code quality concepts. After this course you should be able to maintain and extend object-oriented frameworks like PFC. You will also understand how your coding decisions impact code quality and developer productivity.

Main Learning Points

• PowerBuilder’s system class hierarchy
• Object-oriented features in PowerScript including encapsulation and inheritance
• Usage of service classes to build extensible components
• Code quality concepts like cohesion, coupling, and technical debt
• Performance considerations

Prerequisites

• PowerBuilder Jump Start, Appeon-U’s PowerBuilder Fundamentals (online course), or similar
• 1-3 months of PowerBuilder programming

Develop Service-Based Systems with PowerBuilder

2 days, € 1’190.-

Prerequisites

• Developer’s Guide to DataWindow Technology or similar
• Object-Oriented PowerBuilder Development or similar
• 6-12 months of PowerBuilder programming

PowerBuilder Internals

1 day, € 495.-

Purpose

This seminar is a behind-the-scenes tour of PowerBuilder’s source code characteristics, runtime behavior, and timing/performance considerations. It includes a rich set of guidelines and code samples. You learn to leverage this knowledge through guidelines and a rich set of code samples.

Main Learning Points

• Source code characteristics: Identifier rules, class definitions, system types, and .PBL/.PBD file structure
• Runtime behavior: Name resolution, object life-cycle, garbage collection, library lists, DataWindows dynamics
• Timing/performance: Timers, multi-threading, timeout handling, database transactions, concurrency, locking, caching techniques, and performance tuning.

• Source code characteristics: Identifier rules, class definitions, system types, and .PBL/.PBD file structure
• Runtime behavior: Name resolution, object life-cycle, garbage collection, library lists, DataWindows dynamics
• Timing/performance: Timers, multi-threading, timeout handling, database transactions, concurrency, locking, caching techniques, and performance tuning.

Prerequisites

• PowerBuilder Jump Start, Appeon-U’s PowerBuilder Fundamentals (online course), or similar
• 6-12 months of PowerBuilder programming

Advanced PowerScript Techniques

1 day, € 495.-

Purpose

This is a deep dive into the PowerScript language, object-oriented programming, and selected agile techniques in a PowerBuilder context. It also presents configuration options and runtime changes to application’s code.

Main Learning Points

• PowerScript language: Encapsulation features, conditional compilation, late binding, exceptions and error handling, database functionality, performance, multi-threading
• Object-oriented programming: Encapsulation, dependency injection, inheritance vs. composition, service classes, implementing interfaces, method chaining
• Agile techniques: feature flags, programming-by-intention, monolith vs. services, build automation
• Maintaining legacy applications: Migrate vs. stay, introducing new code styles

Prerequisites

• Knowledge of PB runtime behavior as in PowerBuilder Internals or similar
• 6-12 months of PowerBuilder programming

Advanced UI Development

1 day, € 495.-

Purpose

This seminar introduces you to PowerBuilder’s rich UI controls and implementation of several common user interaction patterns.

Main Learning Points

• Rich UI controls: List views, tree views, tab controls, images/multimedia, custom visual user objects, window types, rich text, OLE controls
• Common user interaction patterns: Hyperlinks, popup menus, windowing style (MDI vs. SDI vs. Docked), user messages (tooltips, status bars, message boxes), drag-and-drop, saving to PDF.

Prerequisites

• Experience writing user interfaces in PowerBuilder
• Understanding of user interaction principles in MS Windows.

App-to-App Integration

1 day, € 495.-

Purpose

This seminar introduces you to the various PowerBuilder techniques for configuration, app-to-app integration, data exchange, and user interaction across app boundaries.

Main Learning Points

• App configuration: Registry, config files
• App-to-app integration: .DLL files, .NET assemblies, web-services, OLE automation, command-line arguments and return codes
• Data exchange: Standards (XML, JSON, OData), file-based, databases
• User interaction: app-to-app events, hyperlinks PB-to-web/web-to-PB, cross-app drag-and-drop

Prerequisites

• Experience writing PowerBuilder applications or services
• Understanding of app-to-app integration concepts including data exchange

DataWindow Internals

1 day, € 495.-

DataWindow UI Features

1 day, € 495.-

DataWindow Data Processing Features

1 day, € 495.-

Data Exchange Using DataWindows and Pipelines

1 day, € 495.-

Version Control and Build Automation

1 day, € 495.-

Purpose

This seminar presents three individual topics within a single day: 1) PowerBuilder IDE’s productivity features, 2) Integrating PowerBuilder with version control, and 3) Build/deploy automation.

Main Learning Points

• IDE Productivity: code snippets, bookmarks, debugging, and workspace configuration
• Version control: Setup and use of both centralized and distributed version control, PB Native, Git (Visual Studio Team Services).
• Build/deploy automation: ORCAScript, command-line compiler, do-it-yourself tools

Prerequisites

• Experience using PowerBuilder’s IDE to test and deploy applications

Code Quality and Design Principles

1 day, € 495.-

Purpose

This seminar teaches you how to improve PowerBuilder code quality using well-known code metrics and design principles. It provides a platform for writing apps and components that are easier to develop, maintain, and extend. All code examples provide insight in a PowerBuilder context.

Main Learning Points

• Terminology, ex: Encapsulation, interfaces, coupling, cohesion.
• Code metrics and code smells
• Design principles (incl. GRASP) and clean code
• The SOLID code design principles and related package principles

Prerequisites

• Object-Oriented PowerBuilder Development or similar
• 6-12 months of PowerBuilder programming

Design Patterns and Practices

1 day, € 495.-

Purpose

This seminar introduces you to design patterns. It teaches you how to implement several common patterns in PowerBuilder despite PowerBuilder’s lack of interface objects.

Main Learning Points

• Code quality review, incl. the SOLID principles
• Inheritance vs. composition
• Design patterns overview
• Specific design patterns, ex: Adapter, Command, Façade, Factory, Proxy, and Strategy
• API design using Domain Specific Languages

Prerequisites

• Object-Oriented PowerBuilder Development or similar
• Code Quality and Design Principles or similar
• 6-12 months of PowerBuilder programming