{"repo":"billwallis/sql-learning-materials","free":true,"listed":false,"github":"https://github.com/billwallis/sql-learning-materials","clone":"git clone https://github.com/billwallis/sql-learning-materials.git","description":"SQL scripts that demonstrate various features and concepts.","language":"Python","stars":14,"topics":["sql","duckdb","postgresql","sql-server","sqlite"],"license":"OSL-3.0","category":"databases-storage","readme_excerpt":"--- SQL Learning Materials SQL scripts that demonstrate various features and concepts. This project contains a bunch of SQL learning materials aimed at different levels of experience and covering a variety of topics. It focuses on just writing SELECT statements so there will be very few resources for anything else. Jump into https://billwallis.github.io/sql-learning-materials/ to see the summary of what's covered in this project, and continue below for instructions on how to set up the databases. Acknowledgements The data used in this project is from a couple of sources. The SQL Server instance will load the ubiquitous AdventureWorks databases (the transactional one and the analytical one), which is available from various Microsoft pages: - https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure - https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks The PostgreSQL instance will load the similarly ubiquitous Sakila database, which is available from the following GitHub repo: - https://github.com/jOOQ/sakila/ All credit for the data goes to the respective owners, and these sources should be consulted for any documentation you need around the data. The docs are built using MkDocs and the Material for MkDocs theme, with several plugins to make the experience more interactive. I cannot express the love I have for the maintainers of these tools! Pre-requisites This project uses uv to manage the Python dependencies and Docker to spi","default_branch":null,"files":null,"tree":[],"storefront":"/r/billwallis","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/billwallis/sql-learning-materials/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}