MS SQL for MS Nav Partners

  • Article

We have a great new SQL for NAV course running on Feb 26 - 29 2008. The agenda is just what a lot of the NAV partners have been asking for.

If you are interested book up fast as spaces are filling up rapidly.

Summary:
The Microsoft Dynamics NAV paradigm shift of introducing the role based client and replacing the NAV Database Server option with the Microsoft SQL Server option requires new skills.
This course is specifically designed for MS Navision Partners, covering MS SQL fundamentals to performance optimisation & troubleshooting.
Intended Audience:
The intended audience for this course is partners wanting to learn how to troubleshoot and optimize the interface between NAV and SQL Server.

The class is targeted towards developers, consultants and implementers who need to understand the interface between NAV and SQL Server to be able to develop efficient customizations or maintain existing installations for optimal performance.
Objectives:
After completing this course, students should be able to:

- Perform fundamental configurations of SQL Server 2005.
- Clearly identify the steps needed to install and setup the NAV SQL Server option.
- Convert an existing NAV Database Server database to a SQL Server database.
- Understand the fundamentals of Transact-SQL and use this knowledge to optimize NAV
  C/AL Code.
- Use SQL Profiler to troubleshoot performance issues.
- Optimize key usage and C/AL code in NAV by using existing and new properties and
  C/AL commands.
- Replace inefficient C/AL code with highly efficient Transact-SQL commands executed
  directly on SQL Server via the automation server functionality in NAV.
- Use different tools for troubleshooting and optimizing performance in NAV, e.g. client
  monitor and code coverage.
Agenda:
Day 1 – SQL Server Fundamentals

Introduction to SQL Server 2005
Physical Structure and Configure
Backup and Restore
Index
Statistics

Day 2 – SQL Server Fundamentals continued

Dynamic Views
Profiler
Database Engine Tuning Advisor
Execution Plans
TSQL-Language
Stored Procedure
Function
Trigger
Transactions
Lock

Day 3 – NAV Development

Key properties
Lock tables/records
C/AL commands
Conversion of statements
Developer’s toolkit

Day 4 – NAV Debugging & Tuning

Code coverage
Client Monitor
Performance toolkit
Session monitor
Key properties

https://training.partner.microsoft.com/plc/details.aspx?publisher=12&delivery=237728