Good morning data cruncher!

The Query here 👋

Here’s what we have for you today:

• A dataset that could save your life 📊

• Explaining SQL command types 👨‍💻

• Data job openings 💼

• Memes! (as usual) 🤣

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, data jobs

Looking for a new job?

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

Check out this week’s featured jobs.

1. Senior Data Analyst @ Renew Home — $126-175k per year

2. Data Analyst @ Prosci — $80k per year

3. Analytics Engineer @ Seeq — $140k per year

freelance gigs

Need work experience? Get real experience with real projects.

1. Data Analysis in Excel — $150 fixed (apply here)

2. Customer LTV Analysis — $50-83 per hour (apply here)

3. Tableau Help — $45 fixed (apply here)

dataset_of_the_week(🔢):

It’s great when we can use data to solve real problems.

This week's dataset features the 2015 Behavioral Risk Factor Surveillance System (BRFSS) survey data, which offers a treasure trove of information for understanding and predicting diabetes risk.

It’s called the Diabetes Health Indicators Dataset.

With responses from over 440,000 Americans, this dataset captures various health-related behaviors, chronic health conditions, and preventative service usage.

The data is particularly cool because it allows for the exploration of key research questions, such as identifying the most predictive risk factors for diabetes and developing accurate predictive models based on survey responses.

Download and enjoy!

class SQLMiniLesson:

SQL Command Types: DDL, DML, and DQL

As data analysts we’re used to writing SQL queries to pull data.

But is there is more to SQL than that.

SQL statements are categorized into different types based on their purpose and functionality.

In this lesson, we'll discuss the three main types of SQL statements: DDL, DML, and DQL.

1. DDL (Data Definition Language)

DDL statements are used to define and manage the structure of a database and its objects (such as tables, views, and indexes). The main DDL statements include:

CREATE: Creates a new database object (e.g., table, index, or view).

ALTER: Modifies an existing database object.

DROP: Deletes a database object.

TRUNCATE: Removes all data from a table without deleting the table itself.

2. DML (Data Manipulation Language)

DML statements are used to manage and manipulate the data stored within database objects. The main DML statements include:

INSERT: Inserts new records into a table.

UPDATE: Modifies existing records in a table.

DELETE: Deletes records from a table.

MERGE: Inserts or updates records based on a specified condition (supported in some SQL dialects).

3. DQL (Data Query Language)

DQL statements are what you’re probably used to.

They’re used to query and retrieve data from database objects.

The main DQL statement is the SELECT statement, which allows you to retrieve data from one or more tables, apply filters, and aggregate or sort the results.

DDL Example:

DML Example:

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: I regularly post data content on LinkedIn.

That’s it for today.

Stay crunchin’ folks and see you next week!

— Kyle

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