Advanced Finance and Operations Programming

Module 1: Data Processing Tasks

How to create a new number sequence

Renaming the primary key

Using a normal table as a temporary table

Copying a record

Building a query object at run time

How to use a macro in a SQL statement

Executing a direct SQL statement

Improving data consistency checks

Using the date effectiveness feature

Module 2: Form Creation Dynamically using Code

Form manipulation and creation

Creating dialogs using the RunBase framework

Handling the dialog event

Creating dialogs using the SysOperation framework

Building a dynamic form

Adding a form splitter

Creating a modal form

Modifying multiple forms dynamically

Storing the last form values

Using a Tree control

Adding the View details link

Module 3: Forms and Data

Using a number sequence handler

Creating a custom filter control

Creating a custom instant search filter

Building a selected/available list

Creating a wizard

Processing multiple records

Colouring records

Adding an image to record

Module 3 (continued): Lookups

Creating an automatic lookup

Creating a lookup dynamically

Using a form to build a lookup

Building a tree lookup

Displaying a list of custom options

Displaying custom options in another way

Building a lookup based on the record description

Building a browse for folder lookup

Creating a colour picker lookup

Module 4: Intro to Data entities

Building a data entity with multiple data sources

Data packages

Data migration

Importing data

Module 5: Techniques to improve the efficiency of Development and improve performance

How to use Extensions

Caching a display method

ow to Calculate code execution time

Enhancing insert, update, and delete operations by processing multiple records per trip

Writing efficient SQL statements in

Using an event handler

Creating a Delegate method for inter package communication.

Module 6: Introduction to Office Integration

Configuring and using an Excel Data Connector

The use of the Workbook Designer

Using the Export API

Custom lookup creation in excel

Managing Documents

Creating a Word document with repeated elements

Module 7: Introduction to Power BI integration

Configuring Power BI

Consuming data in Excel

Integrating Excel with Power BI

Developing interactive dashboards

Embedding Power BI visuals

Module 8: Integration with Azure Services

Authenticating a native client app

Creating a custom service

Consuming custom services in JSON

Consuming custom services in SOAP

Consuming OData services

Consuming external web services