BIWave Substack

BIWave Substack

Home
Notes
Chat
Power BI
SQL
Python
Data
Archive
About

SQL

Here are my posts about SQL:


  • Advanced SQL for data analysis.

  • Common Table Expressions.

  • Data Cleaning in SQL.

  • Debugging in SQL

  • Fuzzy matching.

  • How to handle missing data.

  • Joins in SQL.

  • Naming Conventions.

  • Materialized Views.

  • Regular Expressions.

  • SQL Indexes.

  • SQL Window Functions.

  • SQL Performance optimisation.

  • Text Manipulation in SQL

  • Time Intelligence in SQL

© 2026 BIWave · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture