SQL

On SQL

Modern Data Practice and the SQL Tradition | Florents Tselai

Learning resources

Select Star SQL “… is an interactive book which aims to be the best place on the internet for learning SQL. It is free of charge, free of ads and doesn’t require registration or downloads. It helps you learn by running queries against a real-world dataset to complete projects of consequence. It is not a mere reference page — it conveys a mental model for writing SQL”. Very nicely laid out (credits M. Buttrick of “Practical Typography”).

SQLBolt - Learn SQL - Introduction to SQL … a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser. Related website - regexone

Advanced SQL window functions quiz

SQL style guide by Simon Holywell

How Does a Database Work? | Let’s Build a Simple Database

SQL visualization/query/notebook tools

Redash – can be self hosted.

Franchise: a sql notebook – runs local proxy on your system. the UI itself is on franchise.cloud website. Can also run locally.

apache/incubator-superset: Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application

The Log File Navigator

Editors / IDEs

Command line tools