課程大綱： MongoDB for Analysts培訓
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
加入高級會員獲得助教答疑
