Course Outline

MongoDB Introduction

  • Introduction to NoSQL databases for government
  • Comparison of NoSQL vs. RDBMS (relational databases)
  • Understanding documents and the JSON format
  • Setting up a MongoDB sandbox environment (local or cloud)
  • Performing CRUD operations (Create, Read, Update, Delete)
  • Utilizing the MongoDB Shell as a basic client tool
  • Exploring MongoDB Compass and other client applications

Aggregation Functions

  • Single-purpose aggregation functions
  • Constructing aggregation pipelines
  • Creating views for enhanced data management
  • Overview of map-reduce functionality

Business Intelligence Connector and Data Migration

  • Integrating MongoDB data with Excel for government use
  • Installation and configuration of the BI connector
  • Migrating data from existing SQL databases to MongoDB
  • Utilizing built-in Mongo import/export tools

Performance Tuning

  • Analyzing performance using the explain function
  • Using the profiler for detailed performance insights
  • Overview of indexes and special collections
  • Optimizing replica-set nodes for reporting purposes

Requirements

There are no specific prerequisites required to attend this course; however, prior experience with any database system is beneficial for government participants.

 14 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories