# SQL

### Articles

* [10 Easy Steps to a Complete Understanding of SQL](https://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete-understanding-of-sql/) - Lukas Eder
* [Best practices for writing SQL queries](https://www.metabase.com/learn/building-analytics/sql-templates/sql-best-practices) - Metabase
* [Creating Histograms in SQL](https://popsql.com/sql-templates/analytics/how-to-create-histograms-in-sql) - PopSQL
* [Improve your SQL skills X2 in 5 minutes](https://zaidesanton.substack.com/p/the-most-underrated-skill-sql-for) - Anton Zaides
* [SQL Cheat Sheet](https://antonz.org/sql-cheatsheet/) - Anton Zhiyanov
* [SQL join flavors](https://antonz.org/sql-join/) - Anton Zhiyanov

### Books

* [Use The Index, Luke! - A Guide to Database Performance for Developers](https://use-the-index-luke.com/) - Markus Winand

### GitHub Repositories

* [SQL tips and tricks](https://github.com/ben-n93/SQL-tips-and-tricks)

### Images

<figure><img src="https://3287763006-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MNTfNUTqpRKTqOGTts0%2Fuploads%2F5qIa3lMhfLfjUeKgOaOH%2FSQL%20Query%20Logical%20Order.gif?alt=media&#x26;token=605682e5-f603-4661-89a3-b58aaecbaa20" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3287763006-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MNTfNUTqpRKTqOGTts0%2Fuploads%2FsOJM3C0xdcHsXuX84yfp%2FThe%204%20Types%20Of%20SQL%20Joins.jpg?alt=media&#x26;token=4071eca5-1c18-4fe7-a852-9a729177e75b" alt=""><figcaption></figcaption></figure>

### Playgrounds

* [SQL OnLine IDE](https://sqliteonline.com/)
* [SQL Playground](https://sql-playground.wizardzines.com/)

### Tools

* [Harlequin](https://harlequin.sh/) - the SQL IDE for your terminal

### Websites

* [Advent of SQL](https://adventofsql.com/)
* [Human to SQL Translator](https://www.sqltranslate.app/)
* [Lost at SQL](https://lost-at-sql.therobinlord.com/) - SQL learning game
* [Select Star SQL](https://selectstarsql.com/)
* [SQL for Devs](https://sqlfordevs.com/)
* [SQLBolt](https://sqlbolt.com/)
* [SQLZOO](https://sqlzoo.net/wiki/SQL_Tutorial)
* [The Querynomicon](https://gvwilson.github.io/sql-tutorial/) - An Introduction to SQL for Weary Data Scientists
