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 Courses

Related Categories