This is a collection of SQL projects I have completed - utilizing MySQL and PostgreSQL. While these are not all the projects I have done, I decided to start keeping a record of them in a central location and believe GitHub to be ideal for that.
It feels odd to say, but I really love SQL. During breaks, I like to solve SQL problems. I especially love learning a new function and throwing myself at it, trying to understand all aspects and use cases for it. I can honestly say my day is all the more exciting when I can reverse engineer SQL queries and walk away really understanding how it works and why it worked.
Some of my favorite sites when I want to tackle SQL challenges:
- PG Exercises: Great site for PostgreSQL exercises.
- SQL Murder Mystery: Solve a murder mystery... using SQL!
- HackerRank: Practice SQL and other languages, and compete with others.
- AnalystBuilder: Site built by Alex the Analyst with great interview question prep.
- StrataScratch: Excellent site to practice SQL interview questions.
-
Joins: Use of various JOIN types to connect tables and transform data as needed.
-
Logical Thought Process: Comments showing my thoughts on the actions performed and why they were used.
-
Sub-Queries: Showcases the use of subqueries to create temporary datasets for complex analysis, filtering, and data manipulation tasks.
-
Common Table Expressions (CTE): Illustrates my skill in using CTEs to simplify complex queries, improve code readability, and create temporary result sets.
-
Window Functions: Utilizing these tools to RANK, compare, and partition data to manipulate the data sets into tools for more insight.