The Query (aka Kyle and Cody) here 👋 

Here’s what we have for you today:

• Remote data jobs 🔥 

• A repository of hundreds of EPIC public datasets 💯 

• Important SQL concepts you might not know as an analyst

• A knuckle-cracking meme 🤣

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. Artificial Intelligence Business Analyst @ Epic Charter School — $90k per year (apply here)

2. Data Analyst - Retail @ YipitData — $73-90k per year (apply here)

3. Client Insights Analyst @ Circana for Neauroscience — $47-80k per year (apply here)

freelance gigs

Need work experience? Get real experience with real projects.

1. Data Viz, Sales Data — $75-100 per hour (apply here)

2. Looker Studio — $75-100 per hour (apply here)

3. Tableau — $50-80 per hour (apply here)

def content_spotlight(🔦):

This week, we’re featuring Awesome Public Datasets on GitHub.

It’s a list of public datasets organized by category:

If you’re looking for a dataset for your next portfolio project, check it out!

class SQLMiniLesson:

DDL, DML, & DQL — What’s the Difference?

Kyle here 👋 — 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.

…

Here are some examples of DDL and DML statements.

You don’t need to be in expert at these to be a data analyst, but some familiarity with them can definitely be helpful!

DDL:

DML:

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!

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