Record · corpus.blog/posts/01a087e4-ec92-71cc-b6d2-55ba68519149

Summer Data Engineering Roadmap

Blogs - Data Engineering Blog & Second Brain · published 6 August 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at ssp.sh Wayback capture

0blogs citing

First cited: —
Most recent: —
Rank this month: not ranked
Links from this post: 96
Words captured: 3,111

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

https://www.ssp.sh/services/

ssp.sh

The Data Engineering Toolkit: Essential Tools for Your Machine Read at the source ↗

ssp.sh

The Data Engineering Toolkit: Infrastructure, DevOps, and Beyond Read at the source ↗

ssp.sh

https://www.ssp.sh/blog/data-engineering-roadmap/de-roadmap.webp

ssp.sh

https://www.w3schools.com/sql/sql_intro.asp

w3schools.com

https://www.freecodecamp.org/news/learn-relational-database-basics-key-concepts-for-beginners/

freecodecamp.org

https://www.geeksforgeeks.org/dbms/introduction-of-relational-model-and-codd-rules-in-dbms/

geeksforgeeks.org

https://mode.com/sql-tutorial/sql-window-functions/

mode.com

https://www.ssp.sh/brain/cte/

ssp.sh

https://www.geeksforgeeks.org/dbms/acid-properties-in-dbms/

geeksforgeeks.org

https://www.datacamp.com/blog/oltp-vs-olap

datacamp.com

https://motherduck.com/learn-more/what-is-OLAP/

motherduck.com

https://medium.com/@suffyan.asad1/getting-started-with-dbt-data-build-tool-a-beginners-guide-to-building-data-transformations-28e335be5f7e

medium.com

https://thedatatoolbox.substack.com/p/getting-started-with-sqlmesh-a-comprehensive

thedatatoolbox.substack.com

https://betterexplained.com/articles/a-visual-guide-to-version-control/

betterexplained.com

https://www.coursera.org/learn/version-control-with-git

coursera.org

https://docs.github.com/en/pull-requests/collaborating-with-pull-requests/proposing-changes-to-your-work-with-pull-requests/about-pull-requests

docs.github.com

https://www.atlassian.com/git/tutorials/comparing-workflows

atlassian.com

https://dev.to/yankee/practical-guide-to-git-worktree-58o0

dev.to

https://www.freecodecamp.org/news/bash-scripting-tutorial-linux-shell-script-and-command-line-for-beginners/

freecodecamp.org

https://www.codecademy.com/learn/learn-the-command-line

codecademy.com

https://www.geeksforgeeks.org/techtips/apt-and-yum-package-managers-in-linux/

geeksforgeeks.org

https://brew.sh/

brew.sh

https://www.hostinger.com/tutorials/ssh-tutorial-how-does-ssh-work

hostinger.com

https://ghostinthedata.info/posts/2025/2025-02-02-setting-up-your-data-engineering-environment-on-macos/

ghostinthedata.info

https://github.com/basecamp/omakub

github.com

https://github.com/basecamp/omarchy

github.com

https://medium.com/bitgrit-data-science-publication/how-to-setup-a-windows-laptop-for-data-science-e56ee3f0dcf0

medium.com

A Beginners Guide To Cron Jobs (2026)

ostechnix.com

https://www.integrate.io/blog/mastering-data-warehouse-modeling/

integrate.io

https://www.getdbt.com/blog/guide-to-dimensional-modeling

getdbt.com

https://learn.microsoft.com/en-us/fabric/data-warehouse/dimensional-modeling-overview

learn.microsoft.com

https://www.datacamp.com/blog/star-schema-vs-snowflake-schema

datacamp.com

https://www.freecodecamp.org/news/database-normalization-1nf-2nf-3nf-table-examples/

freecodecamp.org

https://www.montecarlodata.com/blog-fact-vs-dimension-tables-in-data-warehousing-explained/

montecarlodata.com

https://www.ssp.sh/brain/granularity/

ssp.sh

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/

kimballgroup.com

https://www.astera.com/type/blog/data-warehouse-concepts/

astera.com

https://www.scalefree.com/blog/data-vault/quick-guide-of-a-data-vault-2-0-implementation/

scalefree.com

https://learn.microsoft.com/en-us/fabric/data-factory/slowly-changing-dimension-type-two

learn.microsoft.com

https://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/

kimballgroup.com

https://realpython.com/python-beginner-tips/

realpython.com

https://motherduck.com/blog/duckdb-python-e2e-data-engineering-project-part-1/

motherduck.com

