AdvPL Training
Progressive training: from language foundations to MVC, SQL, integrations, and Protheus automation.
What AdvPL is and where it is used
Learn AdvPL through a planned 52-lesson path with practice, targeted reviews, and projects.
Start lesson →Sign in with Google or Microsoft to synchronize your progress, scores, and achievements. Without signing in, you can still study with progress saved in this browser.
Complete learning plan
The editorial plan organizes 52 lessons into four levels. Every lesson will be published in all three languages with examples, exercises, a quiz, and targeted review.
Level 1 — AdvPL Foundations
14 lessons
AVAILABLE
Level 1 — AdvPL Foundations
14 lessons
- What AdvPL is and where it is used ✓
- Preparing the development environment — PLANNED
- Structure of a .prw source file — PLANNED
- Includes and compiler directives — PLANNED
- Variables and naming conventions — PLANNED
- Data types — PLANNED
- Local, Static, Private, and Public scopes — PLANNED
- Mathematical, relational, and logical operators — PLANNED
- Strings and manipulation functions — PLANNED
- If...Else...EndIf structures — PLANNED
- Do Case...EndCase structure — PLANNED
- While...EndDo structure — PLANNED
- For...Next structure ✓
- Arrays: AAdd, AScan, ASort, and Len — PLANNED
Level project: An interactive program that receives data, validates information, works with arrays, and displays a result.
Level 2 — Protheus Essentials
12 lessons
PLANNED
Level 2 — Protheus Essentials
12 lessons
- Functions, parameters, and return values — PLANNED
- Passing by value and by reference — PLANNED
- Code blocks — PLANNED
- Macro substitution — PLANNED
- Structure of Protheus tables — PLANNED
- Aliases, work areas, and records — PLANNED
- Preserving work areas with GetArea and RestArea — PLANNED
- Navigation with DbGoTop, DbSkip, Eof, and DbGoTo — PLANNED
- Orders and searches with DbSetOrder, DbSeek, and MsSeek — PLANNED
- Insert and update with RecLock and MsUnlock — PLANNED
- Logical deletion and record control — PLANNED
- SX6 parameters, GetMV, PutMV, and SuperGetMV — PLANNED
Level project: A record query and maintenance routine with correct environment preservation.
Level 3 — Intermediate Development
12 lessons
PLANNED
Level 3 — Intermediate Development
12 lessons
- Data dictionary: tables, fields, and indexes — PLANNED
- Validations, triggers, and SX1 questions — PLANNED
- Entry points: concepts and precautions — PLANNED
- Creating a class in AdvPL — PLANNED
- Properties, methods, and encapsulation — PLANNED
- Essential visual components — PLANNED
- Dialogs, SAY, GET, buttons, and panels — PLANNED
- Browses: concepts and alternatives — PLANNED
- FWMBrowse — PLANNED
- Processing with progress indicators — PLANNED
- FWGridProcess — PLANNED
- Text file handling — PLANNED
Level project: A visual routine with parameters, browse, processing, and result logging.
Level 4 — Advanced Development
14 lessons
PLANNED
Level 4 — Advanced Development
14 lessons
- SQL concepts in Protheus — PLANNED
- TopConn and TCQuery — PLANNED
- Returned types and TCSetField — PLANNED
- Embedded SQL — PLANNED
- Temporary tables and indexes — PLANNED
- Transactions and failure handling — PLANNED
- Automatic execution with MsExecAuto — PLANNED
- Introduction to MVC in Protheus — PLANNED
- Models, forms, and grids in MVC — PLANNED
- MVC entry points — PLANNED
- REST services in AdvPL — PLANNED
- Consuming APIs and handling JSON — PLANNED
- Reports and spreadsheet generation — PLANNED
- Best practices, performance, logs, and security — PLANNED
Level project: An integrated application with MVC, SQL queries, processing, logging, and an external service.