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.
Zach Quinn
5 Ways to Use Python to Boost Your SQL Operations
Overcome SQL’s limitations with these Python methods.
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 Portfolio-Worthy SQL Project Ideas for Beginners
Ideas to help you create projects that will wow future employers.
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.
A No-Fear Introduction to Working with SQL Nested & Repeated Fields
Making SQL nested and repeated data types more understandable — and less intimidating.
Create Your SQL Table Right the First Time Using These 6 Tips
Review this SQL professional’s check-list before running ‘CREATE TABLE.’
6 Things SQL Newbies Need to Realize Before Writing A Single Query
Breaking down the context behind your SQL queries.
cURLing: Converting cURL to Python with CurlConverter
Easily translate your pesky API’s cURL commands to Python.
Prettify Your Python Logs with Loguru
How an easy-to-use logger can format your log data output.
SQL Quality Assurance Queries
How to construct queries in SQL to confirm data accuracy.
How Many Hours Per Week Should Data Professionals Really Dedicate to Learning?
Here’s how much time you should dedicate to learning new skills both at work and off-the-clock, according to experts.