Introduction To AL Programming In Dynamics 365 Business Central Training - Philippines

Introduction to AL Programming in Dynamics 365 Business Central Training Course Outline

Module 1: Modern Development Environment

• Getting Started with Visual Studio Code – Overview
• Introduction to Visual Studio Code
• Installing AL Support in Visual Studio Code
• Logical Database and Its Objects
• Extensions
• Creating a New Extension
• JSON Configuration Files
• Build and Deploy an Extension
• Using Code Snippets
• Properties and Triggers
• Object Properties and Triggers
• Git and Team Development Features – Overview

Module 2: Tables

• Using Code Snippets
• Setting Properties, Keys, and Table Relations
• Lab-Create a Table
• What Is a Table?
• Table Properties
• Field Properties
• Table Relations
• Regular Table Relations
• Filtered and Conditional Table Relations
• Keys
• Field Group: DropDown and Brick
• Calculated Fields
• Creating a Table

Module 3: Table Extension

• What Is a Table Extension?
• Table Extension Properties
• Creating a Table Extension
• Using Code Snippets
• Lab-Create a Table Extension

Module 4: Pages

• What Is a Page?
• Page Types
• Page Description
• What are Page Properties?
• Are Controls?
• Control Areas
• Control Types and Subtypes
• Group and Repeater, Cue Group and Fixed Layout
• Linking Pages and Page Parts
• Creating Pages
• What are Control Properties?
• Are Actions?
• Page Actions and Role Center Actions
• Action Properties
• Lab
  • Create a Card Page
  • Create a List Page

Module 5: Page Extensions

• What Is a Page Extension?
• Page Extension Properties
• Creating a Page Extension
• Using Code Snippets
• Lab-Create a Page Extension

Module 6: Entitlements and Permission Sets

• Get Started with Entitlements and Permissions Create
• Create Entitlements and Permission Sets
• Override Entitlements with Inherent Permissions

Module 7: Basics of AL Programming

• Language
• Assignment and Functions
• Expressions (Operators)
• Options
• Enums and Enums Extension
• Work with Collections
• Frequently Used AL Procedures
• Conditional Statements
• Repetitive Statements
• Error Handling
• Publish and Subscribe to Events
• Lab-Basics AL Operator

Module 8: Built-in Functions in Business Central

• String Functions
• Numeric
• Round
• Abs and Power Functions
• Array Functions
• List Functions
• System Functions

Module 9: Debugging in Business Central

• Dialog Function Debugging Techniques
• Debugging with MESSAGE and CONFIRM
• Debugging with DIALOG
• Debugging with Text Output
• Debugging with ERROR
• Business Central Debugger
• Activating the Debugger
• Debugger Windows
• SnapShot Debugging
• Lab-Debugging in Visual Studio Code

Module 10: Files

• Working with the File Object
• Working with the TempBlob Object
• Streaming
• File Management - Reading and Writing
• Files
• File Management - Working with Streams and the Tempblob Table
• Lab-Reading and Writing Files

Module 11: XMLPorts

• What Is an XMLPort?
• XMLPort Properties and Triggers
• Designing XMLPorts
• Creating XMLPorts
• Working with Plain Text
• Using XMLPorts in AL Code
• Lab
  • Create an XMLPort to Export XML Data
  • Create an XMLport to Export Variable Text

Module 12: Queries

• Query Design
• Aggregating and Ordering Data and Date Methods
• Creating a Query Example
• Accessing Queries from AL
• Advanced Query Concepts
• Lab
  • Using a Query for a Chart
  • Using Queries in AL

Module 13: Reporting

• Report Components
• Report Design Process
• Design the Data Model Report and Data Item Properties Data Model of a Report
• Create an RDL Layout Report Overview
• Create an RDL Layout Report
• Grouping and Totaling Overview
• Report Triggers and Functions
• Report Triggers Flow
• Processing Only Overview
• Word Report Layouts Overview
• Lab
  • Creating a Basic Report
  • Creating a Processing Only Report

Module 14: Power BI

• Enabling Your Business Data for Power BI Overview
• Using Microsoft Dynamics 365 Business Central as a Power BI Data
• Lab- Use Microsoft Dynamics 365 Business Central as a Power BI Data Source