This is a collection of SQL code I have used in projects that really stood out to me. I wanted to showcase my level of understanding with SQL and how I approached different situations. Please have a look and feel free to let me know if you have suggestions or were curious as to my thought process!
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.