by Maximilian Schwarzmüller | Released October 2018 | ISBN: 9781789954012

Master MongoDB Development for Web & Mobile Apps. CRUD Operations, Indexes, Aggregation Framework - All about MongoDB!About This VideoPerform simple CRUD operations on the database using the MongoDB command shellLearn index concepts and indexing best-practicesIn DetailMongoDB is one of the most important databases you can work with these days. It's extremely popular and MongoDB developers are in high demand. MongoDB makes working with data simple - it's built on a philosophy that prioritizes performance and efficiency.In this course, you'll learn all about MongoDB from scratch. No prior MongoDB or database experience is required!In detail, you'll learn:... how to install and use MongoDB locally and in the cloud... how to perform CRUD (Create, Read, Update, Delete) operations on MongoDB databases... how to filter for data efficiently... how to work with both the Mongo Shell and drivers (e.g. Node.js driver)... how to increase performance by using indexes (and how to use the right indexes!)... how to use the amazing "Aggregation Framework" that's built into MongoDB... what replica sets and sharding are... how to use MongoDB Atlas - the cloud solution offered by MongoDB... how to use the serverless platform (Stitch) offered by MongoDB... and much more!This course is a hands-on course - you'll learn by writing code/ commands. We'll work on a wide variety of example data and use-cases and by the end of the course, you'll have all the knowledge you need to work with MongoDB in your next project!The code bundle for this video course is available at https://github.com/PacktPublishing/MongoDB---The-Complete-Developer-s-Guide- Show and hide more

1. Chapter 1 : Introduction
   • Introduction 00:01:40
   • What is MongoDB? 00:05:36
   • The Key MongoDB Characteristics (and how they differ from SQL Databases) 00:02:56
   • Understanding the MongoDB Ecosystem 00:04:19
   • Installing MongoDB 00:10:14
   • Time To Get Started! 00:05:37
   • Shell vs Drivers 00:03:29
   • MongoDB + Clients: The Big Picture 00:02:58
   • Course Outline 00:04:39
   • How To Get The Most Out Of The Course 00:01:45
2. Chapter 2 : Understanding the Basics & CRUD Operations
   • Module Introduction 00:01:31
   • Understanding Databases, Collections & Documents 00:03:47
   • The Shell & MongoDB Drivers for Different Languages 00:02:40
   • Creating Databases & Collections 00:03:16
   • Understanding JSON Data 00:04:05
   • Comparing JSON & BSON 00:05:23
   • Create, Read, Update, Delete (CRUD) & MongoDB 00:05:38
   • Finding, Inserting, Deleting & Updating Elements 00:07:47
   • Understanding "insertMany()" 00:01:48
   • Diving Deeper Into Finding Data 00:03:55
   • "update" vs "updateMany()" 00:04:41
   • Understanding "find()" & the Cursor Object 00:07:30
   • Understanding Projection 00:03:38
   • Embedded Documents & Arrays - The Theory 00:01:56
   • Working with Embedded Documents 00:02:28
   • Working with Arrays 00:01:43
   • Accessing Structured Data 00:04:39
   • Wrap Up 00:02:47
3. Chapter 3 : Schemas & Relations: How to Structure Documents
   • Module Introduction 00:02:12
   • Why Do We Use Schemas? 00:03:58
   • Structuring Documents 00:07:43
   • Data Types - An Overview 00:06:23
   • Data Types in Action 00:12:16
   • How to Derive your Data Structure - Requirements 00:05:08
   • Understanding Relations 00:02:58
   • One To One Relations - Embedded 00:06:20
   • One To One - Using References 00:04:54
   • One To Many - Embedded 00:05:08
   • One To Many - Using References 00:04:05
   • Many To Many - Embedded 00:07:17
   • Many To Many - Using References 00:05:25
   • Summarizing Relations 00:02:18
   • Using "lookUp()" for Merging Reference Relations 00:04:36
   • Planning the Example Exercise 00:06:57
   • Implementing the Example Exercise 00:04:16
   • Understanding Schema Validation 00:02:58
   • Adding Collection Document Validation 00:09:07
   • Changing the Validation Action 00:03:43
   • Wrap Up 00:04:08
4. Chapter 4 : Exploring The Shell & The Server
   • Module Introduction 00:01:01
   • Finding Available Options 00:02:16
   • Setting "dbpath" & "logpath" 00:04:42
   • Exploring the MongoDB Options 00:02:01
   • MongoDB as a Background Service 00:03:09
   • Using a Config File 00:03:03
   • Shell Options & Help 00:04:13
5. Chapter 5 : Using the MongoDB Compass to Explore Data Visually
   • Module Introduction 00:00:50
   • Exploring the MongoDB Compass 00:05:50
