Syntax Conventions

Last modified: June 30, 2020

Contribute to Data School

We are actively working on this chapter. We are looking for two types of contributions:

  1. Help writing this chapter
  2. Share your story about working through this problem at work

Please reach out to @Matt David on our slack to discuss what you want to contribute.

Data School wants to provide common syntax conventions to help people write more clear SQL.

1) All caps Commands

Show example queries with ALL CAPS, First Letter Caps, and lowercase SQL commands.

2) New line per column

Show queries with SELECT statements that have their columns laid out next to each other horizontally and vertically. Explain when you would break the rule

3) Indenting

Show an unindented and indented version of SQL commands in a simple and complex query

4) GROUP BY numbers and names

Show queries that use numbers or column names explain the advantages/disadvantages of both.

Written by:
Reviewed by:

Next – Third Normal Form

Get new data chapters sent right to your Inbox