Node.js Web Development: Edition 3

Packt Publishing Ltd
1
Free sample

Create real-time server-side applications with this practical, step-by-step guideAbout This Book
  • Learn about server-side JavaScript with Node.js and Node modules through the most up-to-date book on Node.js web development
  • Understand website development both with and without the Connect/Express web application framework
  • Develop both HTTP server and client applications
Who This Book Is For

This book is for anybody looking for an alternative to the "P" languages (Perl, PHP, and Python), or anyone looking for a new paradigm of server-side application development. You should have at least a rudimentary understanding of JavaScript and web application development.

What You Will Learn
  • Install and use Node.js for both development and deployment
  • Use the Express application framework
  • Configure Bootstrap for mobile-first theming
  • Use data storage engines such as MySQL, SQLITE3, and MongoDB
  • Understand user authentication methods, including OAuth, with third-party services
  • Deploy Node.js to live servers, including microservice development with Docker
  • Perform unit testing with Mocha
  • Perform functional testing of the web application with CasperJS
In Detail

Node.js is a server-side JavaScript platform using an event driven, non-blocking I/O model allowing users to build fast and scalable data-intensive applications running in real time. Node.js Web Development shows JavaScript is not just for browser-side applications. It can be used for server-side web application development, real-time applications, microservices, and much more.

This book gives you an excellent starting point, bringing you straight to the heart of developing web applications with Node.js. You will progress from a rudimentary knowledge of JavaScript and server-side development to being able to create and maintain your own Node.js application. With this book you'll learn how to use the HTTP Server and Client objects, data storage with both SQL and MongoDB databases, real-time applications with Socket.IO, mobile-first theming with Bootstrap, microservice deployment with Docker, authenticating against third-party services using OAuth, and much more.

Style and Approach

This book is a practical guide for anyone looking to develop striking and robust web applications using Node.js.

Read more

About the author

David Herron has worked as a software engineer in Silicon Valley for over 20 years. This includes companies both tiny and large. He has worked on a wide variety of projects, from an X.400 e-mail server and client application to assisting with the launch of the OpenJDK project (open source Java rocks), to Yahoo's Node.js application-hosting platform (Mojito and Manhattan), and applications to monitor solar power array performance. While a staff engineer at Sun Microsystems, David worked as the architect of the Java SE Quality Engineering team where he focused on test automation tools, including co-developing the AWT Robot class. He was involved in open source activities related to Java, including the OpenJDK project. Before Sun, he worked for VXtreme on software which eventually became Windows Media Player when Microsoft bought the company. At Mainsoft, David worked on a library that allowed developers to recompile Windows applications on Unix, and then participated in porting Internet Explorer to Unix. At The Wollongong Group, he worked on both e-mail client and server software and was part of several IETF working groups improving e-mail-related protocols. David is interested in electric vehicles, world energy supplies, climate change, and environmental issues, and he is a co-founder of Transition Silicon Valley. As an online journalist, he writes about electric cars and other green technology on LongTailPipe.com after having written for PlugInCars.com. He runs a large electric vehicle discussion website on VisForVoltage.org, and he blogs about other topics, including Node.js, Drupal, and Doctor Who on DavidHerron.com. Using Node.js, he developed a Content Management System that produces static HTML websites or EPUB3 eBooks, AkashaCMS (akashacms.com).

Read more
5.0
1 total
Loading...

Additional Information

Publisher
Packt Publishing Ltd
Read more
Published on
Jun 27, 2016
Read more
Pages
376
Read more
ISBN
9781785885419
Read more
Language
English
Read more
Genres
Computers / Databases / Servers
Computers / Programming Languages / JavaScript
Computers / Web / General
Read more
Content Protection
This content is DRM free.
Read more
Read Aloud
Available on Android devices
Read more

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
Perfect for end users, analysts,  data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Learn the core language for standard SQL, and variations for the most widely used database systems.

- Organize your database in terms of the relational model.

- Master tables, columns, rows, and keys.

- Retrieve, sort, and format data.- Filter the data that you don't want to see.

- Convert and manipulate data with SQL's built-in functions and operators.

- Use aggregate functions to summarize data.

- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.

- Create, alter, and drop tables, indexes, and views.

- Insert, update, delete, and merge data.

- Execute transactions to maintain the integrity of your data.

- Avoid common pitfalls involving nulls.

- Troubleshoot and optimize queries.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

Introduction

1. Running SQL Programs

2. The Relational Model

3. SQL Basics

4. Retrieving Data from a Table

5. Operators and Functions

6. Summarizing and Grouping Data

7. Joins

8. Subqueries

9. Set Operations

10. Inserting, Updating, and Deleting Rows

11. Creating, Altering, and Dropping Tables

12. Indexes

13. Views

14. Transactions


