Describe the Data and Process Models (10-15 percent)
- Explain the table types and characteristics.
- This topic may include: explain the characteristics of master tables, supplemental tables, subsidiary tables, ledger tables, register tables, journal tables, document tables, document history tables, and setup tables
- Describe the standard data model and process model.
- This topic may include: describe the data model diagram; describe standard data flow and typical data triggers
Implement Master Tables, Pages, and Documents (10-15 percent)
- Track participants.
- This topic may include: develop participant tracking solutions; describe triggers and multi-language support
- Manage seminars, instructors, and rooms.
- This topic may include: describe seminar management; explain a setup table, master tables, and pages; design seminar management solutions; develop solutions to manage instructors and rooms; create seminar tables and pages
- Implement documents.
- This topic may include: describe registrations; design a solution for registrations; develop registrations; use objects as text files; describe multi-language functionality in text messages; explain document pages, page functions, virtual tables, temporary tables, and system tables
- Describe the table code.
- This topic may include: describe seminar registration line table code, the seminar charge table, the seminar comment line table, and pages.
Implement Posting and Dimensions (10-15 percent)
- Explain posting and develop a posting solution.
- This topic may include: describe the journal, ledger, register, tables, and pages; identify journal posting codeunits; explain the journal and document posting processes; describe the example posting routine, existing objects, and code comments; diagnose performance issues; create journal and document posting routines; create and modify codeunits, tables, and pages for a posting solution; complete the journal and ledger tables registration posting; create codeunits and pages for seminar journal posting; create tables and pages for posted registration information; modify tables, pages, and codeunits for resource posting; create codeunits for document posting
Integrate seminar management with dimensions.
- This topic may include: choose dimension types; set up dimensions; describe the dimensions data model; design and develop integration of seminar management with dimensions
Implement Feature Integration and Role Tailoring (10-15 percent)
- Integrate seminar-management features.
- This topic may include: modify tables that contain data; design and develop seminar feature integration
- Enable the Navigate feature.
- This topic may include: describe Navigate feature architecture; develop solutions for the Navigate feature; integrate objects with the Navigate feature
- Explain role tailoring.
- This topic may include: describe the RoleTailored user interface, Role Center, actions, ribbon, activities, lists, charts, and profiles
- Develop the seminar manager Role Center and department page.
- This topic may include: design seminar manager Role Center solutions; develop seminar management department pages
- Create and design MenuSuite objects.
- This topic may include: describe the fundamentals of the MenuSuite object type; explain the design levels; create and design MenuSuite objects; explain how searching functions by using the Microsoft Dynamics NAV 2013 Windows client
Create Reports and Manage Statistics (10-15 percent)
- Design and create a participant list report.
- This topic may include: design and analyze solutions; differentiate between GUI design, functional design, and table design; create seminar participant lists
- Develop invoice posting batch jobs.
- This topic may include: design and analyze solutions; create invoice posting batch jobs
- Manage seminar statistics.
- This topic may include: design and analyze solutions; add statistics to the Seminar Management module; create FlowFields of the Sum type; create seminar statistics pages
Implement Interfaces and Web Services (10-15 percent)
- Automate email communication with participants.
- This topic may include: explain how to implement automation and OCX controls to perform tasks by using other applications; describe file handling functions to import or export data; design and implement email capability
- Explain web services.
- This topic may include: explain web services architecture, SOAP web services, page operations with SOAP web services, extension codeunits, and OData web services; handle user interface interactions
- Develop a web service.
- This topic may include: design, develop, and test registration web services; create web services; create Windows form applications to test web services
Test and Debug Code (10-15 percent)
- Test the seminar management solution.
- This topic may include: describe test-driven development fundamentals; test features, codeunits, and functions; explain transaction models for test functions; describe the use of ASSERTERROR in test functions; use handler functions; test pages; create and run a test runner codeunit; design and develop seminar management test solutions; create seminar management unit tests
- Debug code.
- This topic may include: activate the Microsoft Dynamics NAV Debugger; use breakpoints; run and track code
Optimize for SQL Server (10-15 percent)
- Explain SQL Server integration and database tasks with Microsoft Dynamics NAV.
- This topic may include: explain the advantages of using SQL Server for Microsoft Dynamics NAV 2013; describe Microsoft Dynamics NAV tables and indexes in SQL Server; explain how to share data across companies; obtain a list of indexes and their definitions
- Use collation, the SQL Server Profiler, and the SQL Server query optimizer.
- This topic may include: describe collation; order by sort; describe the value of the SQL Server query optimizer; gather SQL Server statistics; explain SQL Server Profiler terminology
- Optimize a Microsoft Dynamics NAV application.
- This topic may include: optimize SumIndexField Technology (SIFT) tables and indexes; describe the index usage query; define keys to improve performance; describe implicit and explicit locking; identify problems with NEXT; define suboptimal coding and other performance penalties; analyze index usage; optimize C/AL code
- Explain data access redesign.
- This topic may include: describe simplified deployment; explain decreased resource consumption; identify caching; describe performance improvements
- Describe C/AL database functions and performance on SQL Server.
- This topic may include: describe the GET, FIND, NEXT, CALCFIELDS, CALCSUMS, COUNT, SETAUTOCALCFIELDS, INSERT, MODIFY, DELETE, and LOCKTABLE functions; explain dynamic result sets
- Describe bulk inserts, locking, blocking, and deadlocks.
- This topic may include: describe bulk inserts; identify bulk insert constraints; describe locking, blocking, and deadlocks; explain the benefits of avoiding deadlocks
- Describe SIFT data storage in SQL Server.
- This topic may include: identify SIFT data storage in SQL Server