Accéder au contenu principal

cours

Introduction to NoSQL

Débutant

Updated 12/2024

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.

Commencer le cours gratuitement

Inclus gratuitementPremium or Teams

SQLIngénierie des données4 heures15 vidéos59 exercices4,450 XP3,930Déclaration de réalisation

Créez votre compte gratuit

Google LinkedIn Facebook

ou

En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.

Formation de 2 personnes ou plus ?

Essayer DataCamp for Business

Apprécié par les apprenants de milliers d’entreprises

Description du cours

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.

Conditions préalables

Database Design

1

Introduction to NoSQL databases

Commencer le chapitre

Introduction to NoSQL

Querying NoSQL databases

Exploring document data

NoSQL use-cases and applications

Tabular NoSQL data stores

Column-oriented databases

Querying a column-oriented database

Filtering a column-oriented database

Non-tabular NoSQL data stores

Identifying tabular and non-tabular NoSQL data stores

Querying document databases

Querying nested documents with Postgres JSON

2

Column-oriented Databases

Commencer le chapitre

Populating column-oriented databases

CREATE TABLE with Snowflake

Populating Snowflake tables

COPY INTO and CREATE TABLE ... AS with Snowflake

Advanced column-oriented database techniques

Micro-partitioning and data clustering with Snowflake

Query pruning with micro-partitioning

Leveraging micro-partitions and data clustering

Analytics workflows for column-oriented databases

Common table expressions with Snowflake

Building an analytics workflow with Snowflake

Materialized vs. non-materialized VIEWs

Working with semi-structured data in Snowflake

Semi-structured Snowflake data types

Querying semi-structured data in Snowflake

Querying nested semi-structured data

3

Document Databases

Commencer le chapitre

Understanding JSON data in Postgres

JSON and JSONB data in Postgres

Executing queries with sqlalchemy and pandas

Querying JSON and JSONB data from Postgres

Storing JSON data in Postgres

Loading Postgres with semi-structured data

Converting tabular data to JSON

Extracting keys from JSON objects with Postgres

Querying JSON data using Postgres

Querying top-level JSON data

Finding the type of JSON data

Working with nested JSON objects

Filtering document databases with Postgres JSON

Advanced Postgres JSON query techniques

Arrow and hash arrow operators

Extracting document data

Manipulating document data

4

Key-value and Graph Databases

Commencer le chapitre

Introduction to key-value databases

Key-value databases

Key-value vs. document databases

Connecting to a Redis cluster

Storing and retrieving key-value data

Storing key-value data with Redis

Retrieving key-value data with Redis

Storing Python dictionaries with Redis

Graph databases

Understanding graph databases

Graph database providers

Using graph databases

Wrapping up!

Introduction to NoSQL

Cours
terminé

Earn Déclaration de réalisation

Ajoutez ces informations d’identification à votre profil LinkedIn, à votre CV ou à votre CV
Partagez-le sur les réseaux sociaux et dans votre évaluation de performance

Inclus avecPremium or Teams

S'inscrire maintenant

Inscrivez-vous 15 millions d’apprenants et commencer Introduction to NoSQL Aujourd’hui!

Créez votre compte gratuit

Google LinkedIn Facebook

ou

En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.