Managed Business & IT Training Solutions

MBIT Training Ltd

Using SQL or SQL Azure with Microsoft Dynamics NAV 2016 (80869)

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.
SKU: 80869
GTIN: 80869
Manufacturer: Microsoft
£500.00 (GBP)

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.

Learning 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

Prerequisites

Before viewing this training, individuals must have;

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