6. Chapter 6 : Diving Into Create Operations
   • Module Introduction 00:01:13
   • Creating Documents - An Overview 00:01:48
   • Understanding "insert()" Methods 00:06:11
   • Working with Ordered Inserts 00:07:47
   • Understanding the "writeConcern" 00:05:44
   • The "writeConcern" in Practice 00:04:10
   • What is Atomicity? 00:02:40
   • Importing Data 00:03:38
   • Wrap Up 00:02:39
7. Chapter 7 : Read Operations - A r Look
   • Module Introduction 00:01:40
   • Methods, Filters & Operators 00:02:55
   • Operators - An Overview 00:03:03
   • Query Selectors & Projection Operators 00:01:16
   • Understanding "findOne()" & "find()" 00:04:33
   • Working with Comparison Operators 00:05:20
   • Querying Embedded Fields & Arrays 00:04:52
   • Understanding "$in" and "$nin" 00:02:37
   • "$or" and "$nor" 00:05:32
   • Understanding the "$and" Operator 00:05:04
   • Using "$not" 00:01:35
   • Diving Into Element Operators 00:05:30
   • Working with "$type" 00:02:52
   • Understanding Evaluation Operators - "$regex" 00:03:24
   • Understanding Evaluation Operators - "$expr" 00:09:37
   • Diving Deeper Into Querying Arrays 00:04:10
   • Using Array Query Selectors - "$size" 00:02:10
   • Using Array Query Selectors - "$all" 00:02:13
   • Using Array Query Selectors - "$elemMatch" 00:04:53
   • Understanding Cursors 00:02:48
   • Applying Cursors 00:06:02
   • Sorting Cursor Results 00:03:10
   • Skipping & Limiting Cursor Results 00:03:32
   • Using Projection to Share our Results 00:04:02
   • Using Projection in Arrays 00:05:12
   • Understanding "$slice" 00:03:06
8. Chapter 8 : Update Operations
   • Module Introduction 00:01:01
   • Updating Fields with "updateOne()", "updateMany()" and "$set" 00:07:53
   • Updating Multiple Fields with "$set" 00:01:41
   • Incrementing & Decrementing Values 00:03:34
   • Using "$min", "$max" and "$mul" 00:03:16
   • Getting Rid of Fields 00:02:05
   • Renaming Fields 00:01:21
   • Understanding "upsert()" 00:04:01
   • Updating Matched Array Elements 00:06:57
   • Updating All Array Elements 00:06:27
   • Finding & Updating Specific Fields 00:05:35
   • Adding Elements to Arrays 00:04:47
   • Removing Elements from Arrays 00:02:34
   • Understanding "$addToSet" 00:01:19
   • Wrap Up 00:01:39
9. Chapter 9 : Understanding Delete Operations
   • Module Introduction 00:00:32
   • Understanding "deleteOne()" & "deleteMany()" 00:04:09
   • Deleting All Entries in a Collection 00:02:01
10. Chapter 10 : Working with Indexes
    • Module Introduction 00:01:20
    • What Are Indexes & Why Do We Use Them? 00:04:19
    • Adding a Single Field Index 00:08:07
    • Understanding Index Restrictions 00:02:51
    • Creating Compound Indexes 00:07:14
    • Using Indexes for Sorting 00:02:26
    • Understanding the Default Index 00:00:59
    • Configuring Indexes 00:02:29
    • Understanding Partial Filters 00:06:07
    • Applying the Partial Index 00:03:37
    • Understanding the Time-To-Live (TTL) Index 00:03:56
    • Query Diagnosis & Query Planning 00:02:10
    • Understanding Covered Queries 00:03:34
    • How MongoDB Rejects a Plan 00:07:38
    • Using Multi-Key Indexes 00:08:16
    • Understanding Text Indexes 00:06:10
    • Text Indexes & Sorting 00:02:22
    • Creating Combined Text Indexes 00:02:54
    • Using Text Indexes to Exclude Words 00:00:54
    • Setting the Default Language & Using Weights 00:06:32
    • Building Indexes 00:07:40
    • Wrap Up 00:02:25
11. Chapter 11 : Working with Geospatial Data
    • Module Introduction 00:00:53
    • Adding GeoJSON Data 00:04:52
    • Running Geo Queries 00:03:23
    • Adding a Geospatial Index to Track the Distance 00:02:52
    • Adding Additional Locations 00:03:34
    • Finding Places Inside a Certain Area 00:06:22
    • Finding Out If a User Is Inside a Specific Area 00:05:27
    • Finding Places Within a Certain Radius 00:05:38
    • Wrap Up 00:01:40
