InsideEdgeInsideEdge
Download App
Stop 06 · Database ServicesTopics · 8/10

Data Warehousing (Redshift, BigQuery)

Part of the Cloud Computing Roadmap

In short

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

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

More topics at this stop

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

Stuck on this topic? Ask an Insider

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

Download
InsideEdge