After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
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.
Column-oriented 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.Document databases
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.Key-value and graph databases
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.Prerequisites
Curriculum
Course outline
1
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.
- Introduction to NoSQL50 XP
- Querying NoSQL databases100 XP
- Exploring document data50 XP
- NoSQL use-cases and applications50 XP
- Tabular NoSQL data stores50 XP
- Column-oriented databases50 XP
- Querying a column-oriented database100 XP
- Filtering a column-oriented database100 XP
- Non-tabular NoSQL data stores50 XP
- Identifying tabular and non-tabular NoSQL data stores100 XP
- Querying document databases100 XP
- Querying nested documents with Postgres JSON100 XP
2
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.
3
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.
4
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.
Introduction to NoSQL
Course
Complete
