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

Requirements

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

 14 Hours

Testimonials (2)

Related Categories