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.
Kurs Kostenlos Starten4 Stunden15 Videos59 Übungen3.519 LernendeLeistungsnachweis
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.Trainierst du 2 oder mehr?
Versuchen DataCamp for BusinessBeliebt bei Lernenden in Tausenden Unternehmen
Kursbeschreibung
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.Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
Professioneller Dateningenieur in Python
Gehe zu Track- 1
Introduction to NoSQL databases
KostenlosExplore 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
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
Professioneller Dateningenieur in Python
Gehe zu TrackJake Roach
Mehr AnzeigenData Engineer
Was sagen andere Lernende?
Melden Sie sich an 15 Millionen Lernende und starten Sie Introduction to NoSQL Heute!
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.