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.

How to Use Python & SQL to Append New Rows to a BigQuery Table Without Overwriting Your Data

How to dynamically update rows in BigQuery using python and SQL without losing your historical data.

Cron-ological Order: How to Write Cron for Scheduling Pipelines

How to write cron expressions and why data engineers need to know them.

DeDuplicating: SQL vs. Python

Both SQL and Python offer powerful functions to help data engineers clean data and eliminate dreaded ‘dupes’ in datasets.