M8873: C/SIDE Solution Development in Microsoft Dynamics NAV 5.0

Prerequisites:

Before attending this course, it is strongly recommended that students have:

- Completed Introduction to Microsoft Dynamics NAV 5.0
- Passed the Introduction to Microsoft Dynamics NAV 5.0 exam

Course Description:

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.

Course Objectives

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

Who Should Attend

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.

This course includes the following modules:

Client Requirements

• Diagnosis Executive Summary
• Analysis Functional Requirements
• Data Models
• Project P

Master Tables and Forms

• A Quick Refresher
• Customers and Participants
• Rooms
• Testing
• Creating Seminar Room Tables and Forms (Lab)
• Adding Code for Seminar Rooms (Lab)
• Creating Intructor Tables and Forms (Lab)
• Creating Seminar Tables and Forms (Lab)

Registrations

• Prerequisite Information
• Types of Tables
• Additional Functions
• Solution Analysis
• Solution Design
• Testing Seminar Registrations
• Creating the Tables and Forms for Seminar Registration (Lab)
• Adding Code for Seminar Charges (Lab)
• Adding Code to the Seminar Registration Header Table and Form (Lab)
• Adding Code for Seminar Registration Lines (Lab)

Posting

• Introduction to C/AL Programming
• Prerequisite Information
• Posting Seminar Registrations
• Creating the Tables and Forms for Seminar Registration Posting (Lab)
• Creating the Codeunits and Form for Seminar Journal Posting (Lab)
• Modifying the Tables, Forms and Codeunits for Job Posting (Lab)
• Creating the Tables and Forms for Posted Information (Lab)
• Creating the Codeunits for Document Posting (Lab)

Integration

• Prerequisite Information
• Seminar Feature Integration
• Navigation Integration
• Testing Managing Integration
• Integrating Seminar Features (Lab)
• Modifying Objects to Integrate Navigation (Lab)

Reporting

• Prerequisite Information
• Reporting Lab Overview
• Participant List Reporting
• Certificate Confirmation
• Invoice Posting
• Creating the Participant List Report (Lab)
• Creating the Certificate Confirmation Report (Lab)
• Creating the Invoice Posting Report (Lab)

Statistics

• Using FlowFilters and FlowFields
• Using FlowFilters in Calculation Formulas
• Creating FlowFields for Sums (Lab)
• Creating the Seminar Statistics Form (Lab)

Dimensions

• 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
• Modifying the DimensionManagement Codeunit (Lab)
• Modifying the Tables and Forms for Dimensions in Master Files (Lab)
• Modifying the Tables for Dimensions in Seminar Registrations (Lab)
• Modifying the Forms for Dimensions in Seminar Registrations (Lab)
• Modifying the Tables and Forms for Dimensions in Posted Seminar Registrations (Lab)
• Modifying the Tables, Codeunits and Forms for Dimensions in Seminar Posting (Lab)
• Modifying the Create Seminar Invoices Report for Dimensions (Lab)

Interfaces

• Using an Automation Server
• Using Custom (or OCX) Controls
• XMLPort Triggers
• File Handling
• E-mail Confirmation
• XML Participant List
• Creating E-mail Confirmations (Lab)
• Creating the XML Sem. Reg.-Participant List (Lab)

Deployment

• Deployment Tasks
• Ongoing Support Phase
• Creating Contact Dataport (Lab)

Optimizing SQL Server

• 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