https://www.youtube.com/watch?v=ZX5FdqzGT1E

youtube.com

https://motherduck.com/learn-more/dataframes/

motherduck.com

https://motherduck.com/blog/duckdb-versus-pandas-versus-polars/

motherduck.com

https://www.youtube.com/watch?v=4DIoACFItec

youtube.com

https://realpython.com/python-pydantic/

realpython.com

https://docs.pytest.org/en/stable/getting-started.html

docs.pytest.org

https://fastapi.tiangolo.com/tutorial/

fastapi.tiangolo.com

https://airflow.apache.org/docs/apache-airflow/stable/index.html

airflow.apache.org

https://airflow.apache.org/docs/apache-airflow/stable/best-practices.html

airflow.apache.org

https://motherduck.com/docs/getting-started/sample-data-queries/datasets/

motherduck.com

https://aws.amazon.com/getting-started/

aws.amazon.com

https://azure.microsoft.com/en-us/get-started

azure.microsoft.com

https://cloud.google.com/docs/get-started/

cloud.google.com

https://motherduck.com/

motherduck.com

https://cloud.google.com/bigquery/docs/quickstarts

cloud.google.com

https://learn.microsoft.com/en-us/fabric/

learn.microsoft.com

https://cloud.google.com/composer/docs

cloud.google.com

https://lakefs.io/blog/object-storage/

lakefs.io

https://motherduck.com/docs/getting-started/interfaces/motherduck-quick-tour/

motherduck.com

https://www.geeksforgeeks.org/data-analysis-and-visualization-with-jupyter-notebook/

geeksforgeeks.org

https://atlan.com/metrics-layer/

atlan.com

https://www.toptal.com/designers/data-visualization/data-visualization-best-practices

toptal.com

10 ways to use fewer colors in your data visualizations Read at the source ↗

datawrapper.de

https://vega.github.io/vega-lite/

vega.github.io

https://www.controlling-strategy.com/hichert-success-regeln.html

controlling-strategy.com

https://www.youtube.com/watch?v=F9yHuAO50PQ&t=2s

youtube.com

https://www.rilldata.com/blog/has-self-serve-bi-finally-arrived-thanks-to-ai

rilldata.com

Change Data Capture + Event-Driven Architecture Read at the source ↗

codeopinion.com

https://howtodoinjava.com/kafka/apache-kafka-tutorial/

howtodoinjava.com

https://dev.to/mage_ai/getting-started-with-apache-flink-a-guide-to-stream-processing-e19

dev.to

https://www.datacamp.com/blog/change-data-capture

datacamp.com

https://bryteflow.com/postgres-cdc-6-easy-methods-capture-data-changes/

bryteflow.com

https://www.startdataengineering.com/post/implement_data_quality_with_great_expectations/

startdataengineering.com

https://docs.dagster.io/guides/test/unit-testing-assets-and-ops

docs.dagster.io

https://www.montecarlodata.com/blog-data-lineage/

montecarlodata.com

https://sixthsense.rakuten.com/blog/Demystifying-Data-Observability-A-Beginners-Guide-for-2025

sixthsense.rakuten.com

https://atlan.com/data-contracts/

atlan.com

https://www.informatica.com/resources/articles/what-is-metadata-management.html

informatica.com

https://docs.confluent.io/platform/current/schema-registry/fundamentals/data-contracts.html

docs.confluent.io

https://spot.io/resources/cloud-cost/cloud-cost-optimization-15-ways-to-optimize-your-cloud/

spot.io

https://mode.com/sql-tutorial/sql-performance-tuning

mode.com

https://turbo360.com/blog/significance-of-sql-query-consumption-analysis

turbo360.com

https://min.io/product/automated-data-tiering-lifecycle-management

min.io

https://www.datacamp.com/tutorial/docker-tutorial

datacamp.com

https://kubernetes.io/docs/tutorials/

kubernetes.io

https://developer.hashicorp.com/terraform/tutorials

developer.hashicorp.com

https://medium.com/@mcgeejasond/devops-monitoring-and-logging-explained-939c3b5e17c4

medium.com

https://circleci.com/blog/learn-iac-part02/

circleci.com

https://www.youtube.com/watch?v=3pLKTmdWDXk&t=1s

youtube.com

https://motherduck.com/learn-more/

motherduck.com

https://www.youtube.com/@motherduckdb

youtube.com

https://app.motherduck.com

app.motherduck.com

https://bsky.app/search?q=domain%3A%20https://www.ssp.sh/blog/data-engineering-roadmap/

bsky.app