icon icon

MongoDB – database operation, aggregation and data analysis

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

Confident MongoDB decisions - You will understand how MongoDB differs from relational databases and when it makes sense to use it, so you can choose the right data platform for analysis and reporting work.

icon

Effective document modeling - You will learn how to read and design JSON documents and MongoDB collections, making it easier to structure data for analytics without forcing a relational database mindset.

icon

Your own working setup - You will configure both local and cloud MongoDB environments, so you can run tests quickly, work with your own datasets, and recreate analytical scenarios with less setup effort.

icon

Reliable data operations - You will master CRUD operations and understand transaction basics, allowing you to load, update, delete, and retrieve data safely for reporting tasks and analytical workflows.

icon

Comfort with MongoDB tools - You will work with MongoDB Shell and MongoDB Compass, so you can run queries faster, inspect collections more easily, and validate results without relying on a single interface.

icon

Aggregation for analysis - You will build aggregation queries, filter and sort data, and use the Aggregation Pipeline to create more advanced summaries, transformations, and analysis-ready result sets.

icon

MongoDB in BI workflows - You will explore data views, Map-Reduce, and the BI Connector, helping you connect MongoDB with Excel and reporting tools and use document data more effectively in business analysis.

icon

Faster and cleaner queries - You will learn how to use Explain, Profiler, and indexes to diagnose issues, so you can spot bottlenecks faster and improve the performance of queries and replication processes.

Training programme

1. Introduction to MongoDB and NoSQL

  • introduction to NoSQL,
  • MongoDB as a document database.

2. Comparison of MongoDB with relational databases (RDBMS)

  • differences between NoSQL and RDBMS,
  • when to use NoSQL.

3. Data structure in MongoDB and working with JSON documents

  • JSON documents,
  • data modeling in MongoDB.

4. Installation and configuration of the MongoDB environment

  • creating a local environment,
  • creating a cloud environment.

5. Basic CRUD operations in MongoDB

  • CRUD operations (Create, Read, Update, Delete),
  • transactions in MongoDB.

6. Working with MongoDB Shell and MongoDB Compass

  • MongoDB Shell,
  • MongoDB Compass.

7. Basic data aggregation functions

  • simple aggregation functions,
  • filtering and sorting queries.

8. Advanced data aggregation – Aggregation Pipeline

  • introduction to Aggregation Pipeline,
  • transformations and data processing.

9. Creating data views and using Map-Reduce

  • data views,
  • Map-Reduce.

10. Data analysis from MongoDB using the BI Connector

  • BI Connector and its capabilities,
  • analysis in Excel,
  • importing data from relational databases.

11. Performance optimization in MongoDB

  • performance analysis using Explain,
  • indexes and special collections.

12. Monitoring and optimization of MongoDB operation

  • Profiler,
  • replication optimization.

What are the prerequisites for participating in the training?

icon

Basic data handling - You should be comfortable working with tables, records, and fields, and understand how to filter and organize data, so moving into documents and collections feels natural.

icon

Basic SQL knowledge - You should know core SQL queries, especially SELECT, WHERE, and ORDER BY, because that will help you understand the differences between relational databases and MongoDB.

icon

Computer and tool usage - You should be able to use your operating system confidently, install applications, and work with simple desktop tools, so setting up the training environment is straightforward.

icon

Analytical mindset - You should know how to turn business questions into data questions and interpret simple results, because the course focuses on practical MongoDB use in analytical work.