Get up to speed fast with SQL, the language of databases. Bestselling author Chris Fehily teaches you just the parts of SQL that you need to know. Quick, learn-by-example lessons start with simple data retrieval and sorting, move on to filtering and grouping, and then build to more-advanced topics, including joins, subqueries, views, and transactions. Whether you're an analyst, developer, data scientist, or Microsoft Office user, you'll find straightforward, practical answers. You can download the sample database to follow along with the examples.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Learn the core language for standard SQL, and variations for the most widely used database systems.

- Organize your database in terms of the relational model.

- Master tables, columns, rows, and keys.

- Retrieve, sort, and format data.

- Filter the data that you don't want to see.

- Convert and manipulate data with SQL's built-in functions and operators.

- Use aggregate functions to summarize data.

- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.

- Create, alter, and drop tables, indexes, and views.

- Insert, update, delete, and merge data.

- Execute transactions to maintain the integrity of your data.

- Avoid common pitfalls involving nulls.

- Troubleshoot and optimize queries.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

1. Introduction

2. Database Basics

3. SQL Basics

4. Retrieving Data from a Table

5. Sorting Rows

6. Filtering Rows

7. Combining and Negating Conditions

8. Pattern Matching

9. More Ways to Filter Rows

10. Operators and Functions

11. Working with Functions

12. Evaluating Conditional Values

13. Summarizing Data

14. Grouping Data

15. Joining Tables

16. Working with Joins

17. Subqueries

18. Combining Queries

19. Inserting Rows

20. Updating and Deleting Rows

21. Creating and Changing Tables

22. Indexes

23. Views

24. Transactions

A. The Sample Database

B. Running SQL Programs

C. Data Types


This cookbook of advanced techniques is for anyone who knows the basics of SQL and wants to move beyond simple SELECT-FROM-WHERE queries. You'll find solutions to problems that analysts, app developers, and database programmers often face, from simple tasks, like picking random rows, to complex operations, like traversing hierarchies. Each recipe includes a discussion of the underlying logic, important concepts, and best practices. Take full advantage of standard (ANSI/ISO) SQL, or use DBMS-specific features that dramatically extend the power of standard SQL. Use the scores of code examples directly in real-world DBMS applications, or as a source of insight for related problems.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Implement cross-platform solutions in standard SQL, or DBMS-specific solutions for your particular system.

- Full-color SQL code listings help you see the elements and structure of the language.

- Download the sample database and code listings to follow along with the author's examples.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

Introduction

1. Running SQL Programs

2. Calculating Running Statistics

3. Generating Sequences

4. Finding Sequences, Runs, and Regions

5. Limiting the Number of Rows Returned

6. Assigning Ranks

7. Calculating a Trimmed Mean

8. Picking Random Rows

9. Handling Duplicates

10. Creating a Telephone List

11. Retrieving Metadata

12. Working with Dates

13. Calculating a Median

14. Finding Extreme Values

15. Changing Running Statistics Midstream

16. Pivoting Results

17. Working with Hierarchies


Create real-time applications using Node.js 10, Docker, MySQL, MongoDB, and Socket.IO with this practical guide and go beyond the developer's laptop to cover live deployment, including HTTPS and hardened security.Key FeaturesLearn server-side JavaScript coding through the most up-to-date book on Node.jsExplore the latest JavaScript features, and EcmaScript modulesWalk through different stages of developing robust applications using Node.js 10Book Description

Node.js is a server-side JavaScript platform using an event-driven, non-blocking I/O model allowing users to build fast and scalable data-intensive applications running in real time.

This book gives you an excellent starting point, bringing you straight to the heart of developing web applications with Node.js. You will progress from a rudimentary knowledge of JavaScript and server-side development to being able to create, maintain, deploy and test your own Node.js application.You will understand the importance of transitioning to functions that return Promise objects, and the difference between fs, fs/promises and fs-extra. With this book you'll learn how to use the HTTP Server and Client objects, data storage with both SQL and MongoDB databases, real-time applications with Socket.IO, mobile-first theming with Bootstrap, microservice deployment with Docker, authenticating against third-party services using OAuth, and use some well known tools to beef up security of Express 4.16 applications.

What you will learnInstall and use Node.js 10 for both development and deploymentUse the Express 4.16 application frameworkWork with REST service development using the Restify frameworkUse data storage engines such as MySQL, SQLITE3, and MongoDBUse User authentication methods with OAuth2Perform Real-time communication with the front-end using Socket.IOImplement Docker microservices in development, testing and deployment Perform unit testing with Mocha 5.x, and functional testing with Puppeteer 1.1.xWork with HTTPS using Let’s Encrypt, and application security with HelmetWho this book is for

This book is for anybody looking for an alternative to the "P" languages (Perl, PHP, and Python), or anyone looking for a new paradigm of server-side application development. You should have at least a rudimentary understanding of JavaScript and web application development.

©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.