The Query (aka Kyle and Cody) here 👋

Here’s what we have for you today:

• A free tutorial that will help you stand out from the crowd 🤝

• 3 interesting data analyst jobs 📊 

• Freelance gigs to get work experience 💼

• A must-know SQL data type 👨‍💻

• A meme any analyst can relate to 🤣

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, data jobs

Because who likes writing SQL from a busy office?

1. Data Analyst, Strategy @ Ticketmaster — $70-90k per year (apply here)

2. Data Analyst II @ CoventBridge — $60-75k per year (apply here)

3. Data Analyst @ Wurl — $121-167k per year (apply here)

freelance gigs

Need work experience? Get real experience with real projects.

1. Data Pro Needed for Insights — $40-78 per hour (apply here)

2. Excel/SQL Analysis — $17-50 per hour (apply here)

3. PowerBI Merge Datasets — $entry level (apply here)

def content_spotlight(🔦):

This week we’re featuring a free course to get you started with dbt.

The popularity of dbt has exploded over the past few years. I am seeing it mentioned in A LOT of job applications.

Even if you don’t master dbt, just being able to say you have experience with it and can explain what it is you will be ahead of the competition.

class MiniLesson:

The VARCHAR Data Type in SQL

Kyle here 👋 — In this lesson, you’re going to learn about the VARCHAR data type — one of the most common data types in relational databases.

You will undoubtedly come across this in your day to day work.

VARCHAR stands for "variable character."

This data type is commonly used to store textual data, such as names, addresses, and descriptions. The primary advantage of using VARCHAR is its flexibility, as it allows you to store strings of varying lengths without wasting storage space.

When you define a VARCHAR column, you need to specify the maximum length of the string that it can hold. This length is expressed as a number of characters.

For example, if you want to store email addresses with a maximum length of 255 characters, you would define the column as VARCHAR(255).

Don’t be surprised if you see VARCHAR(255) used as the length for all VARCHARs in your database. It is typically the standard length.

(You don’t need to know this, but 255 is so common because it’s the largest number of characters that can be counted with an 8-bit number. You can read more about it here.)

Why use VARCHAR?

Using VARCHAR has several advantages:

1. Storage efficiency: Since VARCHAR only allocates the storage space required for the actual length of the string, it can help save storage space compared to using fixed-length data types, such as CHAR.

2. Flexibility: VARCHAR allows you to store strings with varying lengths, making it suitable for a wide range of use cases.

3. Readability: When you retrieve data from a VARCHAR column, you don't need to trim trailing spaces, as you would with a fixed-length CHAR column.

One thing to keep in mind is different character sets.

Different databases support different character sets, which can affect the storage size of a VARCHAR column.

Be aware of the character set used by your database and ensure that your VARCHAR columns can accommodate the characters you expect to store.

One time I had an entire process break because of an emoji. 🤣

Understanding how to use and optimize VARCHAR columns can help you create more efficient database designs and improve the performance of your queries.

import memes as 😂 

content & resources 🤓 

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

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

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

4. Courses: Our course on showcasing your data portfolio is live!

That’s it for today.

Stay crunchin’ folks and see you next week!

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