This repository contains exercises based on my collection of books, focusing on SQL querying and PL/SQL programming. Practical exercises inspired by the concepts and examples found in the books, internet.
General
- hr-dwh transformation
Practice with Oracle HR schema
#sql#dbt#shell#duckdb#liquibase#eda#analytics - sql-advanced-queries
Practice with analytical SQL (e.g. window functions)
#sql#jupiternotebook#oracle
Spark
- spark/vp-course
PySpark Course + practice
Pandas
- py-misc/drill-down
Static drill-down with Pandas
#seaborn#pandas
DBT
- dbt-hello-world
Minimal dbt project
#sql#dbt
...and more!