Introduction to NoSQL databases
Introduction to NoSQL
()
Exploring document data
Tabular NoSQL data stores
()
Querying a column-oriented database
Filtering a column-oriented database
Non-tabular NoSQL data stores
()
Querying document databases
Column-oriented Databases
Populating column-oriented databases
()
Advanced column-oriented database techniques
()
Leveraging micro-partitions and data clustering
Analytics workflows for column-oriented databases
()
Working with semi-structured data in Snowflake
()
Querying semi-structured data in Snowflake
Querying nested semi-structured data
Document Databases
Understanding JSON data in Postgres
()
Executing queries with sqlalchemy and pandas
Querying JSON and JSONB data from Postgres
Storing JSON data in Postgres
()
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
Filtering document databases with Postgres JSON
Advanced Postgres JSON query techniques
()
#> and #>>
Extracting document data
Manipulating document data
Key-value and Graph Databases
Introduction to key-value 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
()
Wrapping up!
()
disneyland_reviews_data.csv
(5.8 MB)
london_weather_data.csv
(795 KB)
olympics_fact_data.csv
(9.0 MB)