SQL Learning Materials

Success

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.

Acknowledgements

The data used in this project is from a couple of sources.

The SQL Server instance has the ubiquitous AdventureWorks databases (the transactional one and the analytical one), which are 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 has 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.

Contents

This project has a few different series:

• From Excel to SQL, which is aimed at Excel users who want to learn SQL
• Everything about joins, which is a comprehensive guide to SQL joins
• Challenging SQL questions, which are SQL questions that really test your skills