Master the fundamentals of MongoDB, the industry-leading database management platform for NoSQL databases. In this course, beginners will learn the core skills they need to create and manage MongoDB databases. You don't need any prior knowledge of databases or NOSQL or SQL query language.

OBJECTIVE

You will learn:

1. The basics, showing how to install MongoDB and log into a local database server.

2. Then, you'll learn how to create new databases, design tables, define relationships, write queries, and use stored procedures and built-in functions.

3. Plus, you will practise how to perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring.

WHO SHOULD ATTEND THIS COURSE

1. If you are aspiring to learn NoSQL

2. You want to work with MongoDB databases 

3. Thinking about your own data storage needs

METHODOLOGY

This is a 4 days hands-on course. The trainer will explain how to make a database and maintain it using step-by-step practice. You will also be taught tips & tricks for good database management You will design your own database and also modify existing databases. You will get ample practise so that you can apply them in practical situations in database management.

DAY 1

1. Overview of NoSQL Databases

1.1 Core concepts 

1.2 Setting the scene for NoSQL 

1.3 Essential concepts: Relational Database 

1.4 Strengths of Relational Databases 

1.5 Limitations of Relational Databases 

1.6 The role of NoSQL Databases 

2. What is MongoDB?

2.1 What is MongoDB Database 

2.2 What is a document in MongoDB 

2.3 What is MongoDB Atlas 

2.4 LAB: Create and deploy an Atlas Cluster 

2.5 Atlas User Interface Overview 

2.6 Introducing the In-Browser IDE 

3. Importing, Exporting, and Querying Data

3.1 How does MongoDB store data

3.2 JSON vs. BSON

3.3 Importing and Exporting data

3.4 Data Explorer

3.5 The FIND command

4. Databases Creating and Manipulating Documents

4.1 Inserting New Documents - ObjectId

4.2 Inserting New Documents - insert() and errors

4.3 Updating Documents - Data Explorer

4.4 Updating Documents - mongo shell

4.5 Deleting Documents and Collections

DAY 2

5. Advanced CRUD Operations

5.1 Query Operators – Comparison

5.2 LAB: Comparison Operators

5.3 Query Operators – Logic

5.4 LAB: Logic Operators

5.5 Expressive Query Operator

5.6 LAB: $expr

5.7 Array Operators

5.8 LAB: Array Operators

5.9 Array Operators and Projection

5.10 Array Operators and Sub-Documents

5.11 LAB: Querying Array and Sub-Documents

6. Indexing and Aggregating Pipelines

6.1 Aggregation Framework

6.2 LAB: Aggregation Framework

6.3 sort() and limit()

6.4 Introduction to Indexes

6.5 Introduction to Data Modeling

6.6 Upsert - Update or Insert

DAY 3

7. Introduction to MongoDB Charts

1.1 Why learn MongoDB Charts

1.2 LAB: Connect a Dataset 

8. Chart Types

2.1 Types of Charts in MongoDB

2.2 Aggregation Pipelines :

2.21 Optimise data for visualisation

2.22 Clean-up data formatting

2.23 Reduce number of results

9. Create a Text Chart

3.1 Text Chart defined

3.2 Creating a Text Chart

3.3 Add a query to a Text Chart

10. Geospatial (Map) Chart

4.1 Geospatial Chart defined

4.2 Scatter geospatial chart

4.3 Customise geospatial chart

4.4 LAB: Connect 'sample_geospatial.shipwrecks'

4.5 LAB: Create a Geospatial Chart

11. Create a Bar Chart

5.1 Bar Chart defined

5.2 Adding a filter

5.3 LAB: Connect 'sample_restaurants'

5.4 LAB: Create a Bar Chart

12. Sharing & Embedding Chart

6.1 Customise our chart on the dashboard

6.2 Embedding chart feature

6.3 LAB: Embed a Chart

6.4 LAB: Automatically refresh a Chart

13. Dashboard Permissions

7.1 LAB: Adjust Chart Permissions

DAY 4

14. The Mongod

1.1 Mongod Options

1.2 LAB: Launching Mongod

1.3 Configuration File

1.4 LAB: Configuration file

1.5 File Structure

1.6 LAB: Change the default DB path

1.7 Basic Commands

1.8 Logging Basics

1.9 Profiling the database

1.10 LAB:Logging to a different facility

1.11 Basic Security 1

1.12 Built-in Roles 1

1.13 LAB:Creating first application user

1.14 Server Tools Overview

1.15 LAB:Importing a dataset

15. Replication

2.1 What is Replication

2.2 MongoDB Replica Set

2.3 Setting-up a Replica Set

2.4 LAB: Deploy a Replica Set

2.5 Replication Configuration Document

2.6 Replication Commands

2.7 Local DB

2.8 Reconfiguring a Running Replica Set

2.9 LAB: Reconfigure a Replica Set

2.10 Reads and Writes on a Replica Set

2.11 Failover and Elections

2.12 Write Concerns 1

2.13 LAB: Writes with Failovers

2.14 Read Concerns

2.15 Read Preferences

2.16 LAB: Read Preferences

16. Sharding

3.1 What is Sharding

3.2 When to Shard

3.3 Sharding Architecture

3.4 Setting-up a Sharded Cluster

3.5 LAB: Deploy a Sharded Cluster

3.6 Config DB

3.7 Shard Keys

3.8 Picking-up a Good Shard Key

3.9 Hashed Shard Keys

3.10 LAB: Shard a Collection

3.11 Chunks

3.12 LAB: Documents in a Chunk

3.13 Balancing

3.14 Queries in a Sharded Cluster

3.15 Targeted Queries vs Scatter Gather 1 

3.16 LAB: Detect Scatter Gather queries