Cloud NoSQL for SQL Professionals

Introduction

• Simplify the NoSQL ecosystem
• Use cloud services

1. The Road to NoSQL

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

2. 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

3. 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

4. Use Columnar NoSQL

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

5. Use Document NoSQL

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

6. Use Graph NoSQL

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

7. 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

8. Understand NoSQL Trends

• Consolidation and cloud for NoSQL
• Multifunction NoSQL databases
• DataLake NoSQL alternatives

Conclusion

• Next steps with NoSQL