HyperLogLog implemented using SQL
We look at an implementation of the HyperLogLog cardinality estimation algorithm written entirely in declarative SQL- 27643Murphy ≡ DeepGuide
Model Selection For dbt CLI
A complete cheatsheet for selecting specific models when running dbt commands- 23905Murphy ≡ DeepGuide
4 Useful BigQuery SQL Functions You May Not Know
And how to use them- 23861Murphy ≡ DeepGuide
How to Compare Two Tables For Equality in BigQuery
Compare tables and extract their differences with standard SQL- 26342Murphy ≡ 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- 26262Murphy ≡ DeepGuide
Learn dbt the Easy Way
An analytics engineer's guide to key db- 27800Murphy ≡ 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- 23408Murphy ≡ DeepGuide
Running SQL Queries in Jupyter Notebook using JupySQL, DuckDB, and MySQL
Learn how to run SQL in your Jupyter Notebooks- 22240Murphy ≡ DeepGuide
RANK() vs DENSE_RANK() vs ROW_NUMBER() in SQL
Understanding the difference between these window functions in SQL- 22235Murphy ≡ DeepGuide
Build Customer Journeys Using SQL
Learn to track consumers across multiple channels- 24618Murphy ≡ DeepGuide
These 5 SQL Techniques Cover ~80% of Real-Life Projects
Speed up your SQL learning curve.- 29617Murphy ≡ DeepGuide
Electric Cars In the Netherlands: Exploratory Data Analysis with Python and SQLAlchemy (Part 2)
Data analysis and visualization with Python, SQLAlchemy, and Bokeh- 21410Murphy ≡ DeepGuide
Junior Developers Write Multi-Page SQL Queries; Seniors Use Window Functions
An elegant way to perform computation within the context of a record- 24272Murphy ≡ DeepGuide
Python To SQL – I Can Now Load Data 20X Faster
The good, bad, and ugly ways of uploading large batches of data- 25981Murphy ≡ 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.- 27986Murphy ≡ DeepGuide
SQL on Pandas – My New Favorite for 10X Speed.
Bringing the best of both worlds together- 21752Murphy ≡ 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:- 20555Murphy ≡ DeepGuide
Understanding SQL: Order of Execution
A brief guide on how databases interpret your SQL queries- 26007Murphy ≡ DeepGuide
3 SQL Optimization Techniques That Can Instantly Boost Query Speed
Simple hacks to try before moving to a different data model altogether- 28382Murphy ≡ DeepGuide
Using DuckDB with Polars
Learn how to use SQL to query your Polars DataFrames- 23810Murphy ≡ 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