[Concept Class] SQL Queries You Can Learn and Use Immediately
You will be able to extract the data you want directly without the help of a developer. We will comfortably cover everything needed for analysis, from simple queries to joins. Start learning SQL with a lecture directly from the author of the book <SQL for Product Managers>.
Q. What is the most readable SQL query? : Introduction to SQL Style Guide
Q. Which SQL query is the most readable?
- This is a question I get asked often.
- But there is no right answer. This is because everyone has a different style of writing code.
- There is no set format, but each team or company can create and use its own rules.
- These are usually called code conventions, style guides, etc., and can be applied to SQL as well.
- For example, languages like Python have their code conventions internalized into the language's operational syntax.
- No one is the best, but there are definitely some SQL code conventions that are more commonly read.
- Below are links to the code conventions (most of which are in English).
- I will update this later with a lecture :)
ย
Mozilla (Firefox) SQL Style Guide:
https://docs.telemetry.mozilla.org/concepts/sql_style.html
ย
Gitlab SQL Style Guide:
https://about.gitlab.com/handbook/business-technology/data-team/platform/sql-style-guide/
ย
Simon Holywell's SQL Style Guide:
ย
* This is a new post where we share answers to frequently asked questions about SQL.