Course Overview
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
Course Outline
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
Course Objectives
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
Pre-requisites
General knowledge of Microsoft Windows
Basic knowledge of SQL Server and SQL Azure
Knowledge of Microsoft Dynamics NAV