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