12. Chapter 12 : Understanding the Aggregation Framework
    • Module Introduction 00:01:34
    • What is the Aggregation Framework? 00:02:00
    • Getting Started with the Aggregation Pipeline 00:01:21
    • Using the Aggregation Framework 00:03:13
    • Understanding the Group Stage 00:05:56
    • Diving Deeper Into the Group Stage 00:03:12
    • Working with $project 00:09:59
    • Turning the Location Into a geoJSON Object 00:07:59
    • Transforming the Birthdate 00:03:48
    • Using Shortcuts for Transformations 00:01:26
    • Understanding the $isoWeekYear Operator 00:02:41
    • $group vs $project 00:00:55
    • Pushing Elements Into Newly Created Arrays 00:04:04
    • Understanding the $unwind Stage 00:02:50
    • Eliminating Duplicate Values 00:00:50
    • Using Projection with Arrays 00:03:04
    • Getting the Length of an Array 00:01:12
    • Using the $filter Operator 00:04:44
    • Applying Multiple Operations to our Array 00:07:31
    • Understanding $bucket 00:06:17
    • Diving Into Additional Stages 00:07:29
    • Writing Pipeline Results Into a New Collection 00:01:47
    • Working with the $geoNear Stage 00:05:16
    • Wrap Up 00:02:42
13. Chapter 13 : Working with Numeric Data
    • Module Introduction 00:00:54
    • Number Types - An Overview 00:06:29
    • Understanding Programming Language Defaults 00:03:33
    • Working with int32 00:05:18
    • Working with int64 00:06:33
    • Doing Maths with Floats int32s & int64s 00:06:58
    • What's Wrong with Normal Doubles? 00:04:21
    • Working with Decimal 128bit 00:04:14
    • Wrap Up 00:01:41
14. Chapter 14 : MongoDB & Security
    • Module Introduction 00:04:23
    • Understanding Role Based Access Control 00:06:48
    • Roles - Examples 00:02:14
    • Creating a User 00:05:51
    • Built-In Roles - An Overview 00:05:40
    • Assigning Roles to Users & Databases 00:04:49
    • Updating & Extending Roles to Other Databases 00:05:07
    • Adding SSL Transport Encryption 00:10:21
    • Encryption at REST 00:01:25
    • Wrap Up 00:03:21
15. Chapter 15 : Performance, Fault Tolerancy & Deployment
    • Module Introduction 00:01:53
    • What Influences Performance? 00:03:01
    • Understanding Capped Collections 00:05:05
    • What are Replica Sets? 00:04:36
    • Understanding Sharding 00:06:14
    • Deploying a MongoDB Server 00:02:25
    • Using MongoDB Atlas 00:09:18
    • Backups & Setting Alerts in MongoDB Atlas 00:01:27
    • Connecting to our Cluster 00:03:36
    • Wrap Up 00:01:58
16. Chapter 16 : Transactions
    • Module Introduction 00:01:05
    • What are Transactions? 00:02:04
    • A Typical Usecase 00:02:18
    • How Does a Transaction Work? 00:07:42
17. Chapter 17 : From Shell to Driver
    • Module Introduction 00:02:14
    • Splitting Work Between the Driver & the Shell 00:02:06
    • Preparing our Project 00:04:50
    • Installing Visual Studio Code 00:01:47
    • Installing the Node.js Driver 00:04:57
    • Connecting Node.js & the MongoDB Cluster 00:06:32
    • Storing Products in the Database 00:04:54
    • Storing the Price as 128bit Decimal 00:06:10
    • Fetching Data From the Database 00:06:23
    • Creating a More Realistic Setup 00:11:48
    • Getting a Single Product 00:03:20
    • Editing & Deleting Products 00:07:29
    • Implementing Pagination 00:04:59
    • Adding an Index 00:01:28
    • Signing Users Up 00:07:03
    • Adding an Index to Make the Email Unique 00:01:13
    • Adding User Sign In 00:05:19
    • Wrap Up 00:01:11
18. Chapter 18 : Introducing Stitch
    • Module Introduction 00:01:42
    • What is Stitch? 00:07:23
    • Preparations 00:02:05
    • Start Using Stitch 00:04:34
    • Adding Stitch to our App & Initializing It 00:08:11
    • Adding Authentication 00:02:48
    • Sending Data Access Rules 00:03:58
    • Fetching & Converting Data 00:01:49
    • Deleting Products 00:03:03
    • Finding a Single Product 00:04:10
    • Adding Products 00:03:29
    • Updating Products 00:03:47
    • Switching to User Email & Password Authentication 00:01:55
    • Adding User Sign Up & Confirmation 00:06:32
    • Adding User Login 00:03:43
    • Rules & Real Users 00:01:49
    • Functions & Triggers 00:05:02
    • Wrap Up 00:00:57
19. Chapter 19 : Roundup
    • Course Roundup 00:03:06
Show and hide more