[Download] "SQL Server for Node.js" by Agus Kurniawan ~ Book PDF Kindle ePub Free

eBook details

Title: SQL Server for Node.js
Author : Agus Kurniawan
Release Date : January 19, 2013
Genre: Computers,Books,Computers & Internet,
Pages : * pages
Size : 5022 KB

Description

Microsoft SQL Server provides many features for data manipulation. Now you can access SQL Server from Node.js application. This book helps you how to get started with Node.js and SQL Server. It covers how to prepare your development environment.

***TOC***

1. Preparing Development Environment

2. Hello World - Connecting to Database Server

2.1 Database Configuration

2.2 Development Tools

2.3 Connectivity Testing

3. Database Table Operations

3.1 What are Table Operations?

3.2 Database Connection String

3.3 Inserting Data

3.4 Reading Data

3.5 Updating Data

3.6 Deleting Data

3.7 Finding Data

4. Stored Procedures

4.1 Creating Stored Procedure

4.2 Executing a Stored Procedure

4.3 Stored Procedure with Parameters

5. Working with Image and Binary Data

5.1 Image and Binary Data

5.2 Inserting Data

5.3 Reading Data

5.4 Deleting Data

6. Transactions

6.1 What is a Transaction?

6.2 Case 1 - Data Processing without Transaction

6.3 Case 2 - Data Processing with Transaction