Course 80042A:

C/SIDE Introduction in Microsoft Dynamics NAV 2009

Length:5 Days
Published:January 05, 2009
Language(s):English
Audience(s):Developers
Level:200
Technology:Microsoft Dynamics NAV 2009
Type:Course
Delivery Method:Instructor-led (classroom)
About this Course
The five-day course, C/SIDE Introduction in Microsoft Dynamics 2009 examines all aspects of the Development granules that are available for Microsoft Dynamics NAV 2009. This course covers the Microsoft Dynamics NAV software architecture, the Client/Server Integrated Development Environment (C/SIDE), the objects available to developers which includes tables, forms, pages, reports, dataports, XMLports, codeunits, and MenuSuites, basic programming, data manipulation, and integration options available in Microsoft Dynamics NAV 2009. In addition, this course provides an intensive introduction to Client/Application Language (C/AL), the Microsoft Dynamics NAV programming language.
A thorough understanding of these topics allows to streamline the development processes by learning how to develop integrations and customizations for the Microsoft Dynamics NAV. This course teaches how to navigate within the development environment, how to create and use the basic objects, and how to implement best practices for ensuring smooth software upgrades in the future.
Audience Profile
This course is intended for partners who want to learn how to get started creating customized solutions in Microsoft Dynamics NAV for their customers. This course is also intended for developers, consultants, and implementers who need to understand the technical aspects of Microsoft Dynamics NAV C/SIDE and C/AL and gain foundational knowledge of the application functionality. This course is also targeted at anyone who wants to become certified in C/SIDE Introduction in Microsoft Dynamics NAV 2009.
At Course Completion
After completing this course, students will be able to:
  • Set up the development environment.
  • Understand basic objects available in Microsoft Dynamics NAV.
  • Create simple customizations within C/SIDE using C/AL.
  • Prepare for the C/SIDE Introduction certification exam.
Course OutlineModule 1: Client/Server Integrated Development Environment (C/SIDE)This module explains basic objects in Microsoft Dynamics NAV and the Client/Server Integrated Development Environment (C/SIDE). It also describes physical and logical databases and several integration tools available in Microsoft Dynamics NAV 2009. Lessons
  • Basic Objects in Microsoft Dynamics NAV
  • C/SIDE Fundamentals
  • The Physical and the Logical Database
  • Integration Tools
After completing this module, students will be able to:
  • Discuss objects in Microsoft Dynamics NAV 2009.
  • Describe fundamental aspects of C/SIDE development, including UI, application objects, C/SIDE concepts and types of databases.
  • Discuss database structure.
  • Describe integration tools available in Microsoft Dynamics NAV 2009.
Module 2: TablesThis module explains the fundamental concepts of table objects, describes the concepts of table relationships, special table fields and how to use them, and describes how to use the Table Designer to create and modify tables. It also describes table types and their characteristics.Lessons
  • Table Fundamentals
  • Primary and Secondary Keys
  • Demonstration: Create a Simple Table
  • Special Table Fields
  • Demonstration: Special Table Fields
  • Table Types and Characteristics
Lab : Create a Table
After completing this module, students will be able to:
  • Describe table concepts, the structure and elements of tables.
  • Demonstrate how to use the Table Designer to create simple tables and set field and table properties.
  • Explain concepts behind primary and secondary keys for tables.
  • Describe table relationships and how to set them.
  • Explain the concepts of SumIndexFields, FlowFields, and FlowFilter fields, and how to use them.
  • Review table types.
Module 3: FormsThis module explains the fundamental concepts of form objects and describes how to use the Form Designer to create and modify forms. It also describes form types and their characteristics and standard navigation in forms.Lessons
  • Form Fundamentals
  • Demonstration: Create a Simple Form
  • Form Types and Characteristics
  • Demonstration: Create a Card Form
  • Demonstration: Create a List Form
  • Demonstration: Link the Card Form and the List Form
  • Demonstration: Form and Subform
  • Standard Navigation
Lab : Create a Card Form and a List Form
After completing this module, students will be able to:
  • Describe form concepts and elements of forms, including controls.
  • Describe binding forms and controls to source tables.
  • Create a blank form and attach a source table.
  • Add simple controls to a form, such as a text box, a label, and a check box.
  • Use tools from the Toolbox, including the Add Label tool and the Lock tool.
  • Add a tab, frame, and TableBox controls to a form.
  • Add option buttons, an indicator control, and a BLOB field, or picture, to a form.
  • Use the Form Wizard to create a card form and a tabular form.
  • Add fields and buttons to forms.
  • Create a subform and add it to the main form.
  • Discuss form types and the standard navigation in forms.
Module 4: PagesThis module explains the fundamental concepts of page objects and describes how to use the Page Designer to create and modify pages. It also describes page types and their characteristics and discuss the best practices in creating pages.Lessons
  • Page Fundamentals
  • Page Designer
  • Demonstration: Create a Simple Page
  • Page Types and Characteristics
  • Design Pages: Best Practices
  • Demonstration: Create a Card Page
  • Demonstration: Create a List Page
  • Demonstration: Part and Part Page
