- The Query
- Posts
- 🤓 SQL skill check: Are you job-ready? (Real tech company SQL interview)
🤓 SQL skill check: Are you job-ready? (Real tech company SQL interview)
The Query
March 30, 2023
GM crunchers! This is The Query — the data newsletter that’s like an INDEX for your data career. We help optimize your performance and get you to your goals faster.
Here’s what we have for you today:
Test your SQL skills for job readiness
Learn to write BEAUTIFUL SQL queries with CTEs
Creating line charts in Python with Matplotlib
A new portfolio project dataset on movie ratings
A copious amount of comedy 😆
select * from content-spotlight
1. Are you scratching your head, thinking, "Am I really ready for that SQL job?" 🤔 Don't sweat it, my friend! Braintree's got your back. They've shared their very own SQL interview right on GitHub for ya. Give it a whirl, and if you ace it, you're totally set for that job!
2. Attention space fans and SQL enthusiasts! Ever heard of The Schemaverse Tutorial? It's this rad combo of space, strategy games, and, you guessed it, SQL practice. Picture this: you're in a battle of wits against other players, commanding your fleet with SQL moves. Sounds like a blast, right?
3. So, you've discovered CTEs, and now subqueries feel like old news, huh? Let me tell ya, Michal Konarski's guide on CTEs is a game-changer. He breaks down the messy readability probs CTEs fix, and explains everything super clearly, with tons of eye-catching visuals (perfect for you visual learners out there).
class LearningResources: 📊
Time to buckle down, sharpen your skills, and prepare to conquer data.
Tackling the world of analytics can be daunting. But don't fret!
You can become a data wizard faster than you think.
Discover our curated learning materials below:
three project-based learning resources
Alright, here's the lowdown on these projects, ranked from a walk in the park to "challenge accepted!"
The first couple of projects are like your personal GPS – guided tutorials to help you get the hang of cool tools (think Excel or Tableau).
But hey, you know what they say – spoon-fed tutorials won't impress the (future) boss folks.
That's why project number three is a whole different ball game. We're giving you a public dataset and a lil' nudge to kick off your analysis.
It's your time to shine and show 'em what you've got! 🌟
two technical tips
Technical time…
1. Python Tip 🐍: Visualizing Data with a Line Chart
The Python library Matplotlib is a total lifesaver for whipping up static, animated, and interactive visuals!
Ready to dive in?
Here’s some code that'll create a neat line chart to track sales revenue by year:
And here’s the output:
Can you convert it to a bar chart?
2. SQL Tip 👨💻: Checking for Duplicates in SQL
You'll be checking for duplicates in SQL like a gazillion times throughout your data journey. 🕵️♀️
Wanna know the easiest way? Here ya go:
Checking for dupes with a HAVING clause
If there are any duplicate values for “column_name” they’ll be returned along with the count of those values.
(Heads up: If the count is more than 1, you've got yourself a duplicate! 🎯)
Sure, there are other ways to sniff out duplicates, but hey, one solid trick in your toolbox is all you need
one tool 🔧
Meet BigQuery — our go-to data warehouse buddy we hang with every day.
Most startups and tech peeps are using one of these 3 data warehouses:
BigQuery
Snowflake
Redshift
When you’re leveling up your SQL skills, it’s best to practice with one of these.
Why do we dig BigQuery? Here are a couple of reasons:
You get $300 in free credits to use (no charge until you upgrade)
Fully integrates with Google Cloud Platform and other Google services like Google Sheets and Looker Studio
Give it a shot and let us know how it goes!
def data_jobs(👨💼👩💼):
remote, entry-level data jobs
Working remotely means you don’t need to worry about coworkers stealing your snacks from the office fridge 😉
Data Analyst, Marketing @ Muck Rack — $79-95k (apply here)
Data Analyst, Marketing @ him & hers — $67-85k (apply here)
Data Analyst @ Renaissance — $56-64k (apply here)
IG Junior Data Analyst @ Securitas USA — $65-75k (apply here)
Business Data Analyst @ Ask Media Group — $75-110k (apply here)
freelance data gigs
Freelancing is a GREAT way to get paid to improve your data analytics skill set.
Real Estate Data Analyst (apply here)
Google Sheets Dashboard Project (apply here)
Create a quality metric dashboard — $75 (apply here)
PowerBI Dashboard (apply here)
import entertainment as fun
meme of the week
It’s obviously pronounced data.
r/dataisbeautiful
Congratulations to u/faxhightower for paying off their student loan debt! 👊
Here’s their payment history visualized:
data tok
Rage quit 😡
That’s it for today. Stay crunchin’ folks and see you next week!
Sharing is caring: If you are getting value from The Query, forward it to a fellow data cruncher that might benefit from this content.
They can sign up using this link. 🤓
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
What'd you think of today's newsletter? |