4 SQL Tips For Data Scientists And Data Analysts

SQL is becoming a common skill requirement across industries.

Companies like Amazon and Google often will require their data analysts, data scientists and product managers to at least be familiar with SQL. This is because SQL remains the language of data. So, in order to be data driven, people need to know how to access and analyze data.

With so many people looking at, slicing, manipulating and analyzing data with SQL we wanted to provide some tips to help improve your SQL.

These tips and tricks we have picked up along the way while writing SQL. Some of them are do’s and don’ts others are just best practices. Overall we hope that they will help bring your SQL to the next level.

Some of the tips will be things you shouldn’t do, even when you might be tempted and others are best practices that will help ensure that you can trust your data. Overall, they are both meant to be informative as well as reduce possible future headaches.

Here are 4 tips and tricks to help you improve your SQL game as a data scientist, engineer or analyst

• Use A Case Statement With A Sum() Function
• Don’t Use Avg() on an Average It’s Not the Same
• Learn How To Use The Lead() and Lag() Functions
• Learn How To Use Arrays And Maps

These are just 4 of a whole list of tips we want to share with you!

Let us know if you have any further questions and feel free to comment and reach out to our team.

You can find us at: https://www.theseattledataguy.com/ https://medium.com/@SeattleDataGuy https://twitter.com/SeattleDataGuy

Also read more about Postgres Arrays Here https://www.postgresql.org/docs/9.1/arrays.html

Thanks again! ... https://www.youtube.com/watch?v=kSt9NV-qZkc