3 Simple Rules for Writing Better SQL Code

3 Simple Rules for Writing Better SQL Code

Here are some general rules that I try to follow when coding in a SQL environment. There will always be exceptions, but you might want to keep these in mind when you're developing your own SQL scripts.

Click on my post below to read more...


To view or add a comment, sign in

More articles by Patrick Ryan

  • Embracing Large Language Models in the Enterprise: Challenges and Opportunities in a Vendor-Driven Landscape

    As organizations move forward in the era of AI, large language models developed by external partners like OpenAI and…

    2 Comments
  • SQL Style for Data Scientists - Query Syntax

    Here are some general rules that I try to follow when writing queries in a SQL database. There will always be…

    3 Comments
  • SQL Style for Data Scientists

    Naming Objects in a SQL Environment Here are some general rules that I try to follow when naming objects in a SQL…

    1 Comment
  • SQL Style for Data Scientists

    Opinions on SQL style are freely available, but they often vary, and I sometimes find it hard to keep them straight…

  • Multiprocessing in Python

    Python has a number of tools to help you get started with parallel processing. One of the simplest to use is the…

  • Big Data, Little Laptop (Part 1)

    Distributed computing is a powerful thing, but the use of traditional computing systems to store, process, and analyze…

  • Connecting to a SQL Database with Python

    SQL is everywhere, and if you are doing any sort of analysis in an enterprise setting, it is more likely than not that…

    4 Comments

Explore content categories