MongoDB Workshop for BI and Data Analysts

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

MongoDB Workshop for BI and Data Analysts

BD-354

MongoDB is a leading document database that changes the world developers known so far: no schema constraints, instant object persistency, rapid high availability, amazing performance and scale out support for the cloud generation.

This course provides a BI and data analysts hands-on practice with MongoDB data structure and query language as well as with advanced analysis skills using the aggregation framework.

Note: This course can be adjusted to additional programming languages (except for Java) and other target audiences including DBA, DevOps and Software engineers – based on customer request.

Audience

Target Audience:
BI and Data Analysts

Prerequisites:
Hands on experience w/ SQL and intensive work w/ rational databases like Oracle, MySQL and MS SQL Server.

Note: This course is designed for a team w/ up to 15 people in class.

Course Topics

Module 1: Introduction to NoSQL

  • CAP Theorem
  • What are the main concerns with RDBMS (SQL Server, Oracle, MySQL)
  • Key-value stores
  • Column Family stores
  • Document DBs
  • Map Reduce

Module 2: Introduction to MongoDB and Data Model Design

  • MongoDB product design and architecture
  • Documents and collections core concepts
  • Data Model migration from rational DB to document store
  • Data model best practices
  • Lab: Data model design for the case

Module 3: CRUD w/ Focus on SELECT

  • Find
    – Where condition
    – Fields Selection
    – Sort
    – Limit
  • Update
  • Insert
  • Delete
  • Lab: Data Analysis based on Find

Module 4: Optimizing Queries

  • Indexing
  • Query profiling
  • The query optimizer
  • Explain
  • Lab: Profile and tune queries

Module 5: Aggregation Framework

  • Aggregation framework method
    – Match
    – Project
    – Group
    – RedAct
    – Limit
    – Skip
    – Unwind
    – Sample
    – Sort
    – Geonear
    – Join
    – Out
  • Performance analysis
  • Lab: Data Analysis based on Aggregation framework
© Copyright - Skilit - Site by Dweb