6 Practical SQL Style Guidelines | Google BigQuery | Tips and Tricks

Data Science is not about writing SQL. It is about answering questions and converting data into actionable insights. However, almost any data-related job, like Data Scientist, Data Engineer, Data Analyst, requires at least some minimum knowledge of SQL. As I work with many different teams with varying levels of SQL proficiency, I noticed that not everyone is following the best practices. Some of this can lead to issues in production code, and others may breach the privacy of company data. But ultimately, learning how to write clean SQL code will pay off dividends in the long run as it makes routine work easier. As a Senior Data Scientist, I have seen firsthand how critical it is to follow best practices in SQL. Poorly written SQL can lead to production issues and compromise data privacy. In this video, I will guide you through practical tips to help you write cleaner SQL code that enhances your workflow and boosts efficiency. Also, these guidelines will help you to align your SQL skills with industry standards using tools like Google Cloud BigQuery and save some money along the way. Additionally, when doing any SQL coding interviews, I am 100% sure that these tips will come in handy to show your level of preparation and knowledge. ======================================== Here is a timeline for Your convenience: 00:00 Intro 00:44 Guideline 1 - SELECT Statement 03:34 Guideline 2 - Naming Conventions 05:35 Guideline 3 - Use SQL Commas Like a Pro 09:20 Guideline 4 - River Alignment 12:07 Bonus Tip - Bad Practice 13:50 Guidelines 5 & 6 - Line Length & Naming 15:12 Afterword - Take It Easy Remember to like, share, and subscribe for more data science insights. I would love to hear your thoughts and experiences, so feel free to comment below, even if you have a different opinion or would like to learn something in particular! I will be happy to hear from you. ======================================== What to watch next: A SQL playlist: https://www.youtube.com/watch?v=oxuSWu_pajg&list=PLzLxFW6Y1L-X53fq9v-RrOT6gIx3xq__S&ab_channel=RuslanBrilenkov PostgreSQL Stored Procedures https://youtu.be/7AsbMoJLA8I?si=lBpOUOfX10MqucXH SQL Procedures Automation https://youtu.be/Tsv6QKMtx68?si=Brc0zH_7fGeiGMny ======================================== Ways to connect: Subscribe! https://bit.ly/RBrilenkovYT LinkedIn https://www.linkedin.com/in/ruslan-brilenkov/ Medium https://ruslan-brilenkov.medium.com/ ======================================== If you are interested in generating royalty-free background music with AI software, check out the Mix.audio tool. It can potentially save you a lot of time. Use the promo link below to get a 30% discount on your first monthly subscription payment, and by doing so, you will also support the channel at no extra cost to you: https://bit.ly/ruslanpromoAI ======================================== Disclaimer: everything presented in this video is my own opinion and is meant to educate and share information, nothing mentioned or described here is legal or financial advice. Ruslan Brilenkov is not responsible for any profits or losses associated with your investment. So, please be responsible for your own actions.