Get in Touch

Course Outline

Introduction to MongoDB

  • Overview of NoSQL databases
  • NoSQL versus RDBMS (relational databases)
  • Understanding documents and the JSON format
  • Setting up a MongoDB sandbox (local or cloud)
  • CRUD operations (Create, Read, Update, and Delete)
  • Using the MongoDB Shell as a fundamental client tool
  • Exploring MongoDB Compass and other client applications

Aggregation Functions

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

Business Intelligence Connector and Data Migration

  • Using MongoDB data in Excel
  • Installing and configuring the BI connector
  • Loading data from existing SQL databases
  • Utilising built-in MongoDB import/export tools

Performance Tuning

  • Analysing performance using the explain function
  • Profiler
  • Overview of indexes and special collections
  • Optimising replica-set nodes for reporting

Requirements

There are no specific prerequisites to attend this course; however, prior experience with any database system would be beneficial.

 14 Hours

Number of participants


Price per participant

Testimonials (2)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories