Share Description
In this course, you will learn:
- Understand the distinction between MongoDB Query Language and Structured Query Language (SQL). You will also learn how to convert SQL create, read, update, and delete (CRUD) statements to MongoDB CRUD statements.
- About MongoDB and its document model? This unit teaches you how to manage MongoDB databases, collections, and documents.
- The fundamentals of data modeling, including how data is stored and the relationships between distinct entities in your data, in MongoDB.
- Improve MongoDB performance by understanding how to create single, compound, and multikey indexes, as well as how to delete them.
- Discover the inner workings of indexes and how they increase query efficiency.
- How to build aggregation pipelines, which allow you to analyze and summarize data by connecting stages that filter, sort, group, and/or transform data.
- How to use the Atlas SQL Interface, link BI or Reporting Tools, and integrate Atlas Data Federation for efficient data analysis and visualization.
- About MongoDB's Relational Migrator and how to use it to move data from relational databases to MongoDB.
- How to import CSV data into MongoDB with four different techniques.
- How to use the Atlas SQL Interface to connect Power BI to MongoDB Atlas and generate rich reports, visualizations, and dashboards.
Syllabus:
- MongoDB for SQL Experts
- MongoDB and the Document Model
- MongoDB Data Modeling Intro
- MongoDB Indexes
- MongoDB Indexes II
- MongoDB Aggregation
- Atlas SQL Interface
- MongoDB Relational Migrator
- Importing CSV Data into MongoDB
- Power BI Connector
- Tableau Connector
