Cloud NoSQL for SQL Professionals

Course details

NoSQL databases can store nonrelational data on a super large scale and solve problems regular databases can't handle: indexing the entire internet, predicting subscriber behavior, or targeting ads on a platform as large as Facebook. But with over 150 NoSQL database types, it can be hard for a SQL professional to know where to start. In this course, Lynn Langit breaks down these types into a few main categories and shows how to get your own NoSQL database up and running with easy-to-configure cloud solutions. Learn how to add and query data, apply the CAP theorem with NoSQL, and leverage key NoSQL trends such as multifunctionality and data lake NoSQL alternatives. Plus, explore AWS and GCP NoSQL database services such as DynamoDB, ElastiCache, and Bigtable.

Concepts

Introduction

Simplify the NoSQL ecosystem
Use cloud services

The Road to NoSQL

Manage data as file or tables
Add behavioral data
Add web-scale data
Add NoSQL databases

Understanding NoSQL Databases

Store data, query information including NoSQL
Overcome file system limits including NoSQL
Overcome RDBMS limits using NoSQL
Understand CAP Theorem and data
Apply CAP Theorem with NoSQL

Use Key-Value NoSQL

Store huge, in-memory lookup lists on NoSQL
Use Cloud Memorystore for Redis on GCP
Use AWS ElastiCache for Redis
Review NoSQL key-value architecture

Use Columnar NoSQL

Store events on NoSQL
Use Cloud Cassandra on AWS
Use GCP BigTable
Use GCP BigQuery
Review NoSQL columnar architecture

Use Document NoSQL

Store customer activity using NoSQL
Use Cloud MongoDB on GCP
Use AWS DocumentDB
Use AWS DynamoDB
Review NoSQL document architecture

Use Graph NoSQL

Store customer relations using NoSQL
Use Neo4j on Kubernetes
Use AWS Neptune
Review NoSQL Graph architecture

Use Specialty NoSQL

Store real-time events using NoSQL
Use GCP Firestore
Store IoT events
Use AWS IoT events
Use AWS TimeStream
Store blockchain entries using NoSQL
Use AWS QLDB
Google Cloud Vertex AI Vector Search

Understand NoSQL Trends

Consolidation and cloud for NoSQL
Multifunction NoSQL databases
DataLake NoSQL alternatives

Conclusion

Next steps with NoSQL