Petascale Labs
The PlatformSimulation Arcade
RoadmapCoursesChallengesTopicsToolsFree
PricingBlog
  1. Home/
  2. Topics/
  3. Upserts
Topic

Upserts

Upserts shows up across 3 courses in 2 layersof the data platform stack. Here's where it's taught, a free way to practice it, and what to learn next.

Where it's taught

⇄Ingestion & Transport

Batch Ingestion Patterns

Connector-based batch ingestion: full vs incremental, cursors, idempotency, the Singer spec, and quality gates.

10 ch · 3h 30m

1 free
◈Query Engines & OLAP

Real-Time OLAP

15 ch · 4h 18m

1 free

Designing OLAP Systems

12 ch · 3h 25m

1 free

Related topics

↗pre-aggregation↗apache druid↗apache pinot↗batch ingestion↗cost vs latency↗data federation↗data quality↗denormalization↗ELT↗fivetran

Start learning upserts free

The first chapter of every course is free to read — no account needed.

Start: Batch Ingestion Patterns →All strata
Petascale Labs

The physics layer of data

From byte-level storage to business-grade metrics. Built with depth, not breadth.

Curriculum

Data Engineer RoadmapAll strataStorage & File FormatsIngestion & TransportOpen Table FormatsCompute EnginesOrchestration & PipelinesQuery Engines & OLAPSemantic & Metrics LayerPII & Data Governance

Tools

All toolsParquet ViewerFreeSCD PlaygroundFreePII Masking GeneratorFree

Company

AboutBlogContact

Legal

Privacy PolicyTerms of ServiceCookie Policy

Email

hello@petascalelabs.com

Support

support@petascalelabs.com

Company

Petascale Labs, Inc.

© 2026 Petascale Labs, Inc. All rights reserved.

PrivacyTermsCookiesContact