InsideEdgeInsideEdge
Download App

Phase 6 · Database Services

Topics

Data Warehousing (Redshift, BigQuery)

Part of the Cloud Computing Roadmap.

Summary

Databases optimized for large-scale analytical queries across huge datasets, rather than the fast, small transactional queries relational databases are built for — the destination for business intelligence and reporting workloads.

How to Learn This

  • 1Run a sample analytical query against a public dataset in a managed data warehouse.
  • 2Learn the conceptual difference between OLTP (transactional) and OLAP (analytical) database design.
  • 3Understand why a data warehouse is usually fed by an ETL/ELT pipeline, not written to directly by an app.

Previous

Caching Layers (ElastiCache / Redis)

Next

Choosing the Right Database

More topics in Database Services

Relational Databases in the Cloud (RDS)NoSQL Databases (DynamoDB, Cosmos DB)Database Replication & High AvailabilityDatabase Backups & SnapshotsRead Replicas & Scaling ReadsDatabase Migration BasicsCaching Layers (ElastiCache / Redis)Choosing the Right DatabaseDatabase Security
InsideEdge

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download
InsideEdge