Course 8873: Five days; Instructor-Led
On This Page
Introduction
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
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 |
Prerequisites
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 |
Microsoft Certified Professional Exams
No Microsoft Certified Professional exams are associated with this course currently.
Course Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.
Course Outline
Introduction
Lessons
| • |
Introduction to C/SIDE Solution Development in Microsoft Dynamics NAV 5.0 |
Chapter 1: Client Requirements
Lessons
| • |
Diagnosis – Executive Summary |
| • |
Analysis – Functional Requirements |
| • |
Data Models |
| • |
Project Plans |
After completing this chapter, students should be able to:
| • |
Follow the standard Microsoft Navision Methodology used in developing projects. |
| • |
Understand the business case used, and detail the functional requirements. |
Chapter 2: Master Tables and Forms
Lessons
| • |
A Quick Refresher |
| • |
Customers and Participants |
| • |
Rooms |
| • |
Testing |
Lab
| • |
Lab 2.1 - Creating Seminar Room Tables and Forms |
| • |
Lab 2.2 - Adding Code for Seminar Rooms |
| • |
Instructors |
| • |
Lab 2.3 - Creating Intructor Tables and Forms |
| • |
Seminars |
| • |
Lab 2.4 - Creating Seminar Tables and Forms |
After completing this chapter, students should 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. |
Chapter 3: Registrations
Lessons
| • |
Prerequisite Information |
| • |
Types of Tables |
| • |
Additional Functions |
| • |
Solution Analysis |
| • |
Solution Design |
| • |
Testing Seminar Registrations |
Labs
| • |
Lab 3.1 - Creating the Tables and Forms for Seminar Registration |
| • |
Lab 3.2 - Adding Code for Seminar Charges |
| • |
Lab 3.3 - Adding Code to the Seminar Registration Header Table and Form |
| • |
Lab 3.4 - Adding Code for Seminar Registration Lines |
After completing this chapter, students should 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. |
Chapter 4 - Posting
Lessons
| • |
Chapter 4: Introduction to C/AL Programming |
| • |
Prerequisite Information |
| • |
Posting Seminar Registrations |
Labs
| • |
Lab 4.1 - Creating the Tables and Forms for Seminar Registration Posting |
| • |
Lab 4.2 - Creating the Codeunits and Form for Seminar Journal Posting |
| • |
Lab 4.3 - Modifying the Tables, Forms and Codeunits for Job Posting |
| • |
Lab 4.4 - Creating the Tables and Forms for Posted Information |
| • |
Lab 4.5 - Creating the Codeunits for Document Posting |
After completing this chapter, students should 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. |
Chapter 5: Integration
Lessons
| • |
Prerequisite Information |
| • |
Seminar Feature Integration |
| • |
Navigation Integration |
| • |
Testing Managing Integration |
Labs
| • |
Lab 5.1 - Integrating Seminar Features |
| • |
Lab 5.2 - Modifying Objects to Integrate Navigation |
After completing this chapter, students should be able to:
| • |
Expand the MenuSuite. |
| • |
Implement Navigate functionality. |
Chapter 6: Reporting
Lessons
| • |
Prerequisite Information |
| • |
Reporting Lab Overview |
| • |
Participant List Reporting |
| • |
Certificate Confirmation |
| • |
Invoice Posting |
Labs
| • |
Lab 6.1 - Creating the Participant List Report |
| • |
Lab 6.2 - Creating the Certificate Confirmation Report |
| • |
Lab 6.3 - Creating the Invoice Posting Report |
After completing this chapter, students should be able to:
| • |
Use report event triggers |
| • |
Use special report functions. |
| • |
Create processing-only reports. |
Chapter 7: Statistics
Lessons
| • |
Using FlowFilters and FlowFields |
| • |
Using FlowFilters in Calculation Formulas |
Lab
| • |
Lab 7.1 - Creating FlowFields for Sums |
| • |
Lab 7.2 - Creating the Seminar Statistics Form C:\Documents and Settings\mfred\Desktop\CSIDE ILT Handoff\CSIDE_Intro_IN.docx - _Toc176444718 |
After completing this chapter, students should be able to:
| • |
Learn how to use FlowFields for calculations. |
Chapter 8: 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 |
Lab
| • |
Lab 8.1 - Modifying the DimensionManagement Codeunit |
| • |
Lab 8.2 - Modifying the Tables and Forms for Dimensions in Master Files |
| • |
Lab 8.3 - Modifying the Tables for Dimensions in Seminar Registrations |
| • |
Lab 8.4 - Modifying the Forms for Dimensions in Seminar Registrations |
| • |
Lab 8.5 - Modifying the Tables and Forms for Dimensions in Posted Seminar Registrations |
| • |
Lab 8.6 - Modifying the Tables, Codeunits and Forms for Dimensions in Seminar Posting |
| • |
Lab 8.7 - Modifying the Create Seminar Invoices Report for Dimensions C:\Documents and Settings\mfred\Desktop\CSIDE ILT Handoff\CSIDE_Intro_IN.docx - _Toc176444718 |
After completing this chapter, students should be able to:
| • |
Learn how to work with dimensions. |
Chapter 9: Interfaces
Lessons
| • |
Using an Automation Server |
| • |
Using Custom (or OCX) Controls |
| • |
XMLPort Triggers |
| • |
File Handling |
| • |
E-mail Confirmation |
| • |
XML Participant List |
Lab
| • |
Lab 9.1 - Creating E-mail Confirmations |
| • |
Lab 9.2 - Creating the XML Sem. Reg.-Participant List C:\Documents and Settings\mfred\Desktop\CSIDE ILT Handoff\CSIDE_Intro_IN.docx - _Toc176444718 |
After completing this chapter, students should be able to:
| • |
Use OCX. |
| • |
Understand what an automation server is. |
| • |
Work with an XMLPort. |
Chapter 10: Deployment
Lessons
| • |
Deployment Tasks |
| • |
Ongoing Support Phase |
Labs
| • |
Lab 10.1 - Creating Contact Dataport |
After completing this chapter, students should be able to:
| • |
Understand how to roll out customized Microsoft Navision projects out to clients. |
| • |
Use Dataports. |
| • |
Understand Microsoft Navision’s upgrade procedures. |
Chapter 11: 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 |
The goal of completing this chapter is to enable students to:
| • |
Understand fundamental differences in how data is stored in SQL Server |
| • |
Use optimization tools to spot problem areas |
| • |
Know how to avoid common performance problems |
|
