Welcome

Welcome to my SQL puzzle website. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.


Link to my GitHub repository below:

https://github.com/smpetersgithub/AdvancedSQLPuzzles


All solutions to the puzzles are written in Microsoft SQL Server’s T-SQL, but you can easily adapt the solutions to your flavor of SQL. I’m constantly adding new material, so scroll through to find all sorts of database tips, tricks, and insights.

I also welcome any corrections, new tricks and techniques, dead links, misspellings, bugs, and any new puzzles you think would be great for this blog.

Let’s get on to the puzzles….


Advanced SQL Puzzles

Here is a collection of the most difficult set-based SQL puzzles that I could write, nicely condensed into a PDF file. This is a great starting point to determine your level of expertise with SQL. I highly recommend developers of all skill levels work through this puzzle set; you may be surprised!

Link to my GitHub repository below.

Advanced SQL Puzzles

In my GitHub I also have a collection of my writings on various database topics and a bunch of my scripts that are helpful tips and tricks that I’ve coded along the way. Feel free to rummage around and grab anything you can use.


Python Puzzles

I also started a WordPress page of my Python puzzles. These are probability puzzles where you perform hacker statistics using the law of large numbers.

Python Puzzles


Data Analytics

Here is where I keep the various data analytic projects that I have done. This mostly includes descriptive and inferential statistical projects I’ve created, plus some machine learning models that I have built.

Data Analytics


Blog

I also keep a small blog here. Right now, it’s pretty sparse, but I have been slowly getting more and more content posted.

Blog


Happy coding!!