The Querynomicon

An Introduction to SQL for Weary Data Scientists

cover art by Danielle Navarro

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

I 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.

  1. Introduction
  2. Core Features
  3. Tools
  4. Advanced Features
  5. Python
  6. PostgreSQL
  7. Conclusion
  1. License
  2. Code of Conduct
  3. Contributing
  4. Bibliography
  5. Glossary
  6. About the Authors
  7. Colophon

"The Querynomicon" is a Third Bit production. You may also enjoy Research Software Design by Example and The Sudonomicon.

Help Wanted

If you would like to help get this tutorial to a usable state, please see these issues or contact the maintainer.