Learning MongoDB Schema, Indexes and Queries

Name: Learning MongoDB Schema, Indexes and Queries
Rating: 4.5 (25 reviews)

Understand how good design facilitates scale and achieve top performance by gaining insights into indexing strategies.

Highest Rated

Created byPackt Publishing

Last updated 9/2018

English

What you'll learn

A collection schema matters in a schema-less system; or, when to stop de-normalizing data relationships.
How a data schema impacts scale
Introduction to database indexing: concepts and terminology
How indexes increase operational overhead but improve query performance
MongoDB Indexes vs. index properties
Advanced index concepts and indexing best-practices
CRUD commands from the MongoDB client; how to combine simple JavaScript with BSON queries to populate sample tables, and how to use queries effectively to maintain your database
Administrative queries; how to delete collections or even entire databases.
How to apply indexes, or query to see what indexes already exist.
Perform a quick backup and recovery of your collections

Course content

4 sections • 36 lectures • 6h 26m total length

The Course Overview6:36
This video provides an overview of the entire course.
Schema – Traditional Definition and How It’s Applied To MongoDB10:13
In this video, we will learn the concepts of schema in mongoDB.
• Understand schema
• Learn the use of schema in mongoDB and RDBMS
Denormalization Defined as a Corollary to Data Normalization12:39
In this video, we will learn about data normalization and its application in mongoDB.
• Understand data normalization
• Learn the applications of data normalization in mongoDB
• Understand the mongoDB record example
MongoDB Data Types15:55
In this video, we will learn about data types in mongoDB.
• Learn the importance of data types in mongoDB
• Learn different types of data types in mongoDB
• Understand ObjectID

Indexes – What Indexes Do, How They’re Stored, Used, and Their General Impact5:13
In this video, we will be introduced to database indexing.
• Understand the work of indexing in a database
Index Properties – How Index Properties Can Enhance or Fine-Tune Existing Indexe7:12
In this video, we will learn about index types and an index’s properties.
• Understand the working of an index in mongoDB
• Get a thorough understanding of different index types
Index Properties – How Index Properties Can Enhance or Fine-Tune Existing Indexe11:25
We will continue with the previous video where, we learned about Index types and its properties.
• Learn about index properties
Index Management8:32
In this video, we will learn in detail about indexes along with index management.
• Create a test database and implement index commands
• Learn to create, drop, and maintain indexes in mongoDB
Index Management (Continued)7:58
We will continue learning in detail about indexes along with index management.
• Learn to create, drop, and maintain indexes in mongoDB
Index Management – Demo21:14
In this video, we will continue working with indexes on a test database.
• Get a hands-on demo on index management

Introduction to MongoDB CRUD Queries6:19
In this video, we will learn basic CRUD and aggregation commands in mongo shell.
• Introduction to CRUD operations and mongo shell
Create – How to Create New Databases and New Collections10:24
In this video, we will learn the Create command in mongo shell.
• Learn to create database, indexes, and records
• Understand the insert(), insertOne(), and insertMany() commands
Create – How to Create New Databases and New Collections (Continued)6:43
In this video, we will continue learning the Create command in mongo shell.
• Understand the insert(), insertOne(), and insertMany() commands
Demo for Create Command4:36
We will continue learning the Create command in mongo shell.
• Get a hands-on demo on creating records
Read – How to Fetch Data from a Collection14:00
In this video, we will learn about getting data from the database.
• Learn to retrieve data from the database in mongoDB
Read – How to Fetch Data from a Collection (Continued)15:48
In this video, we will continue learning about getting data from the database.
• Learn to retrieve data from the database in mongoDB
Demo for Read Command15:56
We will continue the topic of getting data from the database.
• Get a hands-on demo on using the find command
Update – How to Update Existing Records Within a Single Query8:44
In this video, we will learn about the update command.
• Learn about update in mongoDB
• Understand the update(), updateOne(), updateMany(), and replaceOne() commands
Update – How to Update Existing Records Within a Single Query (Continued)12:36
In this video, we will continue learning about the update command.
• Understand the update(), updateOne(), updateMany(), and replaceOne() commands
Demo for Update Command12:15
In this video, we will continue learning about the update command.
• Get a hands-on demo of using the update command
Demo for Update Command (Continued)6:44
In this video, we will continue learning about the update command.
• Get a hands-on demo of using the update command
Delete – How to Permanently Remove Data from Your Collection13:30
In this video, we will learn about the delete command.
• Learn in detail about the delete command in mongoDB
• Understand the remove(), deleteOne(), and deleteMany() commandsin detail
• Learn about alternative methods of deletion in mongoDB
Demo for Delete Command14:08
We will continue learning about the delete command.
• Get a hands-on demo on using delete command
Aggregation –How to Write Aggregation Queries15:30
In this video, we will learn about data aggregation.
• Learn the different ways provided by mongoDB for data aggregation
Demo for Aggregation16:17
We will continue learning about data aggregation.
• Get a hands-on demo on data aggregation
Demo for Aggregation (Continued)9:41
In this video, we will continue learning about data aggregation.
• Get a hands-on demo on data aggregation

