In this episode of the SQL tutorial series, I'll show you a few basic SQL best practices that will make your life as a data professional much easier. ;-)
ARTICLE VERSION (RECOMMENDED): data36.com/sql-best-practices...
00:00 Intro
01:53 The order of your keywords
04:17 Indentations and new lines
08:08 Upper case vs lower case
10:26 Aliases (SQL AS)
15:51 Commenting
17:43 Always use the actual column name
20:31 Avoid SELECT *
22:10 Conclusion
PREVIOUS EPISODES:
- SQL TUTORIAL EP#1 video: • SQL TUTORIAL EP#1: BAS...
- The whole SQL tutorial series: • SQL for Data Science a...
LINKS MENTIONED IN THE EPISODE:
- SQL cheat sheet: data36.com/newsletter
- Learn SQL (10+ tutorial articles): data36.com/learn-sql-for-data...
- 7-day SQL online course: data36.com/sql-for-aspiring-d...
- SQL server setup video: • How to INSTALL Postgre...
- raw data: course.data36.com/sql_practic...
- Newsletter: data36.com/newsletter
- Free mini-course: data36.com/how-to-become-a-da...
- SQL style guide: www.sqlstyle.guide/
NEXT EPISODE:
EP#4, SQL JOIN: • SQL JOIN explained (SQ...
--------------------------------------------------------
Check my website: data36.com
Get access to more data science tutorials, join the inner circle: data36.com/inner-circle
Find me on Twitter: / data36_com
Негізгі бет Ғылым және технология SQL BEST PRACTICES: 7 tips for junior data scientists and analysts (SQL tutorial for beginners EP#3)
Пікірлер: 5