Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Introduction to NoSQL

via DataCamp

Overview

Conquer NoSQL and supercharge data workflows. Learn Snowflake to work with big data, Postgres JSON for handling document data, and Redis for key-value data.

In recent years, NoSQL databases have seen a surge in popularity due to their ability to handle large volumes of unstructured data. Learning to leverage NoSQL tools such as column-oriented, document, key-value, and graph databases allows data engineers, analysts, and scientists to interact with a wider breadth of data. These NoSQL databases bring additional functionality to data storage and retrieval that isn’t available in traditional relational databases.

Dive into the world of column-oriented databases and their role in the evolution of data warehouses. Practice working with Snowflake to create and update column-oriented tables, as well as optimize table design for performance. Explore Snowflake’s advanced functionality to work with semi-structured data.

Learn to use Postgres JSON as a tool to query document and object-oriented databases and the variety of data types that this technology supports. Hone your skills working with data stored in an array, as well as nested data.

Grow comfortable working with key-value databases and learn when this NoSQL data store is best applied. Practice using Redis to load and query data and experience the lightning-fast performance of in-memory databases. Explore graph databases and their use cases in data workflows.

Syllabus

  • Introduction to NoSQL databases
    • Explore the basics of NoSQL databases, and how they're used in a modern data architecture. Learn to identify the pros and cons of using column-oriented, document, key-value, and graph databases to make data available to downstream processes and data consumers.
  • Column-oriented Databases
    • Dive into column-oriented databases with the help of Snowflake. Learn to populate Snowflake tables using a number of tools, and uncover the fundamentals of micro-partitioning and data clustering to optimize query performance with query pruning. Leverage common table expressions, materialized and non-materialized views to streamline analytics workflows. Step into semi-structured data with Snowflake's VARIANT types.
  • Document Databases
    • Dive deep into the world of document data with Postgres JSON, and explore the intricacies of semi-structured data. Learn how to extract and transform top-level and nested document data using a number of built-in operators and functions.
  • Key-value and Graph Databases
    • Take your NoSQL skills to the next level by mastering the fundamentals of key-value databases. Explore common use-cases for key-value data, and learn how to use Redis and Python to read and write data. Wrap up with a basic overview of graph databases, and their place in the modern data stack.

Taught by

Jake Roach

Reviews

Start your review of Introduction to NoSQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.