This repository houses code for a series of blog posts (on Medium) about exploring SQL. This README.md file will serve as a roadmap to this repository. The repository is open and available to the public.
- A data/ directory that houses a csv of comet data used to create a SQL table
- A sql_files/ directory that houses the SQL statements to create and query tables
- A notebooks/ directory that houses Jupyter Notebooks (Note: these files are very unpolished and will be updated in a final stage of this project.)
You can read about exploring SQL in these blog posts:
- Black holes, planets, and SQL -- The first tutorial that introduces SQL and covers SELECT, WHERE, and LIMIT.
- Touring the Solar System with SQL -- Which covers common aggregate functions and subqueries.
- Searching for Moons with SQL -- Here, I cover more complex queries with aggregate functions.
- Classifying black holes with SQL -- A tutorial with a CASE function.
- Joining Constellations with SQL -- Where I introduce the idea of joining two tables.
- Solar System classifications with SQL -- Here, I cover the array aggregate function, OFFSET, and the topic of Table View vs Expanded Displays.
- Many (to many) relations among the stars -- A tutorial that covers relationships in a database.
- Creating tables in SQL -- Which covers two methods of creating tables.
- Editing tables with Postgres -- Covering editing and altering tables.
- A window to the solar system -- Covering window functions.
- LAG functionality on SQL Data and Finding seasonality in sales data - Tutorials that use the LAG and LEAD functionality.
- Observing the cosmos with SQL - In which I solve a really difficult problem.
- Query tuning with the cosmos - A post that introduces query tuning.