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.
Greetings, I am Scott Peters, a resident of Austin, TX. 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.