HyperLogLog implemented using SQL
We look at an implementation of the HyperLogLog cardinality estimation algorithm written entirely in declarative SQL- 27660Murphy ≡ DeepGuide
Model Selection For dbt CLI
A complete cheatsheet for selecting specific models when running dbt commands- 23924Murphy ≡ DeepGuide
4 Useful BigQuery SQL Functions You May Not Know
And how to use them- 23879Murphy ≡ DeepGuide
How to Compare Two Tables For Equality in BigQuery
Compare tables and extract their differences with standard SQL- 26362Murphy ≡ DeepGuide
A Quick Start to Connecting to PostgreSQL and Pulling Data into Pandas
Get you on your way to data analysis and model building quickly by pulling PostgreSQL data into Pandas- 26274Murphy ≡ DeepGuide
Learn dbt the Easy Way
An analytics engineer's guide to key db- 27810Murphy ≡ DeepGuide
SQL Riddles to Test Your Wits
SQL is a deceptively simple language. Across its many dialects, users can query databases in a syntax similar to English. What you see is what you get… until you don’t. Every now and then I come across a query that produces a result completely- 23418Murphy ≡ DeepGuide
Running SQL Queries in Jupyter Notebook using JupySQL, DuckDB, and MySQL
Learn how to run SQL in your Jupyter Notebooks- 22250Murphy ≡ DeepGuide
RANK() vs DENSE_RANK() vs ROW_NUMBER() in SQL
Understanding the difference between these window functions in SQL- 22245Murphy ≡ DeepGuide
Build Customer Journeys Using SQL
Learn to track consumers across multiple channels- 24628Murphy ≡ DeepGuide
These 5 SQL Techniques Cover ~80% of Real-Life Projects
Speed up your SQL learning curve.- 29630Murphy ≡ DeepGuide
Electric Cars In the Netherlands: Exploratory Data Analysis with Python and SQLAlchemy (Part 2)
Data analysis and visualization with Python, SQLAlchemy, and Bokeh- 21420Murphy ≡ DeepGuide
Junior Developers Write Multi-Page SQL Queries; Seniors Use Window Functions
An elegant way to perform computation within the context of a record- 24282Murphy ≡ DeepGuide
Python To SQL – I Can Now Load Data 20X Faster
The good, bad, and ugly ways of uploading large batches of data- 25992Murphy ≡ DeepGuide
Digital Marketing Analysis with Python and MySQL
A digital marketing analytics exercise with explained step-by-step code in both SQL and Python environments.- 27996Murphy ≡ DeepGuide
SQL on Pandas – My New Favorite for 10X Speed.
Bringing the best of both worlds together- 21762Murphy ≡ DeepGuide
SQL users: Halve the length of (some of) your queries with this one trick
In this article, I’m going to introduce you to the SQL QUALIFY clause: a trick that will help you write shorter and more readable SQL queries. If you work in Data Science/Analytics or Machine Learning, this is a must-have SQL tool for four reasons:- 20565Murphy ≡ DeepGuide
Understanding SQL: Order of Execution
A brief guide on how databases interpret your SQL queries- 26017Murphy ≡ DeepGuide
3 SQL Optimization Techniques That Can Instantly Boost Query Speed
Simple hacks to try before moving to a different data model altogether- 28392Murphy ≡ DeepGuide
Using DuckDB with Polars
Learn how to use SQL to query your Polars DataFrames- 23820Murphy ≡ DeepGuide
We look at an implementation of the HyperLogLog cardinality estimati
Using clustering algorithms such as K-means is one of the most popul
Level up Your Data Game by Mastering These 4 Skills
Learn how to create an object-oriented approach to compare and evalu
When I was a beginner using Kubernetes, my main concern was getting
Tutorial and theory on how to carry out forecasts with moving averag