10 SQL Best Practices
<p>Writing clear, logical, easy-to-read, and high-performance ETL pipelines in SQL is an important part of a data scientist’s day-to-day job. Recently, after reviewing multiple SQL style guides (see references), I reflected on my practices and identified the following 10 SQL best practices, more accurately, common mistakes I’ve made. I hope this can be helpful to you.</p>
<p>The benefits of following these SQL style best practices include:</p>
<ul>
<li>Improved code readability</li>
<li>Reduced ambiguity</li>
<li>Enhanced debugging efficiency</li>
<li>Optimized code performance.</li>
</ul>
<ol>
<li><strong>Keywords and function names should all be lowercase.</strong></li>
</ol>
<p>Lower case are much easier for human to read</p>
<p><a href="https://medium.com/@Stan_DS/10-sql-best-practices-7ef8adbfd446"><strong>Website</strong></a></p>