Introduction to NoSQL
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.
Start Course for Free4 hours15 videos59 exercises
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Training 2 or more people?Try DataCamp For Business
Loved by learners at thousands of companies
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.For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Professional Data Engineer in Python
Go To Track- 1
Introduction to NoSQL databases
FreeExplore 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 xpQuerying NoSQL databases100 xpExploring document data50 xpNoSQL use-cases and applications50 xpTabular NoSQL data stores50 xpColumn-oriented databases50 xpQuerying a column-oriented database100 xpFiltering a column-oriented database100 xpNon-tabular NoSQL data stores50 xpIdentifying tabular and non-tabular NoSQL data stores100 xpQuerying document databases100 xpQuerying 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.
Populating column-oriented databases50 xpCREATE TABLE with Snowflake100 xpPopulating Snowflake tables50 xpCOPY INTO and CREATE TABLE ... AS with Snowflake100 xpAdvanced column-oriented database techniques50 xpMicro-partitioning and data clustering with Snowflake50 xpQuery pruning with micro-partitioning50 xpLeveraging micro-partitions and data clustering100 xpAnalytics workflows for column-oriented databases50 xpCommon table expressions with Snowflake100 xpBuilding an analytics workflow with Snowflake50 xpMaterialized vs. non-materialized VIEWs100 xpWorking with semi-structured data in Snowflake50 xpSemi-structured Snowflake data types50 xpQuerying semi-structured data in Snowflake100 xpQuerying nested semi-structured data100 xp - 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.
Understanding JSON data in Postgres50 xpJSON and JSONB data in Postgres50 xpExecuting queries with sqlalchemy and pandas100 xpQuerying JSON and JSONB data from Postgres100 xpStoring JSON data in Postgres50 xpLoading Postgres with semi-structured data50 xpConverting tabular data to JSON100 xpExtracting keys from JSON objects with Postgres100 xpQuerying JSON data using Postgres50 xpQuerying top-level JSON data100 xpFinding the type of JSON data100 xpWorking with nested JSON objects100 xpFiltering document databases with Postgres JSON100 xpAdvanced Postgres JSON query techniques50 xpArrow and hash arrow operators50 xp#> and #>>100 xpExtracting document data100 xpManipulating document data100 xp - 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 key-value databases50 xpKey-value databases50 xpKey-value vs. document databases100 xpConnecting to a Redis cluster100 xpStoring and retrieving key-value data50 xpStoring key-value data with Redis100 xpRetrieving key-value data with Redis100 xpStoring Python dictionaries with Redis100 xpGraph databases50 xpUnderstanding graph databases50 xpGraph database providers50 xpUsing graph databases100 xpWrapping up!50 xp
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Professional Data Engineer in Python
Go To TrackJake Roach
See MoreData Engineer
Jake Roach is a Field Data Engineer at Astronomer and DataCamp Instructor. A former Lead Data Engineer, Jake built a a state-of-the-art data platform for a multi-billion dollar organization, powered by Astronomer, Airflow, AWS, and Databricks. His passion for all things data engineering is contagious. Jake loves to write tutorials, teach DataCamp courses, and contribute to open source. Born and raised in Buffalo, NY, when he's not working with data, you can find him out at the golf course playing a quick nine holes before dark!
What do other learners have to say?
Join over 14 million learners and start Introduction to NoSQL today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.