80869 : Using SQL or SQL Azure with Microsoft Dynamics NAV 2016

This course describes how to use SQL Server and Azure SQL with Microsoft Dynamics NAV 2016. This includes installation considerations, how to configure SQL Authentication, how to deploy on Azure SQL database, optimizing SQL Server performance, and troubleshooting the SQL Server. Topics covered in this eLearning course include: Module 00: Course Introduction Module 01: Installation Considerations for Microsoft SQL Server Module 02: Configuring Database Components Module 03: Configuring SQL Authentication Between the Microsoft Dynamics NAV Server and Database Module 04: Deploying a Microsoft Dynamics NAV Database to Azure SQL Database Module 05: Optimizing SQL Performance with Microsoft Dynamics NAV Module 06: Maintenance Microsoft NAV on Microsoft SQL Module 07: Maintenance Microsoft NAV on Azure SQL Module 08: Troubleshooting the SQL Server Issues Module 09: Course Review

Module 00: Course Introduction Module 01: Installation Considerations for Microsoft SQL Server Module 02: Configuring Database Components Module 03: Configuring SQL Authentication Between the Microsoft Dynamics NAV Server and Database Module 04: Deploying a Microsoft Dynamics NAV Database to Azure SQL Database Module 05: Optimizing SQL Server Performance with Microsoft Dynamics NAV Module 06: Maintenance Microsoft Dynamics NAV on Microsoft SQL Module 07: Maintenance Microsoft Dynamics NAV on Azure SQL Module 08: Troubleshooting the SQL Server Issues

Setup Options for Microsoft SQL Server Using the Microsoft Azure SQL Database Configure Database Components in Setup Setting a Database Owner and Security Administration Permissions Starting the SQL Browser Service Create a Database User Create and Configure a SQL Database Server in Azure Create a Full SQL Database Backup Working with the License File Troubleshoot SQL Server Issues

General knowledge of Microsoft Windows Basic knowledge of SQL Server and SQL Azure Knowledge of Microsoft Dynamics NAV