Sams Teach Yourself NoSQL with MongoDB in 24 Hours

Teach Yourself NoSQL with MongoDB in 24 Hours (Learning Lab)

Author: Brad Dayley
Publisher: Sams Publishing
ISBN: 978-0-13-390299-0
Copyright © 2015 by Pearson Education, Inc.

Contents at a Glance

Introduction

Part I: Getting Started with NoSQL and MongoDB

Hour 1: Introducing NoSQL and MongoDB

Hour 2: Installing and Configuring MongoDB

Hour 3: Using JavaScript in the MongoDB Shell

Part II: Implementing NoSQL in MongoDB

Hour 4: Configuring User Accounts and Access Control

Hour 5: Managing Databases and Collections from the MongoDB Shell

Hour 6: Finding Documents in the MongoDB Collection from the MongoDB Shell

Hour 7: Additional Data-Finding Operations Using the MongoDB Shell

Hour 8: Manipulating MongoDB Documents in a Collection

Hour 9: Utilizing the Power of Grouping, Aggregation, and Map Reduce

Part III: Using MongoDB in Applications

Hour 10: Implementing MongoDB in Java Applications

Hour 11: Accessing Data from MongoDB in Java Applications

Hour 12: Working with MongoDB Data in Java Applications

Hour 13: Implementing MongoDB in PHP Applications

Hour 14: Accessing Data from MongoDB in PHP Applications

Hour 15: Working with MongoDB Data in PHP Applications

Hour 16: Implementing MongoDB in Python Applications

Hour 17: Accessing Data from MongoDB in Python Applications

Hour 18: Working with MongoDB Data in Python Applications

Hour 19: Implementing MongoDB in Node.js Applications

Hour 20: Accessing Data from MongoDB in Node.js Applications

Hour 21: Working with MongoDB Data in Node.js Applications

Part IV: Additional MongoDB Concepts

Hour 22: Database Administration Using the MongoDB Shell

Hour 23: Implementing Replication and Sharding in MongoDB

Hour 24: Implementing a MongoDB GridFS Store

Introduction

With billions of people using the Internet today, traditional RDBMS database solutions have difficulty meeting the rapidly growing need to handle large amounts of data. The growing trend is to introduce specialized databases that are not restricted to the conventions and the legacy overhead of traditional SQL databases. These databases are given the term NoSQL, meaning “Not Only SQL.” They are designed not to replace SQL databases, but to provide a different perspective in storing data.

This Learning Lab teaches you the concepts of NoSQL through the MongoDB perspective. MongoDB is a NoSQL database that has a reputation for being easy to implement while still robust and scalable. It is currently the most popular NoSQL database in use. MongoDB has matured into a stable platform that several companies have leveraged to provide the data scalability they require.

Each hour in the Learning Lab provides fundamentals for implementing and using MongoDB as back-end storage for high-performing applications. As you complete the 24 one-hour lessons in this tutorial, you will gain practical understanding of how to build, use, and maintain a MongoDB database.

So pull up a chair, sit back, and enjoy the process of learning NoSQL through the perspective of MongoDB development.

How This Learning Lab Is Organized

This Learning Lab is organized into four main parts:

Part I, “Getting Started with NoSQL and MongoDB,” covers the basic concepts of NoSQL, why you might want to use it, and available database types. It also covers MongoDB data structures and design concepts and explores what it takes to get MongoDB installed and running.

Part II, “Implementing NoSQL in MongoDB,” discusses the fundamental basics for implementing MongoDB. The hours in this part focus on creating databases and collections. They also cover the different methods of storing, finding, and retrieving data from the MongoDB database.

Part III, “Using MongoDB in Applications,” introduces you to the MongoDB drivers for some of the most common programming environments. A MongoDB driver is a library that provides the necessary tools to programmatically access and use the MongoDB database. This section covers the drivers for Java, PHP, Python, and Node.js. Each programming language section is isolated, so if you have no interest in a particular language, you can skip its corresponding hour.

Part IV, “Additional MongoDB Concepts,” rounds out your knowledge of MongoDB by teaching you additional MongoDB concepts. In this part, you learn some of the basics of administrating MongoDB databases and look at more advanced MongoDB concepts such as replication, sharding, and GridFS storage.

Tip

Tips and tricks to save you precious time are set aside in Tip boxes so that you can spot them quickly.

Note

Note boxes highlight interesting information you want to be sure not to miss.

Caution

When you need to watch out for something, you’re warned about it in Caution boxes.

Code Examples

Two types of code examples appear in this tutorial. The most common are code snippets that appear in-line with the text to illustrate talking points. Try It Yourself sections also provide code examples. These examples are more robust and are designed to run as standalone mini applications. To keep the code examples small and easy to follow, they are compressed, with little or no error checking, for example.

