How Much SQL Is Needed for Data Science? (10 Items) скачать в хорошем качестве

How Much SQL Is Needed for Data Science? (10 Items)

Subscribe to RichardOnData here:    / @richardondata   In this video, I discuss the items in SQL that you should know in order to be a successful data scientist. They are roughly ordered from least to most advanced. 1. Basics (select, select distinct, from, where, order by -- including the operators and wildcards associated with the "where" clause) 2. Group by and summary functions (count, avg, sum, etc.) 3. Joins (inner join, left join, outer join, cross join) 4. Subqueries, temp tables, and CTEs 5. Case when and exists 6. Self joins 7. Stored procedures and user-defined functions (UDFs) 8. Window functions (examples: lead, lag, row_number) 9. Pivot and unpivot 10. Indexes (clustered and non-clustered) A book I highly recommend - "The Guru's Guide to Transact SQL": https://amzn.to/2IgvGko Resources: W3Schools: https://www.w3schools.com/sql/default... SQL Server Tutorial: https://www.sqlservertutorial.net/ Essential SQL: https://www.essentialsql.com/introduc... GiantStride (difference between clustered and non-clustered indexes): https://www.giantstride.gr/sql-indexi.... "The Guru's Guide to Transact SQL": https://www.amazon.com/Gurus-Guide-Tr... LeetCode: https://leetcode.com/problemset/datab... Difference between stored procedures and UDFs: https://www.c-sharpcorner.com/article... PayPal: [email protected] Patreon:   / richardondata   BTC: 3LM5d1vibhp1F7pcxAFX8Ys1DM6XLUoNVL ETH: 0x3CfC599C4c1040963B644780a0E62d45999bE9D8 LTC: MH8yPjvSmKvpmRRmufofjRB9hnRAFHfx32