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.

1. A data/ directory that houses a csv of comet data used to create a SQL table
2. A sql_files/ directory that houses the SQL statements to create and query tables
3. 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.