We demonstrate how to set up a simple REST service that you can use to communicate between MongoDB and SQL Server.

Learn how you can create and validate JSON schema in MongoDB, using third-party JSON schema validation tools and Studio 3T’s Schema Explorer.

Learn how to query the MongoDB aggregation pipeline more efficiently with the $bucket and $facet stages.

Learn how to use PowerShell to set up a MongoDB service on Windows.

Learn how to write SQL join queries to generate MongoDB joins in the form of aggregation queries.

Learn how to use the MongoDB find method and indexes to spot slow, unoptimized queries.

Learn 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.

Learn how to build aggregation queries that reduce the data in your collections to exactly just what you need.

Learn about the profiler and the explain method: two MongoDB features you can use to investigate and optimize query performance.

Learn how to use indexes to speed up both simple and complex queries, which in turn will help you build and develop an effective indexing strategy.