Author: Phil Factor
MongoDB find Method: Introduction & Examples
Posted on: 17/02/2020 (last updated: 04/08/2021) by Phil FactorAn introduction to the find() method along with query examples.
Getting Data Masking and Anonymization Right
Posted on: 12/11/2019 (last updated: 04/08/2021) by Phil FactorData Masking. Data Obfuscation. Learn what these terms mean and the best practices to follow when making sensitive data, anonymous.
SQL Server to MongoDB Data Transfer Using Extended JSON
Posted on: 07/03/2019 (last updated: 04/08/2021) by Phil FactorLearn how to transfer databases from SQL Server to MongoDB (and vice versa) using Extended JSON.
How to Create a MongoDB Collection Directly from SQL Server
Posted on: 07/03/2019 (last updated: 25/10/2021) by Phil FactorLearn how you can paste the output of a SQL Server query straight into a MongoDB collection with Studio 3T.
How to Create and Validate JSON Schema in MongoDB Collections
Posted on: 15/11/2018 (last updated: 04/08/2021) by Phil FactorLearn how you can create and validate JSON schema in MongoDB, using third-party JSON schema validation tools and Studio 3T’s Schema Explorer.
Extending MongoDB Aggregation with the Bucket and Facet Stages
Posted on: 03/09/2018 (last updated: 04/08/2021) by Phil FactorLearn how to query the MongoDB aggregation pipeline more efficiently with the $bucket and $facet stages.
Setting Up a MongoDB Service Under Windows via PowerShell
Posted on: 27/07/2018 (last updated: 04/08/2021) by Phil FactorLearn how to use PowerShell to set up a MongoDB service on Windows.
How to Create MongoDB Joins Using SQL
Posted on: 19/06/2018 (last updated: 09/03/2022) by Phil FactorLearn how to write SQL join queries to generate MongoDB joins in the form of aggregation queries.
Using Aggregation and Regex in MongoDB to Reduce Data in a Collection
Posted on: 19/06/2018 (last updated: 04/08/2021) by Phil FactorLearn how to use regex to transform an external data set to JSON or export it to CSV for later import, and run aggregation queries to reduce the data before creating a MongoDB collection.
A Practical Introduction to MongoDB Views
Posted on: 30/04/2018 (last updated: 04/08/2021) by Phil FactorWe introduce the idea of MongoDB views – what they are, why they’re useful, when to use them, and how they relate to data aggregations – and walk you through how to create a view in Studio 3T using a small practice database courtesy of the UK’s Met Office.
Tags
Browse by MongoDB topic
- Connecting to MongoDB
- Database Administration & Security
- Getting Started with MongoDB
- Getting Started with Studio 3T
- Import/Export
- Job Automation & Scheduling
- MongoDB Aggregation Framework
- MongoDB/Studio 3T Workshops
- Performance
- Query & CRUD Operations
- Reference
- Schema
- Studio 3T Licensing
- Support and other resources
- Working with MongoDB & SQL
- Working with MongoDB Atlas