O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning MongoDB Schema, Indexes and Queries

Video Description

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

About This Video

  • A practical demonstration of the different storage types available to MongoDB and when to use them.
  • Determine good design schemas for your collections; when to stop denormalization when designing collections.
  • Indexing, next to architecture, is key in scaling your MongoDB database. Learn how, when and why to use indexing and also learn all about CRUD queries (Create, Read, Update, Delete) using the MongoDB client to put data in and get data out.

In Detail

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.

Table of Contents

  1. Chapter 1 : Imposing Schema on a Schema-Less System
    1. The Course Overview 00:06:36
    2. Schema – Traditional Definition and How It’s Applied To MongoDB 00:10:13
    3. Denormalization Defined as a Corollary to Data Normalization 00:12:40
    4. MongoDB Data Types 00:15:55
  2. Chapter 2 : Indexes – The Keys to Speed
    1. Indexes – What Indexes Do, How They’re Stored, Used, and Their General Impact 00:05:14
    2. Index Properties – How Index Properties Can Enhance or Fine-Tune Existing Indexes 00:07:13
    3. Index Properties – How Index Properties Can Enhance or Fine-Tune Existing Indexes (Continued) 00:11:25
    4. Index Management 00:08:32
    5. Index Management (Continued) 00:07:58
    6. Index Management – Demo 00:21:14
  3. Chapter 3 : CRUD
    1. Introduction to MongoDB CRUD Queries 00:06:19
    2. Create – How to Create New Databases and New Collections 00:10:24
    3. Create – How to Create New Databases and New Collections (Continued) 00:06:43
    4. Demo for Create Command 00:04:37
    5. Read – How to Fetch Data from a Collection 00:14:01
    6. Read – How to Fetch Data from a Collection (Continued) 00:15:48
    7. Demo for Read Command 00:15:56
    8. Update – How to Update Existing Records Within a Single Query 00:08:44
    9. Update – How to Update Existing Records Within a Single Query (Continued) 00:12:37
    10. Demo for Update Command 00:12:15
    11. Demo for Update Command (Continued) 00:06:44
    12. Delete – How to Permanently Remove Data from Your Collection 00:13:30
    13. Demo for Delete Command 00:14:09
    14. Aggregation –How to Write Aggregation Queries 00:15:31
    15. Demo for Aggregation 00:16:18
    16. Demo for Aggregation (Continued) 00:09:42
  4. Chapter 4 : Administration of Your Database
    1. Maintaining Databases and Collections 00:12:46
    2. Moving Your Database to Another Location 00:14:51
    3. Demo One – Moving a Database to Another Machine 00:12:54
    4. Demo Two – Moving a Database to Another Machine 00:08:51
    5. Moving a Collection to Another Database 00:09:45
    6. Demo One – Moving a Collection to Another Database 00:05:33
    7. Quick and Easy Backup and Recovery 00:10:43
    8. Demo – Backup and Recovery 00:08:54
    9. Dropping Collections and Databases 00:07:16
    10. Demo – Dropping Collections and Databases 00:05:20