8873: C/SIDE Solution Development in Microsoft Dynamics NAV 5.0 (5 Days)
About this Course
This 5-day course is programming intensive. Knowledge from the Introduction in Microsoft Dynamics NAV 5.0 course is vital to the understanding of the concepts and for participation in this course. In this course you’ll 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 5.0, and some Microsoft SQL Server 2005 issues.
Audience Profile
This training material is intended for Microsoft Certified Business Solutions Partner employees who sell and implement Microsoft Navision solutions. The curriculum is designed for participants who have completed the Microsoft Navision Development I course and passed the Navision Programming certification exam.
At Course Completion
After completing this course, students will understand:
- Creating solutions following the Navision Implementation Methodology
- Internal documentation
- Debugging tools
- Performance issues
- Complex data variables and their member functions
- Multilanguage functionality
- Analysis of objects
- Posting routines
- Architecture of a basic Microsoft Navision document
- Microsoft Navision dimensions
- Deploying customized software solutions
Course Outline
Module 1: introduction
Lessons
- Introduction to C/SIDE Solution Development in Microsoft Dynamics NAV 5.0
Module 2: Client Requirements
Lessons
- Diagnosis – Executive Summary
- Analysis – Functional Requirements
- Data Models
- Project Plans
After completing this chapter, students will be able to:
- Follow the standard Microsoft Navision Methodology used in developing projects.
- Understand the business case used, and detail the functional requirements.
Module 3: Master Tables and Forms
Lessons
- A Quick Refresher
- Customers and Participants
- Rooms
- Testing
Lab : Adding Code for Seminar RoomsLab : Creating Intructor Tables and Forms After completing this chapter, students will be able to:
- Write internal documentation.
- Enable multilanguage functionality.
- Work with event triggers, specifically table event triggers.
- Work with the complex data types and their member functions.
Module 4: Registrations
Lessons
- Prerequisite Information
- Types of Tables
- Additional Functions
- Solution Analysis
- Solution Design
- Testing Seminar Registrations
After completing this chapter, students will be able to:
- Export and import objects as text files.
- Use multilanguage functionality to create messages for the user.
- Know how to create matrix forms.
- Use virtual tables.
- Use temporary tables.
Module 5: Introduction to C/AL Programming
Lessons
- Prerequisite Information
- Posting Seminar Registrations
After completing this chapter, 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.
Module 6: Integration
Lessons
- Prerequisite Information
- Seminar Feature Integration
- Navigation Integration
- Testing Managing Integration
After completing this chapter, students will be able to:
- Expand the MenuSuite.
- Implement Navigate functionality.
Module 7: Reporting
Lessons
- Prerequisite Information
- Reporting Lab Overview
- Participant List Reporting
- Certificate Confirmation
- Invoice Posting
After completing this chapter, students will be able to:
- Use report event triggers
- Use special report functions.
- Create processing-only reports.
Module 8: Statistics
Lessons
- Using FlowFilters and FlowFields
- Using FlowFilters in Calculation Formulas
Lab : Lab After completing this chapter, students will be able to:
- Learn how to use FlowFields for calculations.
Module 9: Dimensions
Lessons
- Dimension Types
- Code Walkthrough - Dimension Management Codeunit
- Using Microsoft Dynamics NAV Developer's Toolkit
- Dimensions in Master Tables, Forms, and CodeUnits
- Dimensions in Registration
- Dimensions in Seminar Posting
- Dimensions in Invoicing
- Testing
After completing this chapter, students will be able to:
- Learn how to work with dimensions.
Module 10: Interfaces
Lessons
- Using an Automation Server
- Using Custom (or OCX) Controls
- XMLPort Triggers
- File Handling
- E-mail Confirmation
- XML Participant List
Lab : Creating Contact Dataport
After completing this chapter, students will be able to:
- Use OCX.
- Understand what an automation server is.
- Work with an XMLPort.
Module 11: Deployment
Lessons
- Deployment Tasks
- Ongoing Support Phase
Lab : Creating Contact Dataport
After completing this chapter, students will be able to:
- Understand how to roll out customized Microsoft Navision projects out to clients.
- Use Dataports.
- Understand Microsoft Navision’s upgrade procedures.
Module 12: Optimizing SQL Server
Lessons
- Microsoft Dynamics NAV Database Server
- SQL Server
- Representation of Microsoft Dynamics NAV Tables and Indexes in SQL Server
- Collation Options
- Windows Locale
- Collation Description
- SQL Server Replication
- Microsoft Dynamics NAV Database 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
Before attending this course, it is strongly recommended that students have:
- Completed Introduction in Microsoft Dynamics NAV 5.0
- Passed the Introduction in Microsoft Dynamics NAV 5.0 exam
*E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.