Lab : Create a Card, a List and a ListPart Page
After completing this module, students will be able to:
  • Describe page concepts and elements of page, including actions.
  • Use the Page Designer to create and modify pages and the Action Designer to add actions and position them.
  • Add simple controls to a page, such as a field and a FastTab.
  • Use the Field Menu to add multiple fields.
  • Create a part page and add it to the main page.
  • Discuss the best practices in creating pages.
  • Discuss page types and their characteristics.
Module 5: Introduction to C/AL ProgrammingThis module introduces C/AL, the programming language in C/SIDE and its elements. It also describes data types available in C/AL, concepts of identifier, variable, syntax, variable scope and variable initialization.Lessons
  • C/AL Programming
  • Intrinsic Data Types
  • Identifiers, Variables and Syntax
  • The Syntax of Identifiers
  • Variable Scope
  • Variable Initialization
  • Demonstration: Data Types and Variable Initialization
Lab : Investigate Data Types
After completing this module, students will be able to:
  • Understand the concepts and basic use of C/AL code elements.
  • Describe data types in C/AL.
  • Describe the concepts of identifier, variable, syntax, variable scope and initialization.
Module 6: Assignment Statements and ExpressionsThis module explains assignment statements, expressions, terms and operators. It describes automatic type conversion between data types and different kinds of operators and operator precedence. It also describes numeric, relational and logical expressions.Lessons
  • Assignment Statements
  • The Syntax of Statements
  • Automatic Type Conversions
  • Demonstration: Use Assignment Statements and the Symbol Menu
  • Expressions, Terms, and Operators
  • The Syntax of an Expression
  • The String Operator
  • Demonstration: Use the String Operator
  • Function Calls in Expressions
  • Demonstration: Use the MAXSTRLEN and the COPYSTR Function
  • Numeric Expressions
  • Arithmetic Operators
  • Demonstration: Use the Arithmetic Operators
  • Relational and Logical Expressions
  • Relational Expressions for Comparisons
  • Relational Expressions for Set Inclusion
  • Logical Expressions
  • Demonstration: Use Logical and Relational Expressions in a Page
After completing this module, students will be able to:
  • Describe the concepts of assignment statement, the syntax of statements and statement separator.
  • Describe automatic type conversions for string, numeric and other data types.
  • Use the C/AL Symbol Menu.
  • Describe the concepts of expressions, terms and operators.
  • Describe the string operator, the arithmetic operators and operator precedence.
  • Describe relational and logical operators, and how to use them.
Module 7: C/AL StatementsThis module explains conditional statements, compound statements, comments and repetitive statements. It also describes the concepts of Arrays and how to use them.Lessons
  • Conditional Statements and Boolean Expressions
  • The IF Statement
  • The EXIT Statement
  • The CASE Statement
  • Compound Statements and Comments
  • The Syntax of Compound Statements
  • Compound Statement by Using Nested IF Statements
  • The Syntax of Comments
  • Demonstration: Use the IF, EXIT, CASE and Compound Statements in a Page
  • Arrays
  • The Syntax of Arrays
  • The Power of Arrays
  • Strings as Arrays of Characters
  • Repetitive Statements
  • Demonstration: Use Arrays and Repetitive Statements
  • The WITH Statement
Lab : Use Conditional and Compound Statements
After completing this module, students will be able to:
  • Describe the concepts of conditional statements and Boolean expressions.
  • Use the IF, CASE and EXIT statements.
  • Describe the concepts of compound statements and comments.
  • Describe the concepts of Arrays and how to use them.
  • Describe the concepts of repetitive statements and understand when to use different types of repetitive statements.
Module 8: C/AL FunctionsThis module explains the concepts of functions and describes several built-in functions and how they are used. It also describes the concepts of parameters and how to create custom functions.Lessons
  • Functions and Parameters
  • Review Built-in Functions
  • Demonstration: Use the DATE2DMY Function
  • Essential C/AL Functions
  • User Communication Functions
  • String Functions
  • System Functions
  • Date Functions
  • Number Functions
  • Array Functions
  • Other Functions
  • Create Custom Functions
  • Formal and Actual Parameters
  • Local Functions, Variables and the EXIT Statement
  • Demonstration: Create Custom Functions
After completing this module, students will be able to:
  • Describe the concepts of functions and parameters.
  • Describe several built-in functions and how they are used.
  • Create custom functions.
Module 9: ReportsThis module explains the fundamental concepts of report objects and describes the different stages in creating and designing reports. It also describes several types of printing reports and how to create grouping, totaling and add advanced features to a report, for the Classic and the RoleTailored Client.Lessons
  • Report Fundamentals
  • Types of Printing Reports
  • Report Design Process
  • Design the Data Model
  • Demonstration: Create a Data Model
  • Design the Visual Element
  • Demonstration: Design the Report Section
  • Demonstration: Modify Report Properties
  • Demonstration: Design the Report Layout
  • The Request Options Designer
  • Demonstration: Design the Request Options Form
  • Demonstration: Design the Request Options Page
  • Grouping Within a Classic Report
  • Demonstration: Create Grouping For the Classic Report
  • Totaling in a Report
  • Demonstration: Create Totals for the Classic Report
  • Demonstration: Create Grouping and Totals for the RoleTailored Report
  • Demonstration: Add Some Advanced Features
Lab : Create a Basic Report
After completing this module, students will be able to:
  • Describe report concepts and the components of reports.
  • Describe different types of printing reports and their characteristics.
  • Describe the logical and visual design of reports.
  • Create a data model in the Report Designer.
  • Design report sections by using the Section Designer.
  • Design report layout by using Microsoft Visual Studio Report Designer.
  • Design Request Options Form and Request Options Page by using the Request Options Designer.
  • Set several useful report properties.
  • Create grouping and totaling in reports for the Classic and the RoleTailored Client.
  • Add some advanced features to a report.
Module 10: Dataports and XMLportsThis module explains the fundamental concepts of dataport and XMLport objects and describes how to use the Dataport Designer and XMLport Designer to create dataports and XMLports for export and import external file. It also describes how XMLports replace Dataports in the RoleTailored Client.Lessons
  • Dataport Fundamentals
  • Design Dataports
  • Demonstration: Create Dataports for Export
  • Demonstration: Create Dataports for Import
  • XMLport Fundamentals
  • Design XMLports
  • Demonstration: Create XMLports for Use in the Classic Client
  • Demonstration: Create XMLports for Use in the RoleTailored Client
Lab : Create XMLports
After completing this module, students will be able to:
  • Describe Dataport concepts and the components of Dataports.
  • Create and design Dataports for export and import with fixed and variable format of the external file.
  • Describe XMLport concepts and the components of XMLports.
  • Create and design XMLports to be run in the Classic and the RoleTailored Client.
Module 11: CodeunitsThis module explains the fundamental concepts of codeunit objects and describes how to use the C/AL Editor to create codeunits. It also describes how to use the SMTP Mail Codeunit.Lessons
  • Codeunit Fundamentals
  • Design Codeunits
  • Use Codeunits
  • Demonstration: Define Variables, Text Constants and Functions in a Codeunit
  • SMTP
After completing this module, students will be able to:
  • Describe codeunit concepts.
  • Create and use codeunits.
  • Define Variables, Text Constants and Functions in a codeunit.
  • Use the SMTP Mail Codeunit.
Module 12: MenuSuitesThis module explains the fundamental concepts of MenuSuite objects and describes how to use the Navigation Pane Designer to create and design MenuSuites. It also describes how to create MenuSuite for the Classic and the RoleTailored Client.Lessons
  • MenuSuite Fundamentals
  • Create and Design MenuSuites
  • Upgrade MenuSuite
  • Demonstration: Create a MenuSuite for the Classic Client
  • Demonstration: Create a MenuSuite for the RoleTailored Client
Lab : Create MenuSuites
After completing this module, students will be able to:
  • Describe MenuSuite concepts and MenuSuite levels.
  • Create and Design MenuSuites.
  • Understand the concepts of upgrading MenuSuites.
  • Create MenuSuites for the Classic and the RoleTailored Client.
Module 13: Integration OptionsThis module explains several integration tools available in Microsoft Dynamics NAV. It also describes how to use them and their limitations.Lessons
  • Web Services
  • Demonstration: Create, Expose and Consume Web Services
  • ODBC
  • Demonstration: Use Microsoft Dynamics NAV ODBC
  • C/FRONT
  • OCX
  • Demonstration: Use OCX Controls
  • Automation Server
  • Demonstration: Create a Report with Automation
After completing this module, students will be able to:
  • Describe the concepts of Microsoft Dynamics NAV Web Services.
  • Create a codeunit Web service, expose a page and a codeunit Web service and consume them from an external application.
  • Describe the concepts of Microsoft Dynamics NAV ODBC, its requirements, installation and limitations.
  • Describe the concepts of C/FRONT, its requirements, installation and limitations.
  • Describe the concepts of OCX, its installation, registration and limitations.
  • Use OCX controls.
  • Describe the concepts of Automation, its requirements, installation and limitations.
  • Create a report with Automation.
Additional Reading
To help you prepare for this class, review the following resources:
  • Microsoft Dynamics NAV 2009 Developer and IT Pro Documentation.
Before attending this course, students must have:
  • General knowledge of basic ERP user roles.
  • Basic programming knowledge.
  • Completed Course 80043, Introduction to Microsoft Dynamics NAV 2009, or have relevant experience with Microsoft Dynamics NAV.
Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France