C/Side Introduction in Microsoft Dynamics NAV
DY-436(3 days)
C/Side Introduction in Microsoft Dynamics NAV
19.700 DKK
(excl. VAT)
Course calendar
Description
This instructor-led course focuses on the capabilities and features of the Microsoft Dynamics NAV Development Environment. It explains the basic development concepts in Microsoft Dynamics NAV, and provides an overview of the C/AL programming language and various object types. It also introduces new development capabilities, including reporting, queries, and .NET Framework interoperability.
Next steps
If you want to build on your skills, these may be relevant:
Module overview
Present the basic object types in Microsoft Dynamics NAV.
Describe fundamental aspects of Microsoft Dynamics NAV Development Environment. This includes the UI, application objects, and basic metadata concepts.
Explain the physical and logical database structure.
Explain the features for multi-developer environments.
Explain the concepts of tables and table components.
Examine the concept behind primary and secondary keys, and explain how to set them.
Create a simple table with primary and secondary keys, and add data to the table.
Review the concept of table relations.
Set table relations with a filter and condition.
Describe special table fields.
Use special table fields to improve table features.
Explain the concepts of pages and page components.
Describe Page Designer and Action Designer.
Create a simple page and add basic controls to the page.
Provide an overview of different page types and their characteristics.
Discuss best practices in designing pages.
Create a Card page, add a container, FastTabs, and fields.
Create a List page and link it to the Card page.
Create a main page and a Part page, and link the two pages.
Describe the concepts and basic use of C/AL code elements.
Describe the concepts of data types, simple data types, and complex data types.
Explain the concepts of identifiers, variables, and syntax.
Explain the syntax of identifiers.
Explain the scope of variables.
Explain the initialization of variables.
Create a simple codeunit to show how to define variables, assign data types, and investigate several default values that are initialized for several data types.
Explain the concepts of assignment, statement, and assignment statements.
Describe the syntax of statements and introduce the statement separator.
Describe automatic type conversions for string, numeric, and other data types.
Use assignment statements and the Symbol Menu.
Understand the concepts of expressions, terms, and operators.
Describe the syntax of an expression.
Describe the string operator.
Use the string operator.
Describe the MAXSTRLEN and the COPYSTR functions.
Use the MAXSTRLEN and the COPYSTR functions in an expression.
Define numeric expressions, arithmetic operators, and operator precedence.
Describe the arithmetic operators, and provide examples.
Use the arithmetic operators and examine the operator precedence.
Define relational and logical operators and expressions.
Describe how to use relational expressions for comparison.
Describe how to use relational expressions for set inclusion.
Describe how to use logical expressions.
Use logical and relational expressions in a page.
Define conditional statements and Boolean expressions.
Describe the IF statement, the IF-THEN, and IF-THEN-ELSE syntax.
Describe the EXIT statement and code indentation.
Describe the CASE statement and the syntax of the CASE statement.
Define compound statements and comments.
Describe the syntax of compound statements with BEGIN and END.
Understand the concepts of nested IF statements and the rule of correct indentation.
Describe the syntax of comments.
Use the IF, EXIT, CASE, and compound statements in a page.
Test knowledge about C/AL statements.
Define arrays and describe the components of arrays.
Describe the syntax of arrays.
Explain the power of arrays.
Describe how to use strings as arrays of characters.
Introduce repetitive statements that are available in C/AL.
Use arrays and repetitive statements in a page.
Describe the WITH statement, record variables, and the syntax of the WITH statement.
Explain the concepts of functions and parameters.
Explain the C/AL Symbol Menu.
Describe the use and syntax of data access, filtering, and manipulation functions.
Describe the use and syntax of user interaction functions.
Describe the use and syntax of string functions.
Describe the use and syntax of system functions.
Describe the use and syntax of date functions.
Describe the use and syntax of number functions.
Describe the use and syntax of array functions.
Describe the use and syntax of several other important functions.
Provide an overview of the benefits of creating custom functions.
Explain the concepts of local functions and local variables.
Create custom functions in a page and call the functions from Actions.
Explain the concepts of reports and report components.
Provide an overview of different report types and their characteristics.
Describe the difference between the logical and the visual design of reports and introduce Report Designer.
Describe the logical design of a report.
Create the data model for a new report by defining data items in the Report Dataset Designer.
Describe the visual design of a report and introduce Microsoft Visual Studio Report Designer.
Design the report layout.
Introduce Request Page Designer.
Design the Request Options page.
Explain the concepts of grouping and totaling in a report.
Create a grouping and totaling for a report.
Add advanced features to a report.
Describe the fundamentals of an XMLport and its components.
Review how to design XMLports.
Explain the Request page functionality.
Describe how to use XMLports from C/AL code.
Create XMLports for export and import with XML format.
Create XMLports for export and import with a fixed and a variable text format.
Explain the concepts of codeunits.
Provide an overview of designing codeunits.
Provide an overview by using codeunits.
Define variables and functions in a codeunit.
Use the SMTP Mail codeunit.
Explain the .NET Interoperability features.
Describe the concept of constructors.
Communicate between client-side and server-side objects.
Describe how to respond to events that are raised by .NET objects.
Examine mapping between C/AL and .NET data types.
Review the most important C/AL functions for managing .NET objects.
Use arrays, collections, and enumerations.
Explain how to stream data between C/AL and .NET objects.
Present the Query Designer and its features
Explain the principles of the query design process
Show how to select, join, filter, aggregate, and order data
Demonstrate how to access queries from C/AL code
Explain how to export data from queries
Free course advice
We care a lot about helping you find the course path that creates the most value for you and your workplace. Get in touch with our course advisors — they're ready to help you, free of charge and with no obligation.
I can't give anything less than 5 stars across the board. Either you're truly in a class of your own, or I've just been to the wrong course venues before. Fantastic place and atmosphere.... once you've learned to find your way around :-)
Your instructors are exceptional; skilled, competent and good at teaching - so you have everything you need to get off to a good start.
You have fantastic facilities, good food and lovely people throughout the building.
A really good, in-depth course. Your course facilities at Karlebogaard are nothing short of fantastic. A beautiful historic house with lots of fun stories and great course rooms. The course itself was very useful. I learned everything I had hoped to and then some. My instructor was damn good and really funny. He made it a pleasure, and the hours flew by.
Probably the best course I've ever taken and the best instructor I've ever had!! Really good depth and thorough explanations, and on top of that, fantastic food!!!
Delicious food, cozy facilities, good structure and atmosphere. I'll be back when I can.
Absolutely the best course I've ever taken!
The course venue is so inviting and welcoming that it has been a pleasure to be here. Clean, tidy and full of charm. I attended a course where all the individual parts came together into a greater whole that can hardly be described.
I got a lot out of the course. It opened my eyes to possibilities I didn't know existed. I'm sure this won't be the last time we're in touch with SuperUsers.
I never in my wildest dreams imagined that a course venue could be so beautiful. I don't know if it's true, but I have a feeling that the surroundings rub off on the people who work here, so everyone seems incredibly happy.
There's a really great atmosphere. All the way from the woman at the reception desk to the people who work in the kitchen.
The instructor tailored the course to my level to a very large extent and was flexible. I had very high expectations, and they were exceeded.
Great precision, good exercises, good pace, a great atmosphere and maximum learning.
The instructor was very pleasant and the exercises were extremely good. I really learned a lot about the topics the course covered.
On top of that, really nice, calm and green surroundings with good catering - especially good food. I would like to take my courses here again next time.
It was a real pleasure to take a course at SuperUsers. The week we spent on the course was worth the money and means that we can now save many consultant hours. It's always nice to have the knowledge in-house.
There is a relaxed atmosphere in the classroom, lovely surroundings in the building itself, and skilled instructors who do a really good job.
I started using all the knowledge I soaked up on the course almost right away, and now we are well underway with developing our future cloud solution.
There is no doubt about who we will turn to if we need other courses.
This is my first time at SuperUsers. It has been a really good experience. The instructor seems very experienced and competent.
The instructor's strong technical background made the course and the in-depth answers to questions a good experience.
A really nice course venue in pleasant surroundings that make for a good setting for focused learning. The instructor came across as well prepared, with extensive knowledge of the relevant topics.
The instructor also showed a strong ability to answer any questions that came up during the course.
I'll be back the next time I need to take a course. It's a lovely place, the food is fantastic, and the instructor is very knowledgeable and happy to share that knowledge!
The technical depth of the course was really good. The instructor's knowledge went much deeper than the curriculum necessarily requires.
You could throw all kinds of curveballs at the instructor, and he had it all under control - he also made the content exciting.
We have now completed Microsoft 365 courses for a total of 5 people here in our department. Everyone agrees that it was an excellent course with a skilled instructor and communicator who could discuss and explain things at the right level, while also being efficient and bringing humor.
It has been a really good experience.
It's calm and quiet at SuperUsers' country venue. Good atmosphere and catering. Some thought has gone into healthy eating when it comes to food and cake, so it doesn't get completely out of hand.
The instructor is knowledgeable about the topics and readily puts them in a broader perspective by relating them to other relevant areas. It's rewarding that this is possible too, and it gives you ideas for further study.
In addition, the instructor was engaged and entertaining to have presenting the content.
As always, it was a great experience, and you learn a lot in a short time from some very skilled instructors.
I work in Azure almost every day, and both courses have been really good at helping me understand Azure better.
The instructor is very presentation-oriented and gets you involved in the teaching and the material. He is good at varying the teaching so it never gets monotonous.
It is clear that the instructor has hands-on experience and not just the theory, with many good examples that related to real-world challenges we might encounter.
Good facilities and good food, without drowning in unhealthy habits.
Very good course, the instructor was the best. I've been here at SuperUsers before, now I'm here again, and hopefully coming back another time.
The instructor seemed very competent and has extensive knowledge of his field. He was good at explaining things in a clear and humorous way. There were also simple exercises that gave a good understanding.
The instructor was really good at going in depth while still making sure everyone was keeping up. A really nice venue and room, and great food.
There was no doubt that the instructor knew exactly what he was talking about, and even the simplest questions were answered gladly, without anyone being made to feel stupid.
A lovely, cozy place where the receptionist, the kitchen and the instructors make you feel at home. A good setting makes for good learning. Really good food that helps round out the whole experience of taking a course at SuperUsers.
Really happy with the venue and the stay over in the horse stable. I'll see if I can come back here for the next course I take. A really beautiful building, and great to experience a place like this. A fantastic place to hold a course.