The Try It Yourself examples are presented in listings that include line numbers to make them easier to follow. They also include a filename in the listing title to indicate which file the listing came from. If the code listing in the Try It Yourself section has specific output, a follow-up listing shows you the console output of the code so that you can follow along as you are reading.

Special Elements

As you complete each lesson, margin notes help you immediately apply what you just learned to your own web pages.

Whenever a new term is used, it is clearly highlighted—no flipping back and forth to a glossary.

Q&A, Quizzes, and Exercises

Every hour ends with a short question-and-answer session that addresses the kind of “dumb questions” all readers wish they dared to ask. A brief but complete quiz lets you test yourself to be sure you understand everything presented in the hour. Finally, one or two optional exercises give you a chance to practice your new skills before you move on.

Dedication

For D!

A & F

About the Author

Brad Dayley is a senior software engineer with more than 20 years of experience developing enterprise applications. He has designed and developed large-scale business applications, including SAS applications with NoSQL database back ends and rich Internet web applications as front ends. He is the author of the jQuery and JavaScript Phrasebook, Sams Teach Yourself jQuery and JavaScript in 24 Hours, and Node.js, MongoDB and AngularJS Web Development.

Acknowledgments

I’d like to take this page to thank all those who made this title possible. First, I thank my wonderful wife and boys for giving me the inspiration and support I need. I’d never make it far without you. Thanks to Mark Taber for getting this title rolling in the right direction, Russell Kloepfer for his technical review, and Melissa Schirmer for managing everything on the production end.

We Want to Hear from You!

As the reader of this Learning Lab, you are our most important critic and commentator. We value your opinion and want to know what we’re doing right, what we could do better, what areas you’d like to see us publish in, and any other words of wisdom you’re willing to pass our way.

You can email or write to let us know what you did or didn’t like about this Learning Lab—as well as what we can do to make our Learning Labs stronger.

Please note that we cannot help you with technical problems related to the topic of this Learning Lab, and that due to the high volume of mail we receive, we might not be able to reply to every message.

When you write, please be sure to include this Learning Lab’s title, edition number, and author, as well as your name and contact information.

Email: feedback@samspublishing.com

Mail:     Sams Publishing
              800 East 96^th Street
              Indianapolis, IN 46240 USA

Reader Services

Visit our website and register this Learning Lab at informit.com/register for convenient access to any updates, downloads, or errata that might be available.

Hour 1: Introducing NoSQL and MongoDB

What Is NoSQL?

Choosing RDBMS, NoSQL, or Both

Understanding MongoDB

MongoDB Data Types

Planning Your Data Model

Hour 2: Installing and Configuring MongoDB

Building the MongoDB Environment

Installing and Configuring MongoDB in Your Development Environment

Accessing the MongoDB HTTP Interface

Accessing MongoDB from the Shell Client

Scripting the MongoDB Shell

Running a MongoDB Shell Script from the Command Line

Hour 4: Configuring User Accounts and Access Control

Understanding the Admin Database

Administrating User Accounts

Creating Database User Accounts in the MongoDB Shell

Listing Users in a Database

Removing Users from a Database

Configuring Access Control

Implementing Access Control to the MongoDB Database

Summary

Q&A

Quiz

Exercises

Hour 5: Managing Databases and Collections from the MongoDB Shell

Understanding the Database and Collection Objects

Managing Databases

Creating a New Database

Deleting a Database

Getting the Stats of the MongoDB Database

Managing Collections

Creating a New Collection

Deleting a Collection from a Database

Implementing the Example Dataset

Creating the Example Dataset

Summary

Q&A

Quiz

Exercises

Hour 6: Finding Documents in the MongoDB Collection from the MongoDB Shell

Understanding the Cursor Object

Understanding Query Operators

Getting Documents from a Collection

Finding a Single Document in the MongoDB Shell

Retrieving Multiple Documents in the MongoDB Shell

Finding Specific Sets of Documents

Finding Specific Documents Using the MongoDB Shell

Summary

Q&A

Quiz

Exercises

Hour 7: Additional Data-Finding Operations Using the MongoDB Shell

Counting Documents

Counting the Number of Documents Represented by a Cursor in the MongoDB Shell

Sorting Results Sets

Sorting Documents Represented by a Cursor from the MongoDB Shell

Limiting Result Sets

Limiting Documents Represented by a Cursor in the MongoDB Shell

Limiting Which Document Fields are Returned from Find Requests in the MongoDB Shell

Paging Through Documents in a Collection from the MongoDB Shell

Finding Distinct Field Values

Retrieving Distinct Values for a Specific Field Using the MongoDB Shell

Summary

Q&A

Quiz

Exercises

Hour 8: Manipulating MongoDB Documents in a Collection

Understanding the Write Concern

Configuring Database Connection Error Handling

