Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
MongoDB Introduction
- An introduction to NoSQL databases and their relevance for government operations.
- A comparison of NoSQL databases with relational database management systems (RDBMS).
- Understanding documents and the JSON format in the context of data storage for government applications.
- Setting up a MongoDB sandbox environment, either locally or in the cloud, to support government projects.
- Performing CRUD operations (Create, Read, Update, Delete) within the MongoDB framework for efficient data management.
- Utilizing the MongoDB Shell as a fundamental client tool for government database tasks.
- Exploring MongoDB Compass and other client tools to enhance data manipulation capabilities for government use.
Aggregation Functions
- An overview of single-purpose aggregation functions tailored for specific data analysis needs in government settings.
- An introduction to aggregation pipelines for complex data processing tasks within government databases.
- Creating views to streamline data presentation and reporting for government stakeholders.
- An overview of map-reduce techniques for advanced data aggregation in government applications.
Business Intelligence Connector and Data Migration
- Integrating MongoDB data into Excel for enhanced data analysis and reporting for government purposes.
- Installation and configuration of the BI connector to facilitate seamless data integration for government operations.
- Migrating data from existing SQL databases to MongoDB to support modernization efforts in government IT systems.
- Utilizing built-in MongoDB import/export tools to manage data transitions efficiently for government projects.
Performance Tuning
- Analyzing performance using the explain function to optimize query execution for government databases.
- Using the profiler to monitor and enhance database performance in government applications.
- An overview of indexes and special collections to improve data retrieval speed for government operations.
- Optimizing replica-set nodes to enhance reporting capabilities and ensure robust data availability for government use.
Requirements
There are no specific prerequisites required to enroll in this course; however, prior experience with any type of database is beneficial. This course is designed to enhance skills and knowledge for government professionals who may already have some familiarity with database systems.
14 Hours
Testimonials (2)
The training platform and functionalities as well as the Kamil way of knowledge transfer
panayiotis kakouris - epic ltd
Course - MongoDB for Analysts
The lab environment