Course 80055A:

C/Side Solution Development in Microsoft Dynamics NAV 2009

Length:5 Day(s)
Published:April 15, 2009
Language(s):English
Audience(s):Developers, IT Professionals
Level:200
Technology:Microsoft Dynamics NAV 2009
Type:Course
Delivery Method:Instructor-led (classroom)
About this CourseThis five-day instructor-led course provides students with the knowledge and skills to develop Microsoft Dynamics NAV applications within the Classic Client and Role Tailored Client environments. This course is programming intensive. This is the second course on C/SIDE and knowledge from the Introduction in Microsoft Dynamics NAV 2009 course is vital to the understanding of the concepts and for participation in this course. In this course you will learn programming documentation, debugging tools, performance issues, complex data variables and their internal member functions, multi-language functionality, analysis of objects, posting routines, interfaces to Microsoft Dynamics NAV 2009, and some Microsoft SQL Server 2008 issues.
Audience ProfileThis course is intended for Microsoft Certified Business Solutions Partner employees who sell and implement Microsoft Nav solutions. The curriculum is designed for participants who have completed the Introduction in Microsoft Dynamics NAV 2009 course.
At Course Completion
After completing this course, students will be able to:
  • Creating solutions following the Microsoft Nav Implementation Methodology.
  • Use debugging tools.
  • Troubleshoot performance issues.
  • Define complex data variables and their member functions.
  • List multi language functionality.
  • Perform analysis of objects.
  • Post routines.
  • Define the architecture of a basic Microsoft Nav document.
  • Define Microsoft Nav dimensions.
  • Deploy customized Microsoft Nav software solutions.

Course OutlineModule 1: Client RequirementsThe Diagnosis section of this chapter provides the "executive summary" of the business case, including the client's profile and a high-level description of their needs. The Analysis section describes the client's specific requirements for the system, including the data models based on those requirements and the basic project implementation plan.Lessons
  • Diagnosis – Executive Summary 
  • Analysis – Functional Requirements
  • Data Model
  • Project Plan
After completing this module, students will be able to:
  • Diagnose the executive summary.
  • Analyze functional requirements.
  • Create a data model based on the functional requirements.
  • Develop a project plan.
Module 2: Master Tables and PagesThis module explains how the requirements for master tables and pages for the solution are discussed before moving on to the Design and Implementation phases.Lessons
  • A Quick Refresher 
  • Customers and Participants 
  • Rooms 
  • Instructors
  • Seminars
  • Testing
Lab : Create Seminar Room Tables and PagesLab : Adding Code for Seminar RoomsLab : Creating Instructor Tables and PagesLab : Create Seminar Tables and Pages
After completing this module, students will be able to:
  • Use formalized analysis and design methodology.
  • Understand master table and page standards.
  • Work with table event triggers.
  • Work with the complex data types and their member functions.
  • Enable multi-language functionality.
  • Define the strategy for implementing Customers and Participants.
  • Create the tables to manage the seminar rooms.
  • Create instructor data management.
  • Create seminar data management.
  • Test the master tables and pages by following a test script.   
Module 3: RegistrationsThis module explains how to implement functionality to allow users to perform transactions with the master data.Lessons
  • Prerequisite Information
  • Types of Tables
  • Additional Functions
  • Registrations
  • Testing Seminar Registrations
Lab : Create Tables and Pages for SeminarsLab : Add Code to the Seminar Charge TableLab : Adding Code to Seminar Registration HeaderLab : Create Seminar Tables and Pages
After completing this module, students will be able to:
  • Import and export objects as text files.
  • Support multilanguage functionality.
  • Use main and subpages (document pages).
  • Use virtual tables.
  • Use temporary tables.
  • Review the various types of tables.
  • Review of C/AL functions.
  • Create additional tables and user interfaces (pages) to maintain registrations.
  • Test the results of the Labs.
Module 4: Posting
This module explains how to use the registration information to create ledger entries for seminars through a posting routine. This functionality is added to the Seminar module by the end of this chapter.
Lessons
  • Prerequisite Information
  • Posting Seminar Registrations
Lab : Creating the Tables and Pages for Seminar Registration PostingLab : Creating the Codeunits and Page for Seminar Journal PostingLab : Modifying the TableLab : Creating Instructor Tables, Pages and Codeunits for Job PostingLab : Role Tailored Client Menu Setup
After completing this module, students will be able to:
  • Create journal posting routines.
  • Create document posting routines.
  • Write internal documentation for modifications to existing objects.
  • Debug code.
  • Program for low-impact on the application.
  • Develop pages and codeunits for posting.
  • Add objects to the RoleTailored client menu.
  • Test the design and development work.
Module 5: IntegrationThis module explains how to integrate these features with one another and with the standard application, making it user-friendly. This requires using MenuSuite objects and implementing Microsoft Dynamics NAV Navigate functionality. This chapter addresses the integration of solution functionality with the user interface (UI) of the application.Lessons
  • Prerequisite Information
  • Seminar Feature Integration
  • Navigate Integration
  • Testing Managing Integration
Lab : Integrating Seminar FeaturesLab : Modifying Objects to Integrate with Navigate
After completing this module, students will be able to:
  • Integrate previously created Seminar module features with one another by adding the Navigate feature to pages.
  • Add to the Department Menu so that the Seminar module functionality is accessible in a standard way.
  • Integrate the Navigate feature into the Seminar module.
  • Test integration of the Navigate feature.
Module 6: ReportingThis module explains how to create reports for the Seminar module.Lessons
  • Prerequisite Information
  • Participant List Reporting
  • Certificate Information 
  • Invoice Posting 
Lab : Create the Participant ListLab : Creating the Certificate Confirmation ReportLab : Creating the Invoice Posting Report
After completing this module, students will be able to:
  • Use report event triggers.
  • Use special report functions.
  • Create reports for both the Classic and RoleTailored clients.
  • Create a seminar participant list.
  • Create a confirmation certificate for a seminar participant.
  • Create a ProcessingOnly report that posts invoices.
Module 7: StatisticsThis module explains how statistics are added to the Seminar Management module using FlowFilters and FlowFields.Lessons
  • Prerequisite Information
  • Seminar Statistics
  • Testing
Lab : Creating FlowFields for SumsLab : Creating the Seminar Statistics Page
After completing this module, students will be able to:
  • Create a page that calculates price sums efficiently.
  • Make the page available from the Seminar pages.
  • Use FlowFilters to easily calculate statistics for different time periods.
Module 8: DimensionsThis module explains how Dimensions are used to control how analysis occurs.Lessons
  • Prerequisites
  • Code Walkthrough – Dimension Management Codeunit 
  • Dimension Master Tables, Pages, and Codeunits 
  • Dimensions in Documents 
  • Dimensions in Posting  
Lab : Using The Debugger Interface to View The Dimension Process
After completing this module, students will be able to:
  • Describe Global, Shortcut and Budget dimension types and their functions.
  • List the basic rules of Dimension Setup.
  • List the functions that help populate the dimension tables.
  • Enable multi-language functionality.
  • Describe the flow of dimension values for posted documents.
  • Describe how shortcut dimension fields are used.
Module 9: InterfacesThis module explains how the some of the methods that are used to interface Microsoft Dynamics NAV to external software or hardware.Lessons
  • Prerequisite Information
  • File-Handling
  • Email Confirmation
  • Using an XMLport
Lab : Creating Email ConfirmationsLab : Creating the XML Seminar Registration Participant List
After completing this module, students will be able to:
  • Use automation servers to perform tasks with other applications.
  • Install and use custom controls in C/AL.
  • Use file handling functions to import or export data.
  • Design and implement an e-mail capability.
  • Use the XMLport to generate exported data in XML format.
Module 10: Web ServicesThis module explains how the interoperation between different software applications, running on a variety of platforms and/or frameworks occurs.Lessons
  • Web Services Overview 
  • Web Service Opportunities 
  • Creating, Exposing and Consuming Web Services 
Lab : Creating a Web ServiceLab : Create a Console Application to Consume the Codeunit Web ServiceLab : Create a Console Application to Consume the Seminar Card Page Web ServiceLab : Create an Infopath Form to Consume a New Web Page Service for Seminar Participants
After completing this module, students will be able to:
  • Know how Microsoft Dynamics NAV supports Web services.
  • Evaluate the benefits of Web services over other integration options in Microsoft Dynamics NAV.
  • Understand how to expose codeunit and page objects as Web services.
  • Consume Web services using functions developed through Visual Studio and Infopath.
Module 11: Optimizing for SQL ServerThis module explains how the differences between the two servers options available with Microsoft Dynamics NAV 2009.Lessons
  • Classic Database Server for Microsoft Dynamics NAV 
  • SQL Server for Microsoft Dynamics NAV 
  • Representation of Microsoft Dynamics NAV Tables and Indexes in SQL Server
  • Collation Options 
  • SQL Server Data Replication
  • Backup Options
  • SQL Server Query Optimizer
  • Optimizing a Microsoft Dynamics NAV Application
  • Overview of NDBCS
  • Optimization of Cursors
  • Locking, Blocking, and Deadlocks
  • How SIFT Data is Stored in SQL Server
After completing this module, students will be able to:
  • Distinguish between the two database options available in Microsoft Dynamics NAV 2009.
  • Comprehend the advantages of both the Classic Database Server and the SQL Server for Microsoft Dynamics NAV 2009. Work with table event triggers.
  • Work with and store tables and indexes.  
  • Use collation options and descriptions.
  • Understand the SQL Server Data Replication process of distributing data.
  • Know backup options available and best practices for backup.
  • Introduction to SQL Server Query Optimizer.
  • Understand how the Microsoft Dynamics NDBCS driver allows the Microsoft Dynamics NAV clients to communicate with SQL Server.
  • Understand the value of optimizing cursors to maximize performance.
  • Understand the performance impact of locking, blocking and deadlocks.  
  • Understand how SIFT data is stored in SQL Server.
Module 12: DeploymentThis module explains how deployment marks the end of the implementation phase. During deployment, the final preparations are made and the Seminar module is installed at the client site.Lessons
  • Deployment Tasks 
  • Ongoing Support Phase 
  • Upgrades and Updates
After completing this module, students will be able to:
  • Apply the essential elements of a successful deployment phase.
  • Know of and understand the types of data generally imported into Microsoft Dynamics NAV.
  • Know of and understand the partner’s role for ongoing support both during and after the initial deployment phase.
  • Evaluate the difference between updates and upgrades.
  • Understand processes for upgrading executables and objects.
  • Follow the basic steps involved in a typical Microsoft Dynamics NAV upgrade project.
  • Know the tools available to assist with upgrades.
Additional Reading
To help you prepare for this class, review the following resources:
  • Microsoft Dynamics NAV 2009 Developer and IT Pro Help.
  • User Experience Guidelines for Microsoft Dynamics NAV 2009.

Before attending this course, students must have:
  • completed the course: "C/SIDE Introduction in Microsoft Dynamics NAV 2009"
  • Passed the "Development Introduction in Microsoft Dynamics 2009" exam
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 a Microsoft Learning Partner near you

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France