SQL Resources

These notebooks introduce SQL as a tool to interrogate databases and acquire data for use with python libraries like numpy and pandas. They will cover everything from RDBMS terms and structure to subqueries that involve joining and filtering data from multiple tables.

• SELECT Statements Lesson

If you want to code or follow along with me during the SELECT Statements lesson, here is my code.

• WHERE Clause Lesson

If you want to code or follow along with me during the WHERE Clause lesson, here is my code.

• GROUP BY Clause Lesson

If you want to code or follow along with me during the GROUP BY Clause lesson, here is my code.

• CASE Statements Lesson

If you want to code or follow along with me during the CASE Statements lesson, here is my code.

• SQL Intro Review Notebook

This notebook starts out with an important overview of fundamentals and goes through using GROUP BY clauses.

• SQL Joins and Subqueries Review Notebook

This notebook starts out with an overview of table relationships and goes through explanation and examples of using the JOIN clause and subqueries.

• SQL Case and Temporary Tables Review Notebook

This notebooks dives into the CASE statement and working with temporary tables.