How I Reduced My Query’s Run Time From 30 Min. To 30 Sec. In 1 Hour
The query optimization steps a senior data engineer took to reduce the process time of a query processing 1 billion+ rows.
Latest
3 Python Web Scraping Projects You Can Do In 1 Weekend
Beginner-Friendly Python Web Scraping Projects.
The Ultimate Guide To GCP Observability
LQL, Python and Audit Strategies For Diagnosis & Triage. Part 1: Logging Query Language LQL can be used in the Logs Explorer to fetch real-time data on Google Cloud products like Cloud Functions and Virtual Machines as well as non-GCP resources like resources connected to Amazon Web Services’
A 5-Step Prompt To Land More Data Job Interviews
1 multistep job search prompt to objectively evaluate your candidacy before you even think about hitting “apply.”
Module 7: Cost & Performance Optimization
Module 6: Resilient Engineering
Module 5: Orchestration
Module 4: The Cloud Stack
Module 3: Automation
Module 2: Advanced SQL & Schema Design
Module 1: The Architect Mindset
Module 8
Prettify Your Python Logs with Loguru
How an easy-to-use logger can format your log data output.
cURLing: Converting cURL to Python with CurlConverter
Easily translate your pesky API’s cURL commands to Python.
6 Things SQL Newbies Need to Realize Before Writing A Single Query
Breaking down the context behind your SQL queries.
Create Your SQL Table Right the First Time Using These 6 Tips
Review this SQL professional’s check-list before running ‘CREATE TABLE.’
A No-Fear Introduction to Working with SQL Nested & Repeated Fields
Making SQL nested and repeated data types more understandable — and less intimidating.
3 Data Science Projects That Got Me 12 Interviews. And 1 That Got Me in Trouble.
3 work samples that got my foot in the door, and 1 that almost got me tossed out.
5 Portfolio-Worthy SQL Project Ideas for Beginners
Ideas to help you create projects that will wow future employers.
Automate Your BigQuery Schema Definitions With 5 Lines of Python
Tired of manually writing my BigQuery schemas, I wrote a function that makes schema definition less time-consuming.
5 Ways to Use Python to Boost Your SQL Operations
Overcome SQL’s limitations with these Python methods.
Backfill Your SQL Tables Without Breakage Before Anyone Finds Out You Were Wrong
Re-loading missing data will be one of the least glamorous but most important tasks you do as a SQL developer. Get it right.
Scrape, Clean and Store Zillow Apartment Data (ETL Pipeline)
Use Python to find an apartment on Zillow.
Scrape, Clean and Store Zillow Apartment Data — Part II
Store data scraped from Zillow in a BigQuery table and view.