SQL Tips for Better Analysis
Vložit
- čas přidán 5. 12. 2022
- In a previous video, I shared the Top 3 Common SQL Mistakes that will throw an error message
our Rubber Duck data science friends can easily help with errors, however...
⚠ These mistakes do not result in errors, they result in bad analysis!
🤔 Counting NULL Columns
🤔 Using BETWEEN Incorrectly
🤔 Ignoring the integrity of JOIN (provided by David Mullin)
Rubber Duck Debugging can still help in these situations, but it may take a bit more describing the end to end process and performing additional checks
What other SQL tips can you share?