paint-brush
A Better Way to Write SQL queries for Developersby@javinpaul
15,815 reads
15,815 reads

A Better Way to Write SQL queries for Developers

by Javin Paul4mJuly 31st, 2019
Read on Terminal Reader
Read this story w/o Javascript
tldt arrow

Too Long; Didn't Read

The way you structure your query, the way you write it goes a long way to communicate your intent to the fellow developer. In this article, I am going to show you a couple of styles which I have tried in past, their pros and cons and what I think is the best way to write SQL queries. The right way to use these styles makes it more readable and easier to spot the key details of your query. The mixed case was introduced to separate keyword from column and table names e.g. writing SELECT in a capital case and writing Employee in as it is, there is no benefit of using that style.

Companies Mentioned

Mention Thumbnail
Mention Thumbnail
featured image - A Better Way to Write SQL queries for Developers
Javin Paul HackerNoon profile picture
Javin Paul

Javin Paul

@javinpaul

I am Java programmer, blogger on http://javarevisited.blogspot.com and http://java67.com

About @javinpaul
LEARN MORE ABOUT @JAVINPAUL'S
EXPERTISE AND PLACE ON THE INTERNET.
L O A D I N G
. . . comments & more!

About Author

Javin Paul HackerNoon profile picture
Javin Paul@javinpaul
I am Java programmer, blogger on http://javarevisited.blogspot.com and http://java67.com

TOPICS

THIS ARTICLE WAS FEATURED IN...

Permanent on Arweave
Read on Terminal Reader
Read this story in a terminal
 Terminal
Read this story w/o Javascript
Read this story w/o Javascript
 Lite