This course will provide you with technical hands-on knowledge of NoSQL databases and Database-as-a-Service (DaaS) offerings. With the advent of Big Data and agile development methodologies, NoSQL databases have gained a lot of relevance in the database landscape. Their main advantage is the ability to effectively handle scalability and flexibility issues raised by modern applications.

You will start by learning the history and the basics of NoSQL databases and discover their key characteristics and benefits. You will learn about the four categories of NoSQL databases and how they differ from each other.

You will explore the architecture and features of several different implementations of NoSQL databases, namely MongoDB, Cassandra, and IBM Cloudant.

Throughout the course you will get practical experience using these NoSQL databases to perform standard database management tasks, such as creating and replicating databases, loading and querying data, modifying database permissions, indexing and aggregating data, and sharding (or partitioning) data.

The course ends with a hands-on project to test your understanding of some of the basics of working with several NoSQL database offerings.

Course Syllabus

Module 1 – Introducing NoSQL
Basics of NoSQL
Overview of NoSQL
Characteristics of NoSQL Databases
NoSQL Database Categories – Key-Value
NoSQL Database Categories – Document
NoSQL Database Categories – Column
NoSQL Database Categories – Graph
Database Deployment Options
Choosing an Appropriate Data Layer
Working with Distributed Data
ACID vs BASE
Distributed Databases
The CAP Theorem
Challenges in Migrating from RDBMS to NoSQL Databases

Module 2 – Introducing MongoDB – An Open-Source NoSQL Database

Basics of MongoDB
Overview of MongoDB
Advantages of MongoDB
Use Cases for MongoDB
Lab: Getting Started with MongoDB
Getting Started with MongoDB
CRUD Operations
Lab: MongoDB CRUD
Indexes
Lab: MongoDB Indexing
Aggregation Framework
Lab: MongoDB Aggregation
Replication & Sharding
Accessing MongoDB from Python
Lab: Accessing MongoDB from Python

Module 3 – Introducing Apache Cassandra – An Open-Source NoSQL Database

Cassandra Basics
Overview of Cassandra
Architecture of Cassandra
Key Features of Cassandra
Cassandra Data Model - Part 1
Cassandra Data Model - Part 2
Introduction to Cassandra Query Language (cqlsh)
Lab: Using the CQL Shell (cqlsh)
Working with Cassandra
CQL Data Types
Keyspace Operations
Lab: Keyspace Operations
Table Operations
Lab: Table Operations
CRUD Operations - Part 1
CRUD Operations - Part 2
Lab: CRUD Operations

Module 4 – Introducing IBM Cloudant – A NoSQL DBaaS
Cloudant Basics
Overview of Cloudant
Cloudant Architecture and Key Technologies
Cloudant Benefits and Solutions
Deployment Options for Cloudant
Lab: Sign up for IBM Cloud account
Lab: Create an instance of IBM Cloudant

Working with Cloudant
Dashboards in Cloudant
Lab: Dashboards in Cloudant
Working with Databases in Cloudant
Lab: Working with Databases in Cloudant
HTTP API Basics
Working with the HTTP API
Query Optimization with Indexes
Lab: Querying Data using the HTTP API
How to Access Documentation and Support Resources

Module 5 – Final Project – Working with NoSQL Databases
Peer-Graded Final Assignment
Lab: Setup & Practice Assignment
Project Overview
Lab: Final Assignment Project
Project Submission & Peer Review
Final Quiz

Recommended Skills Prior to Taking this Course

Computer and IT literacy. Curiosity about how data is managed.

What You'll Learn

Define the term NoSQL and the technology it references.
Explain the characteristics of NoSQL databases.
Describe the major categories of NoSQL datastores (document, key-value, graph, etc.) and their architectural differences.
List the most commonly used NoSQL datastores, their primary use cases and benefits (MongoDB, Cassandra, Cloudant, Couch DB, etc.).
Understand the factors affecting return on investment for using locally hosted databases, versus hosted database versus DBaaS.
Describe the architecture, features, and key benefits of MongoDB as a NoSQL database.
Demonstrate hands-on working knowledge of MongoDB and perform various common tasks (including CRUD operations, limit and sort records, indexing, aggregation, replication, sharding)
Describe the architecture, features, and key benefits of Cassandra as a NoSQL database.
Demonstrate hands-on working knowledge of Cassandra and perform various common tasks (including using the CQL shell, keyspace operations, table operations, and CRUD operations)
Describe the architecture, features, and key benefits of Cloudant as a NoSQL database.
Demonstrate hands-on working knowledge of Cloudant and perform various common tasks (including creating the database, add documents, query data, utilize the HTTP API).

NoSQL Database Basics

Language

Topic

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update