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
New
Top
Community
Day Of The Week Analysis in SQL - Issue 39
How to break down user activity by day of the week in SQL. Simple to pull, takes a few minutes to write the query, and data is easy to interpret and…
 • 
Olga Berezovsky
4
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
1
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
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
How To Pass A SQL Interview For A Data Scientist Position - Issue 140
A case study challenge breakdown for a data scientist position solved in SQL
 • 
Olga Berezovsky
© 2023 Olga Berezovsky
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing