MongoDB for Analysts Certificate for Joaquín Sari Kauzal Oueini
Certificate ID:
623035
Authentication Code:
e0c94
Certified Person Name:
Joaquín Sari Kauzal Oueini
Trainer Name:
Ajay Singhal
Duration Days:
2
Duration Hours:
14
Course Name:
MongoDB for Analysts
Course Date:
9 November 2020 09:30 to 10 November 2020 16:30
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