Maintaining Databases and Collections12:46
In this video, we will learn about managing the mongo database and mongo collections.
• Understand the working of dropDatabase() in mongo shell
• Understand devOps tasks
Moving Your Database to Another Location14:50
In this video, we will learn to relocate databases.
• Learn to relocate an existing database to a new location
• Learn to create a tarball
• Learn to copy files locally and remotely
Demo One – Moving a Database to Another Machine12:53
In this video, we will continue with relocating databases.
Get a hands-on demo to move databases in mongoDB
Demo Two – Moving a Database to Another Machine8:50
We will continue learning how to relocate databases.
Get a hands-on demo to move databases on a different system
Moving a Collection to Another Database9:44
In this video, we will learn about moving a single collection within a database from one mongo database to another.
Learn the importance of moving a collection from one mongo database to another
Go through the detailed steps for moving a collection from one mongo database to another
Demo One – Moving a Collection to Another Database5:33
In this video, we will continue with moving a single collection.
Get a hands-on demo on moving a collection from one mongo database to another
Quick and Easy Backup and Recovery10:43
In this video, we will learn about backup and recovery.
Learn the importance of backup and recovery
Go through the steps for backup and recovery
Demo – Backup and Recovery8:53
We will continue learning about backup and recovery.
Get a hands-on demo on backup and recovery
Dropping Collections and Databases7:16
In this video, we will learn about dropping collections and databases.
Learn how to drop the right collections and databases
Demo – Dropping Collections and Databases5:19
In this video, we will continue with dropping collections and databases.
Get a hands-on demo of dropping collections and databases

Requirements

Prior knowledge of relational database systems will be very helpful as we often compare and contrast MongoDB features with traditional databases.

Description

MongoDB makes it possible to store and process large sets of data in ways that increase business value. The flexibility of unstructured, schema-less, storage, combined with robust querying and post-processing functionality, make MongoDB a compelling solution for enterprise big data needs.

We need to discuss database schemas. Yes, MongoDB is touted as schema-less but here's where we show that proper design is what allows our collections to scale. Indexing is something everyone talks about, but few understand. We'll explain MongoDB indexing, and index properties because a successful indexing strategy is a key to performance and scaling. Finally, we'll talk about CRUD commands from the MongoDB client and how to write effective queries.

Taking this course will help you understand supported standards and data types in MongoDB, and best practices to design collections to scale and index them. Also, you will learn some basic CRUD commands.

About the Author

Micheal Shallop started programming in 1981 on a Tandy TRS-80 Model 1 and hasn't stopped since. He graduated in 1991 from Oklahoma State University with an Honors degree in Computer Science. In his career, he's coded in many programming languages and has used a variety of databases, relational and otherwise. He was the technical author of a patent awarded in 2011 for his work on real-time data collection, aggregation and forecasting in a conventional (automotive) business.

He is currently working for designing and writing a back-end, event-driven, object-oriented, data-agnostic framework utilizing AMQP as the data transport vector and PHP 7.1 as the primary language. He has been programming in PHP for MongoDB since 2010 and has been the architect of several systems, mostly back-end frameworks.

Micheal is interested in anything with a programming language behind it. Most recently, he has been experimenting with Arduino, programming on the Raspberry Pi, and writing a social media site in Python. He is also technically skilled in RabbitMQ, general database tech, Python, C/C++, Linux

Who this course is for:

This course's target audience should have experience with dev-Ops, be comfortable with the Linux command line, and should be experienced in with configuring and deploying cloud-based instances.

Learning MongoDB Schema, Indexes and Queries

What you'll learn

Explore related topics

Course content

Imposing Schema on a Schema-Less System4 lectures • 45min

Indexes – The Keys to Speed6 lectures • 1hr 2min

CRUD16 lectures • 3hr 3min

Administration of Your Database10 lectures • 1hr 37min

Requirements

Description

Who this course is for: