Data Analysis Journal

Home
Notes
Product Analysis
A/B testing
What experts say
SQL
Python
Machine Learning
Archive
Leaderboard
About

SQL

All things SQL - tutorials, interview questions, and solutions
A Selection Of SQL Tutorials - Issue 141
A roundup of my favorite free SQL tutorials and articles to either get started with or to keep your querying skills strong.
 • 
Olga Berezovsky
1
Parsing Semi-Structured Data In SQL - Issue 177
How to process and work with JSON formats via SQL in Snowflake
 • 
Olga Berezovsky
SQL For Weekday Product Usage Analysis - Issue 166
How to get the frequency of user engagement in SQL: day of the week analysis
 • 
Olga Berezovsky
2
A Selection Of SQL Tutorials - Issue 163
A roundup of my favorite free SQL tutorials to get started with or advance at querying
 • 
Olga Berezovsky
2
SQL And Python Mistakes To Avoid - Issue 155
Don’t repeat my mistakes. Learning from common errors and how to avoid them
 • 
Olga Berezovsky
Top 10 Advanced SQL Functions For Data Analysis - Issue 151
A roundup of helpful SQL functions to leverage for statistics, data generation, processing, and analytics.
 • 
Olga Berezovsky
How To Get Average Logins Per User Per Day - Issue 143
SQL solution for getting average user activity per day for weekly or monthly reporting
 • 
Olga Berezovsky
© 2024 Olga Berezovsky
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great culture