课程

Introduction to NoSQL

基础技能水平

更新时间 2025年12月

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.

免费开始课程

SQLData Engineering4 小时15 视频59 练习4,450 经验值9,602成就声明

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

培训2人或更多？

试用DataCamp for Business

课程描述

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.

先决条件

Database Design

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 NoSQL

50 经验值

Querying NoSQL databases

100 经验值

Exploring document data

50 经验值

NoSQL use-cases and applications

50 经验值

Tabular NoSQL data stores

50 经验值

Column-oriented databases

50 经验值

Querying a column-oriented database

100 经验值

Filtering a column-oriented database

100 经验值

Non-tabular NoSQL data stores

50 经验值

Identifying tabular and non-tabular NoSQL data stores

100 经验值

Querying document databases

100 经验值

Querying nested documents with Postgres JSON

100 经验值

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 databases

50 经验值

CREATE TABLE with Snowflake

100 经验值

Populating Snowflake tables

50 经验值

COPY INTO and CREATE TABLE ... AS with Snowflake

100 经验值

Advanced column-oriented database techniques

50 经验值

Micro-partitioning and data clustering with Snowflake

50 经验值

Query pruning with micro-partitioning

50 经验值

Leveraging micro-partitions and data clustering

100 经验值

Analytics workflows for column-oriented databases

50 经验值

Common table expressions with Snowflake

100 经验值

Building an analytics workflow with Snowflake

50 经验值

Materialized vs. non-materialized VIEWs

100 经验值

Working with semi-structured data in Snowflake

50 经验值

Semi-structured Snowflake data types

50 经验值

Querying semi-structured data in Snowflake

100 经验值

Querying nested semi-structured data

100 经验值

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 Postgres

50 经验值

JSON and JSONB data in Postgres

50 经验值

Executing queries with sqlalchemy and pandas

100 经验值

Querying JSON and JSONB data from Postgres

100 经验值

Storing JSON data in Postgres

50 经验值

Loading Postgres with semi-structured data

50 经验值

Converting tabular data to JSON

100 经验值

Extracting keys from JSON objects with Postgres

100 经验值

Querying JSON data using Postgres

50 经验值

Querying top-level JSON data

100 经验值

Finding the type of JSON data

100 经验值

Working with nested JSON objects

100 经验值

Filtering document databases with Postgres JSON

100 经验值

Advanced Postgres JSON query techniques

50 经验值

Arrow and hash arrow operators

50 经验值

100 经验值

Extracting document data

100 经验值

Manipulating document data

100 经验值

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 databases

50 经验值

Key-value databases

50 经验值

Key-value vs. document databases

100 经验值

Connecting to a Redis cluster

100 经验值

Storing and retrieving key-value data

50 经验值

Storing key-value data with Redis

100 经验值

Retrieving key-value data with Redis

100 经验值

Storing Python dictionaries with Redis

100 经验值

Graph databases

50 经验值

Understanding graph databases

50 经验值

Graph database providers

50 经验值

Using graph databases

100 经验值

Wrapping up!

50 经验值

Introduction to NoSQL

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Introduction to NoSQL！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。