Azure, Node.js, and SQL Server


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
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 (hours)
2.1

Lesson Objectives

Azure, Node.js, and SQL Server

  • start the course
  • describe how to use Node.js with SQL
  • use the Microsoft driver for Node.js and SQL Server
  • identify and describe the key modules used with Node.js for working with SQL Server
  • list and describe the JavaScript Object Notation or JSON to SQL data type mapping for Node.js
  • create a Node.js application using restify
  • demonstrate how to use stored procedures with Node.js
  • use .NET code in a Node.js application to query SQL Server
  • identify the key features of the Azure Software Development Kit or SDK for Node.js
  • create a basic Node.js application for Azure and deploy to Azure using Azure command line tools
  • create a basic Node.js application for Azure using Azure Software Development Kit or SDK for Node.js
  • use the Azure emulator to run a Node.js application
  • perform a Node.js deployment to Azure
  • demonstrate how to use Express with Azure
  • demonstrate how to remove a Node.js application from Azure
  • identify the key features of the Azure table service
  • use the Azure Storage Software Development Kit or SDK for Node.js in an application
  • create tables with the Azure table service
  • describe how to use entities in Node.js with SQL
  • demonstrate how to work with multiple entities and the Azure table service
  • describe how to query entities
  • describe how to delete entities and tables
  • create a Node.js application for Azure

    • Course Number:
    sl_adnj_a03_it_enus

    Expertise Level
    Intermediate