Getting the Status of Database Write Requests

Understanding Database Update Operators

Adding Documents to a Collection in the MongoDB Shell

Inserting Documents into a Collection Using the MongoDB Shell

Updating Documents in a Collection from the MongoDB Shell

Updating Documents in a Collection Using the MongoDB Shell

Saving Documents in a Collection Using the MongoDB Shell

Saving Documents in a Collection Using the MongoDB Shell

Upserting Documents in Collections Using the MongoDB Shell

Upserting Documents in a Collection Using the MongoDB Shell

Deleting Documents from a Collection Using the MongoDB Shell

Deleting Documents from a Collection Using the MongoDB Shell

Summary

Q&A

Quiz

Exercises

Hour 9: Utilizing the Power of Grouping, Aggregation, and Map Reduce

Grouping Results of Find Operations in the MongoDB Shell

Grouping Objects by Key Values Using the MongoDB Shell

Using Aggregation to Manipulate the Data During Requests from the MongoDB Shell

Generating Aggregated Data from a Collection Using the MongoDB Shell

Applying Map Reduce to Generate New Data Results Using the MongoDB Shell

Using Map Reduce to Manipulate Results of Request from the MongoDB Shell

Summary

Q&A

Quiz

Exercises

Hour 10: Implementing MongoDB in Java Applications

Understanding MongoDB Driver Objects in Java

Implementing the Java MongoDB Driver and Connecting to MongoDB Using Java

Finding Documents Using Java

Retrieving Documents from MongoDB Using Java

Retrieving Specific Documents from MongoDB Using Java

Counting Documents in Java

Counting the Number of Documents Represented by a Cursor in Java

Sorting Results Sets in Java

Sorting Documents Represented by a Cursor in Java

Summary

Q&A

Quiz

Exercises

Hour 11: Accessing Data from MongoDB in Java Applications

Limiting Result Sets Using Java

Limiting the Number of Documents Represented by a Cursor in Java

Limiting Which Document Fields are Returned from Find Requests in Java

Paging Through Documents in a Collection using Java

Finding a Distinct Field Value in Java

Retrieving Distinct Values for a Specific Field Using Java

Grouping Results of Find Operations in Java Applications

Grouping Documents by Field Values in Java

Using Aggregation to Manipulate the Data During Requests from Java Applications

Generating Aggregated Data from MongoDB in Java Applications

Summary

Q&A

Quiz

Exercises

Hour 12: Working with MongoDB Data in Java Applications

Adding Documents from Java

Inserting Documents into a Collection Using Java

Removing Documents from Java

Deleting Documents from a Collection Using Java

Saving Documents from Java

Saving Documents in a Collection Using Java

Updating Documents from Java

Updating Documents in a Collection Using Java

Upserting Documents from Java

Upserting Documents in a Collection Using Java

Summary

Q&A

Quiz

Exercises

Hour 13: Implementing MongoDB in PHP Applications

Understanding MongoDB Driver Objects in PHP

Implementing the PHP MongoDB Driver and Connecting to MongoDB Using PHP

Finding Documents Using PHP

Retrieving Documents from MongoDB Using PHP

Retrieving Specific Documents from MongoDB Using PHP

Counting Documents in PHP

Sorting Result Sets in PHP

Counting the Number of Documents Represented by a Cursor in PHP

Sorting Documents Represented by a Cursor in PHP

Summary

Q&A

Quiz

Exercises

Hour 14: Accessing Data from MongoDB in PHP Applications

Limiting Result Sets Using PHP

Limiting the Number of Documents Represented by a Cursor in PHP

Limiting Which Document Fields are Returned from Find Requests in PHP

Paging Through Documents in a Collection using PHP

Finding Distinct Field Values in PHP

Retrieving Distinct Values for a Specific Field Using PHP

Grouping Results of Find Operations in PHP Applications

Grouping Documents by Field Values in PHP

Using Aggregation to Manipulate the Data During Requests from PHP Applications

Generating Aggregated Data from MongoDB in PHP Applications

Summary

Q&A

Quiz

Exercises

Hour 15: Working with MongoDB Data in PHP Applications

Adding Documents from PHP

Inserting Documents into a Collection Using PHP

Removing Documents from PHP

Deleting Documents from a Collection Using PHP

Saving Documents from PHP

Saving Documents in a Collection Using PHP

Updating Documents from PHP

Updating Documents in a Collection Using PHP

Upserting Documents from PHP

Upserting Documents in a Collection Using PHP

Summary

Q&A

Quiz

Exercises

Hour 16: Implementing MongoDB in Python Applications

Understanding MongoDB Driver Objects in Python

Implementing the Python MongoDB Driver and Connecting to MongoDB Using Python

Finding Documents Using Python

Retrieving Documents from MongoDB Using Python

Retrieving Specific Documents from MongoDB Using Python

