The Querynomicon. An Introduction to SQL for Weary Data Scientists

Upon first encountering SQL after two decades of Fortran, C, Java, and Python, author thought he had stumbled into hell. He quickly realized that was optimistic: after all, hell has rules.

Author have since realized that SQL does too, and that they are no more confusing or contradictory than those of most other programming languages. They only appear so because it draws on a tradition unfamiliar to those of us raised with derivatives of C. To quote Terry Pratchett, it is not mad, just differently sane.

Welcome, then, to a world in which the strange will become familiar, and the familiar, strange. Welcome, thrice welcome, to SQL.

Table of contents:

1. Introduction
2. Core Features
3. Tools
4. Advanced Features
5. Python
6. R
7. PostgreSQL
8. Conclusion

Link: Tutorial

Navigational hashtags: #armknowledgesharing #armtutorials
General hashtags: #sql

@data_science_weekly