This repository contains a collection of my SQL puzzles, tips and tricks, demos, and various writings. Feel free to rummage around, and I am constantly updating this repository, so check back often.
⌨️ All SQL is written in Microsoft SQL Server T-SQL, unless otherwise noted.
⭐ Please consider giving a star to this repository if you find its contents informative!
❓ If you have any questions, please feel free to create a GitHub discussion. I am always happy to help out and explain different solutions.
To get started, clone or download the repository to your local machine. I have included readme files for each directory that describes its contents. If anything is unclear, please contact me and I would be happy to assist.
The contents of this GitHub continue to expand, so check back often. Below are some of the most popular directories:
- Advanced SQL Puzzles: A growing collection of my SQL puzzles. I'm always looking for new puzzles, so please share if you have anything that would be a great fit.
- Recursion Examples: My collection of SQL queries that use recursion. Here I solve all sorts of problems such as Markov chains, floor and ceiling caps, Traveling Salesman, and even one for Sudoku.
- Advanced SQL Joins: Ever wanted to know all about semi-joins, anti-joins, equi-joins, theta-joins, self-joins, and all the ways you will encounter the word "join" in your daily SQL activities, then this is the directory for you!
- Behavior of Nulls: NULL markers are the bane of every developer, so I compiled a list of all the different SQL constructs and how they handle NULL markers.
- Databricks Hive Demo: Setting up Databricks to connect to an Azure Data Lake and SQL Server is no easy task, so I created an end-to-end demo showing how to set everything up.
Hi, I'm Scott Peters, an experienced SQL developer based in Austin, Texas. With over two decades of experience in the field, I've honed my skills in designing, developing, and maintaining complex databases, with a focus on the financial industry.
My strengths lie in my ability to think in a set-based manner, grasp the relational model, and tackle complex data puzzles. I'm also skilled in technical writing, which has allowed me to effectively document my work.
I am always eager to collaborate with fellow SQL developers. If you would like to connect, feel free to drop me a line!
📫 If you find any inaccuracies, misspellings, bugs, dead links, etc. please report an issue! No detail is too small, and I appreciate all the help.
😄 Happy coding!
I hope you find this repository to be useful and informative and I welcome any new puzzles or tips and tricks you may have. I also have a Wordpress site where you can find my data analytics projects, Python puzzles, and blog.