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…
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…
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…