 |
Introduction |
|
Audience |
|
At course completion |
|
Prerequisites |
|
Microsoft Certified Professional exams |
|
Course materials |
|
Course outline |
|
Take this training |
Elements of this syllabus are subject to change.
This two-day course is designed for students who are preparing to complete the installation and configuration of Microsoft Dynamics NAV. The course primarily provides explanation of the databases and servers associated with Microsoft Dynamics NAV, client hardware and software requirements, and various database administrative tasks.
This course is intended for Microsoft Dynamics Partner professionals and Consultants who are responsible for the installation and configuration of a customer’s hardware and software environment.
After completing this course, students will be able to:
| • | Understand the architecture |
| • | Know hardware and software requirements |
| • | Complete Microsoft Dynamics NAV Client installation |
| • | Install and configure the Microsoft Dynamics NAV Database Server |
| • | Connect to the Microsoft Dynamics NAV SQL Server 2005 option |
| • | Install and configure Microsoft Dynamics NAV Application Server |
| • | Know the Microsoft Dynamics NAV ODBC driver |
| • | Comprehend Microsoft Dynamics NAV security |
| • | Use Database Administration tools |
| • | Understand Microsoft Dynamics NAV optimization |
| • | Troubleshoot Microsoft Dynamics NAV |
Before attending this course, students must have:
| • | A strong understanding of clients and servers |
| • | A strong understanding of Microsoft SQL Server 2005 |
In addition, it is recommended, but not required, that students understand the Microsoft Dynamics NAV development environment.
No Microsoft Certified Professional exams are associated with this course currently.
| • | The manual includes examples and scenarios for the class to complete together and exercises for the students to complete to emphasize important points. Students should use Microsoft Dynamics NAV 5.0 database or later. |
Chapters 1: Microsoft Dynamics NAV Architecture
This chapter focuses on the two server options. It describes the important differences between the two options and explains the various layers of security that exist in Microsoft Dynamics NAV and how they work.
Main topics
| • | The Microsoft Dynamics NAV client/server wnvironment |
| • | The server options |
| • | The Microsoft Dynamics NAV security model |
After completing this module, students will be able to:
| • | Explain the client/server environment |
| • | Explain the Microsoft Dynamics NAV security model |
Chapter 2: Hardware and Software Requirements
Before you begin installing and configuring Microsoft Dynamics NAV, you need to consider the network, database, and server needs and clarify any questions with your customer. This chapter leads you through the database, server, and client installation decisions necessary for a successful implementation.
Main topics
| • | Choosing the Installation Type and Equipment Useful controls |
| • | Hardware and software requirements creating buttons |
| • | 2-Tier and n-Tier solutions |
After completing this module, students will be able to:
| • | Choose the installation type |
| • | Choose the correct equipment |
| • | Know what tier solution to choose |
Chapter 3: Microsoft Dynamics NAV Client Installation
This chapter focuses on how to install, maintain, and remove Microsoft Dynamics NAV single-users and clients. This chapter also describes the basic operations involved in working with a database, and license information.
Main topics
| • | Installing the Microsoft Dynamics NAV Client |
| • | Classic Client configuration |
After completing this module, students will be able to:
| • | Install the Classic Client |
| • | Configure the Classic Client |
Chapter 4: Microsoft Dynamics NAV standard Database Server
This chapter discusses the Microsoft Dynamics NAV database server. You are shown how to run more than one server. The chapter reviews system setup options and some basic operations involved in working with a database.
Main topics
| • | Installing a Microsoft Dynamics NAV Database Server |
| • | Importing a database into Microsoft Dynamics NAV Database Server |
| • | Standard Database Server setup properties |
| • | Standard Database Server Manager |
| • | Working with databases |
After completing this module, students will be able to:
| • | Install a Microsoft Dynamics NAV Database Server |
| • | Install and run more than one server at a time |
| • | Work with the Microsoft Dynamics NAV program properties |
Chapter 5: Microsoft Dynamics NAV SQL Server 2005 Option
This chapter describes how to install Microsoft SQL Server. You are shown how to customize the system defaults according to customer requirements. The chapter discusses license files and security and user setup options.
Main topics
| • | SQL Server option properties |
| • | Database administration |
| • | Using the database |
| • | Security and user setup |
After completing this module, students will be able to:
| • | Install and configure a SQL Server 2005 option |
| • | Install clients at a customer's site |
| • | Work with databases |
| • | Create and maintain a database |
| • | Set up Microsoft Dynamics NAV security |
Chapter 6: Microsoft Dynamics NAV ODBC Driver
This chapter describes the terminology used in Open Database Connectivity (ODBC). It walks you through the installation and configuration processes of ODBC. This chapter includes the technical documents and a SQL statement reference guide.
Main topics
| • | Installation |
| • | Configuration |
After completing this module, students will be able to:
| • | Know the ODBC terminology |
| • | Discuss the ODBC driver functionality |
| • | Discuss data types |
| • | Install the multilanguage functionality |
Chapters 7: Microsoft Dynamics NAV Security
This chapter describes the security systems that protect your database and the information that it contains from being accessed by unauthorized people. It also allows you to specify what the authorized users are allowed to do in the database—based on the permissions.
Main topics
| • | Authentication in Microsoft Dynamics NAV |
| • | Active Directory Service security |
| • | Logins, roles, and permissions |
| • | Applying security filters in SQL Server |
| • | User specific setups |
| • | Additional Active Directory security features |
After completing this module, students will be able to:
| • | Discuss the types of authentication |
| • | Install the Active Directory Service |
| • | Apply logins, roles, and permissions to the system |
| • | Configure user specific setups |
Chapter 8: Standard and SQL Database Administration
This chapter presents the administration of the Standard and SQL Database. This chapter also shows you how to manage the database and familiarizes you with the tools that Microsoft Dynamics NAV provides. This chapter contains guidelines for maintaining Microsoft Dynamics NAV databases on both the Database Server and SQL Server. Content includes when and how to back up your Microsoft Dynamics NAV data, guidelines for maintaining SQL Server statistics that are used to optimize performance, and information about advanced features.
Main topics
| • | Managing the databases |
| • | Back up and restore in the Standard Database |
| • | Backup and restore in the SQL Database |
| • | Advanced backup and restore information |
| • | Maintaining statistics |
After completing this module, students will be able to:
| • | Understand the management features for the database |
| • | Know how to back up and restore the Standard Database |
| • | Understand how to back up and restore the SQL Database |
| • | Learn to maintain database statistics |
Chapters 9 Microsoft Dynamics NAV Database Optimization
This chapter helps you optimize the Standard Database and the SQL Database. You will learn how database efficiency works as well as database compression and SQL Server optimization tools
Main topics
| • | Advanced database information |
| • | Database efficiency on the Standard Server |
| • | Database efficiency on the SQL Server option |
| • | Database compression |
| • | SQL Server optimization tools |
After completing this module, students will be able to:
| • | Learn how to access Advanced Database information |
| • | Increase efficiency in the Dynamics NAV database and a SQL database |
| • | Learn how database compression works |
| • | Understand the SQL Server tools for optimization |
Chapter 10: Troubleshooting Microsoft Dynamics NAV
This chapter is designed to help you identify performance problems in a Microsoft Dynamics NAV application. It describes how to troubleshoot issues for both server options, and explains how to use the debugging tools that exist in Microsoft Dynamics NAV to identify performance problems.
Main topics
| • | Setting up a test environment |
| • | Identifying performance problems |
| • | Identifying lock issues |
| • | Determining bottlenecks within the Microsoft Dynamics NAV system |
After completing this module, students will be able to:
| • | Set up a test environment |
| • | Identify performance problems and isolate them |
| • | Identify lock issues |
| • | Determine where bottlenecks exist in the system and correct them |
Chapter 11: Online Map Integration
This chapter discusses the process of setting up and using Online Map functionality in Microsoft Dynamics NAV.
Main topics
| • | Online Map setup |
| • | Looking up a customer |
| • | Printing a Routing Plan to a customer site |
| • | Navigating in Online Map |
| • | Defining forms for Online Map functionality |
After completing this module, students will be able to:
| • | Integrate Online Map functionality into the Microsoft Dynamics NAV client |
| • | Look up a customer and print a routing plan |
| • | Define additional forms for Online Map functionality |
Chapters 12: Microsoft Dynamics NAV Outlook Synchronization
This chapter describes how Outlook synchronization works, including the Synchronization Basics and Levels. Typical administration scenarios are discussed as well as the Synchronization Add-in.
Main topics
| • | Synchronization Basics |
| • | Synchronization Levels |
| • | Synchronization user setup |
| • | Typical administration scenarios |
| • | The Synchronization Add-in |
| • | Synchronization |
After completing this module, students will be able to:
| • | Understand how Outlook synchronization works in Microsoft Dynamics NAV |
| • | Set up synchronization |
| • | Perform synchronization |
Chapter 13: Microsoft Dynamics NAV Application Server (NAS)
This chapter describes how to install and maintain Microsoft Dynamics NAV Application Server, which handles the exchange of documents between Microsoft Dynamics NAV and external services, such as CRM or e-commerce Products.
Main topics
| • | Application Server installation and maintenance |
| • | Application Server setup properties |
| • | Application Server Manager |
| • | Microsoft Dynamics NAV Automated Data Capture System (ACDS) |
After completing this module, students will be able to:
| • | Install a Microsoft Dynamics NAV Application Server |
| • | Configure the NAS |
| • | Discuss the requirements and setup of ACDS |
