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.
Testimonials (5)
By the pace was appropriate. The instructor could convey knowledge in an accessible way and didn't rush through the material. I learned a lot during the training thanks to the exercises and translating into specific examples/errors of what went wrong.
Milena Mlynarska-Zmuda - Osrodek Przetwarzania Informacji - Panstwowy Instytut Badawczy
Course - MongoDB for Analysts
Machine Translated
Skill in conveying knowledge and maintaining the focus of participants.
Anna Wisniewska - Osrodek Przetwarzania Informacji - Panstwowy Instytut Badawczy
Course - MongoDB for Analysts
Machine Translated
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
Samer Roshdi - epic ltd
Course - MongoDB for Analysts
There are many workshops, good contact.
Maciej Szczepaniak - Credit Agricole Bank Polska S.A.
Course - MongoDB dla analityków
Machine Translated