Summary
Keywords
Full Transcript
SQL!!! If you work as a data engineer, scientist or analyst, then learning SQL is going to change how you view and handle data. SQL stands for Structured Query Language. In this easy to understand tutorial, let me give you all the basics of SQL. Right from SELECT to WHERE clause to Multiple conditions (AND / OR / NOT) to ORDER and GROUP BY. WANT MORE? Watch my detailed SQL Video with more than 50 example queries, full sample dataset and practical tips. π https://youtu.be/l8DCPaHc5TQ β± IN THIS VIDEO π ================= 0:00 - What is SQL? 0:58 - SQL Select Examples 1:39 - WHERE clause 2:11 - OR operator 2:55 - AND operator 3:26 - IN operator (vs. OR operator) 4:31 - * vs. specific columns 5:03 - ORDER BY 6:24 - NOT operator 7:12 - GROUP BY 8:58 - Wait, there is more!!! LEARN MORE ππ» ================ π₯DETAILED SQL Video - https://youtu.be/l8DCPaHc5TQ Meanwhile, also check out below videos: Data Analysis with Excel (full course + examples) - https://youtu.be/v2oNWja7M2E Power Query (it is like SQL, but you can use it from Excel or Power BI) - https://youtu.be/PiFAa_jjaEI Database vs. Data Warehouse vs. Data lake - https://youtu.be/WgIbvkyY4mI Data Cleaning in Excel - 10 PRO tricks - https://youtu.be/SNVjndgWBlw 5 skills you need to be a GREAT data analyst - https://youtu.be/gVr9f1GJdZc π SAY HELLO π =============== Apart from YouTube, I frequently post on, my blog - https://chandoo.org/wp/ twitter - https://twitter.com/r1c1/ Instagram - https://www.instagram.com/chandoo.xlsx ~ The waiter: "What is your order sir?" The SQL developer: "Desc of course" π€£ #SQL #database
