MongoDB for Analysts Training Course

Course Code

mongoana

Duration

14 hours (usually 2 days including breaks)

Requirements

There are no specific requirements needed to attend this course, but experience with any database would be useful.

Overview

After the training, you will be able to write extract and modify the data in MongoDB database. You will also learn about powerful Aggregation Pipeline that is a flexible and fast tool for data analytics, and if it's not enough for you, how to connect your current BI tools like Tableau or Excel to data stored in Mongo.

Course Outline

MongoDB Introduction

  • Introduction into NoSQL databases
  • NoSQL vs. RDBMS (relational databases)
  • What are documents and JSON format
  • Creating MongoDB sandbox (local or cloud)
  • CRUD operations (Create, Read, Update and Delete)
  • MongoDB Shell as a basic client tool
  • MongoDB Compass and other clients

Aggregation functions

  • Single purpose aggregation functions
  • Aggregation pipelines
  • Creating views
  • Overview of map-reduce

Business Intelligence connector and data migration

  • How to use MongoDB data in Excel
  • BI connector installation and configuration 
  • Loading data from existing SQL databases
  • Built-in Mongo import/export tools

Performance tuning

  • Analysing performance using explain function
  • Profiler
  • Indexes and special collections overview
  • Optimising replica-set nodes for reporting

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the US!

As a Business Development Manager you will:

  • expand business in the US
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions