Sponsored by

Hello fellow data cruncher!

The Query here 👋

Here’s what we have for you today:

• An update on the future of The Query 🔮

• A SQL function I used yesterday 👨‍💻

• Freshly updated data jobs 💼

• Some humor to brighten your day 🤣

Looking to become a Data Analyst? START HERE.

the future of The Query 🔮

Hey everyone! This is Kyle.

I’m sure many of you saw Cody’s Linkedin post yesterday — long story short, Cody has decided to dedicate himself full-time to his new health & wellness startup called Welpr.

It’s an exciting move, and we all wish Cody nothing but success in his new journey.

The good news is The Query isn’t going anywhere!

It’s here to stay and I want to make it better than ever.

Here’s what you can look forward to:

• YouTube videos: I'm planning to roll out content that complements our newsletter, offering deeper explanations and more engaging content.

• An Upcoming SQL Course: Most SQL courses I’ve seen are pretty good but not great. My goal is to make the best SQL course ever created for data analysts.

• A Revitalized Newsletter: Expect the same quality you know and love, with continuous enhancements to keep the content fresh and relevant.

• Improvements to the Job Board: New data jobs uploaded every day automatically with super accurate filters on salary and tech tools used.

• Recruiting/Career Help: This is still in a very early phase, but I would love to help people land their next data job. Please let me know if this is something you’d be interested in!

All this won’t happen overnight, but you can be sure I’ll be working hard on it and will keep you all updated!

That being said, I need your help! 🙏

I would love any feedback or ideas you have for the SQL course, Youtube videos, improvements to the job board or newsletter, or anything at all you want to share.

Let me know what you think here!

Thank you all for your continued support.

Here's to new beginnings and the continued success of The Query!

— Kyle

select * from data-jobs

remote, data jobs

Open to exploring new job opportunities?

We cultivate the best data analyst jobs from around the internet to make your search easier.

Check out this week’s featured jobs here.

1. Senior Data Analyst @ Rokt — $148-170k per year

2. BI Team Lead @ OCT Consulting — $190-220k per year

3. Data Analyst @ Tickpick — $105-120k per year

freelance gigs

Need work experience? Get real experience with real projects.

1. Looker studio help — $10-50 per hour (apply here)

2. Data analyst needed — $50-75 per hour (apply here)

3. Integrate and Analyst Data — $2,067 fixed price (apply here)

def content_spotlight(🔦):

Following data visualization best practices is so important.

Can you spot the data viz violations in the image below?

To improve you data visualization skills, here are a couple resources I recommend checking out:

Fundamentals of Creating Impressive BI Dashboard Designs

Tips for Designing a Great Dashboard

class SQLMiniLesson:

A Helpful Data Cleaning Function

Kyle here 👋 — Extra spaces before and after words in SQL columns can drive analysts crazy.

This can happen for a lot of reasons — a common one is when a user accidentally types a space before or after their email in an online form or survey.

There are often processes in place to ensure this doesn't happen, but that's not always the case.

I can't tell you how many times I've tried for hours to figure out what's wrong with my SQL query only to realize that one of the fields has a sneaky space in front of it!

To combat this you can use the TRIM function in SQL.

The TRIM function is a string manipulation function that removes leading and trailing spaces from a given string.

It’s easy to use.

Let's consider an example where we have a table named “users” with user information that includes first names and email addresses with extra spaces.

We want to remove the extra spaces from the first_name and email columns.

We can use the TRIM() function in a query to achieve this:

Trimming the extra spaces allows us to do things like JOIN on those columns or use them in the WHERE clause appropriately.

By using the TRIM() function, you can ensure that your queries, joins, and comparisons work correctly and avoid issues caused by extra spaces in user-submitted data.

This will make your life as an analyst a lot less stressful!

import memes as 😂 

content & resources 🤓 

1. Youtube Channel: Click here for Videos on SQL and data analytics.

2. Become a Data Analyst Guide: Our full guide on what it takes to land a job as a data analyst.

3. Open Data Analyst Jobs: Find your next data job here!

4. Download our SQL Cheatsheet as a PDF and desktop wallpaper here.

5. LinkedIn: We create content on LinkedIn daily. You can follow Cody here and Kyle here.

That’s it for today.

Stay crunchin’ folks and see you next week!

— Kyle

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -