Practical SQL For Advanced Analytics

SQL is a programming language used for querying and managing data in databases and has become the backbone of modern analytics.

“SQL is the worst form of database querying, except for all the other forms.” — Lukas Eder

There are great resources some advanced topics in SQL like performance optimization.

Yet, there is no one go-to place for advance analytics using SQL. In this article, I collected resources (listed in the bottom) about advance patterns for analytics using SQL.

It's important to note that, many databases lack some of the capabilities and thus you will gain the most by understanding the way of thoughts.