Azure, Node.js, and SQL Server

This course is included in our On-demand training solution.

Overview

Node.js and the .NET Framework can work together to develop efficient, secure, and distributed applications. In this course, you will learn how to use Node.js with SQL Server and Microsoft Azure. Specifically, you’ll explore how to use Node.js with SQL Server to connect to and work with SQL Server data. You’ll also explore the Azure Software Development Kit or SDK for Node.js and learn how to create and deploy Node.js applications to Azure. Lastly, you’ll explore how to use the Azure Table Service with Node.js applications.

Target Audience

.NET developers seeking an introductory guide to develop efficient, secure, and distributed applications that bridge the gap between Node.js and the .NET Framework

Prerequisites

None

Expected Duration

120 min.

Course Objectives

Course Introduction

Using Node.js with SQL Server

  • describe how to use Node.js with SQL
  • Microsoft Driver for Node.js for SQL Server

  • use the Microsoft driver for Node.js and SQL Server
  • Node.js Modules for SQL Server

  • identify and describe the key modules used with Node.js for working with SQL Server
  • Mapping JSON to SQL Data Types for Node.js

  • list and describe the JavaScript Object Notation or JSON to SQL data type mapping for Node.js
  • Using Restify with SQL Server

  • create a Node.js application using restify
  • Using Stored Procedures with Node.js

  • demonstrate how to use stored procedures with Node.js
  • Using .NET Code to Query SQL Server for Node.js

  • use .NET code in a Node.js application to query SQL Server
  • The Azure SDK for Node.js

  • identify the key features of the Azure Software Development Kit or SDK for Node.js
  • Deploying Node Apps Using Azure Command Line Tools

  • create a basic Node.js application for Azure and deploy to Azure using Azure command line tools
  • Creating a Basic Node Application for Azure

  • create a basic Node.js application for Azure using Azure Software Development Kit or SDK for Node.js
  • Using the Azure Emulator

  • use the Azure emulator to run a Node.js application
  • Deploying Node.js Applications to Azure

  • perform a Node.js deployment to Azure
  • Using Express on Azure

  • demonstrate how to use Express with Azure
  • Removing Node.js Applications from Azure

  • demonstrate how to remove a Node.js application from Azure
  • The Azure Table Service

  • identify the key features of the Azure table service
  • Using the Azure Storage SDK for Node.js

  • use the Azure Storage Software Development Kit or SDK for Node.js in an application
  • Creating Tables with the Azure Table Service

  • create tables with the Azure table service
  • Using Entities

  • describe how to use entities in Node.js with SQL
  • Working with Multiple Entities

  • demonstrate how to work with multiple entities and the Azure table service
  • Querying Entities

  • describe how to query entities
  • Deleting Entities and Tables

  • describe how to delete entities and tables
  • Exercise: Creating a Node.js Application for Azure

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?