Well Data-Birds, March is about to leave us and so it is time to introduce the Data-Bird of the month!

With March being Women’s History month, we thought we would take a look at some of the women who blazed this trail before us. These will not be the regular…


Temp Tables, CTEs, and Subqueries

In my last post, I walked you through some simple window functions. You can read that here. The final query in SQL:

WITH CTE as (SELECT date, state, county,
cases — LAG (cases,1) OVER(PARTITION BY
fips ORDER BY date)as ‘new_cases’,
cases as ‘cumulative_cases’FROM counties)
SELECT…


Window Function Fun!

This is the sixth post in a series on SQL.

My fifth post on SQL was more on joins and query structure. You can read that here.

To recap, in the last post, we discussed INNER and LEFT joins and how to go about building a query…


Joins and building a query.

My fourth post on SQL was an introduction to subqueries. You can read that here.

To recap, in the last post, I walked you through building a simple subquery that functioned as a filter for our data.

Written in SQL:

SELECT state, county, cases, deaths…


Basic subquery and order of operations

This is the fourth post in a series on SQL.

My third post on SQL was an overview of basic aggregate functions. You can read that here.

To recap, in the last post, I walked you through building a simple query that aggregated data…


Basic Aggregate Functions

This is the third post in a series on SQL.

My second post on SQL was an overview of SELECT, FROM, WHERE, and JOIN. You can read that here.

To recap, in the last post, I walked you through building a simple query that selected columns from…


SELECT, FROM, JOIN, and WHERE statements

My first post on SQL was a very high-level overview of relational databases, queries, and what SQL is. You can read that here.

To recap, in the last post, I included an example where we asked the database to find the name ‘Mutt Barkely’…


Introduction to relational databases

This is the first post in a series on SQL.

According to an IADSS article* SQL is the second most common skill listed in data science job postings — only python is more common. This makes SQL a core skill for any data scientist, data analyst…

Amandaspotter

Chicago gal, obsessed with data.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store