Counting Documents in Python

Counting the Number of Documents Represented by a Cursor in Python

Sorting Result Sets in Python

Sorting Documents Represented by a Cursor in Python

Summary

Q&A

Quiz

Exercises

Hour 17: Accessing Data from MongoDB in Python Applications

Limiting Result Sets Using Python

Limiting the Number of Documents Represented by a Cursor in Python

Limiting Which Document Fields are Returned from Find Requests in Python

Paging Through Documents in a Collection using Python

Finding Distinct Field Value in Python

Retrieving Distinct Values for a Specific Field Using Python

Grouping Results of Find Operations in Python Applications

Grouping Documents by Field Values in Python

Using Aggregation to Manipulate the Data During Requests from Python Applications

Generating Aggregated Data from MongoDB in Python Applications

Summary

Q&A

Quiz

Exercises

Hour 18: Working with MongoDB Data in Python Applications

Adding Documents from Python

Inserting Documents into a Collection Using Python

Removing Documents from Python

Deleting Documents from a Collection Using Python

Saving Documents from Python

Saving Documents in a Collection Using Python

Updating Documents from Python

Updating Documents in a Collection Using Python

Upserting Documents from Python

Upserting Documents in a Collection Using Python

Summary

Q&A

Quiz

Exercises

Hour 19: Implementing MongoDB in Node.js Applications

Understanding MongoDB Driver Objects in Node.js

Implementing the Node.js MongoDB Driver and Connecting to MongoDB Using Node.js

Finding Documents Using Node.js

Retrieving Documents from MongoDB Using Node.js

Retrieving Specific Documents from MongoDB Using Node.js

Counting Documents in Node.js

Counting the Number of Documents Represented by a Cursor in Node.js

Sorting Results Sets in Node.js

Sorting Documents Represented by a Cursor in Node.js

Summary

Q&A

Quiz

Exercises

Hour 20: Accessing Data from MongoDB in Node.js Applications

Limiting Result Sets Using Node.js

Limiting the Number of Documents Represented by a Cursor in Node.js

Limiting Which Document Fields are Returned from Find Requests in Node.js

Paging Through Documents in a Collection using Node.js

Finding Distinct Field Value in Node.js

Retrieving Distinct Values for a Specific Field Using Node.js

Grouping Results of Find Operations in Node.js Applications

Grouping Documents by Field Values in Node.js

Using Aggregation to Manipulate the Data During Requests from Node.js Applications

Generating Aggregated Data from MongoDB in Node.js Applications

Summary

Q&A

Quiz

Exercises

Hour 21: Working with MongoDB Data in Node.js Applications

Adding Documents from Node.js

Inserting Documents into a Collection Using Node.js

Removing Documents from Node.js

Deleting Documents from a Collection Using Node.js

Saving Documents from Node.js

Saving Documents in a Collection Using Node.js

Updating Documents from Node.js

Updating Documents in a Collection Using Node.js

Upserting Documents from Node.js

Upserting Documents in a Collection Using Node.js

Summary

Q&A

Quiz

Exercises

Hour 22: Database Administration Using the MongoDB Shell

Working with Databases and Collections

Creating a Copy of a MongoDB Database

Renaming a Collection in a MongoDB Database

Creating a Capped Collection in a MongoDB Database

Working with Indexes

Implementing Indexes on a Collection in a MongoDB Database

Understanding Performance and Diagnostic Tasks

Validating a MongoDB Database

Implementing profiling on a MongoDB Database

Analyzing Queries on a MongoDB Database

Analyzing MongoDB Database Usage

Repairing a MongoDB Database

Backing Up MongoDB

Summary

Q&A

Quiz

Exercises

Hour 23: Implementing Replication and Sharding in MongoDB

Applying Replication in MongoDB

Creating a MongoDB Replica Set

Implementing Sharding in MongoDB

Creating a Sharded MongoDB Cluster

Summary

Q&A

Quiz

Exercises

Hour 24: Implementing a MongoDB GridFS Store

Understanding the GridFS Store

Implementing a GridFS in the MongoDB Shell

Storing and Retrieving Files in the MongoDB GridFS Store from the Console

Implementing a MongoDB GridFS Using the Java MongoDB Driver

Accessing and Manipulating Files in the MongoDB GridFS Store from Java

Implementing a MongoDB GridFS Using the PHP MongoDB Driver

Accessing and Manipulating Files in the MongoDB GridFS Store from PHP

Implementing a MongoDB GridFS Using the Python MongoDB Driver

Accessing and Manipulating Files in the MongoDB GridFS Store from Python

Implementing a MongoDB GridFS Using the Node.js MongoDB Driver

Accessing and Manipulating Files in the MongoDB GridFS Store from Node.js

Summary

Q&A

Quiz

Exercises