The Query (aka Kyle and Cody) here 👋 

Here’s what we have for you today:

• More jobs and contract work for your to apply to.

• A sweet resource on breaking into data!

• Working with data types in SQL.

• A weekend meme hehe 🙂 

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, entry-level data jobs

Because who likes writing SQL from a busy office?

1. Data Analyst @ The Data School — $60k per year (apply here)

2. Business Analyst @ Apex Systems — $30-35 per hour, 1 year contract (apply here)

3. Business Analyst @ Society for Neauroscience — $60-66k per year (apply here)

freelance gigs

Need work experience? Get real experience with real projects.

1. Online Data Analyst — $30-70 per hour (apply here)

2. Extract Contact From Excel — $100 fixed (apply here)

3. Power BI — $40-75 per hour (apply here)

def creator_content_spotlight(🔦):

Cody here 👋 — our creator of the week this week is Annie Nelson, someone who is self-taught and now works at GitLabs as a Data Analyst!

Annie has a markdown file on GitHub where she writes about breaking into tech as a data professional and provides resources for doing so.

Check it out here.

The advice is great and it’s from someone who walks the walk — going from no experience in data to landing a job.

class SQLMiniLesson:

Changing Data Types in SQL

Kyle here 👋 — When working with data in SQL you may need to convert one data type to another.

For example, you might have a number you want to work with, but it’s stored as a text string in your database.

That means you can’t use any functions meant for numbers on it (like ROUND, SUM, etc.) until you convert the data type to something numeric.

One useful function for this purpose is the CAST function.

In this tip, we'll introduce you to the CAST function and explain how it can be helpful in your SQL queries.

The basic syntax for the CAST function is:

CAST(expression AS data_type)

It’s simple. Here’s an example of how to use it.

Example

Suppose we have a table called sales with the following columns: sale_id, item_id, price, and discount. The price column has a data type of FLOAT64, while the discount column has a data type of STRING.

If you want to calculate the discounted price, you will first need to convert the discount column to a numeric data type.

Assuming the sales table has the following data (shown below).

The CAST function allows you to easily convert the discount column to a numeric data type, so you can perform calculations with the price column.

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!

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