SQL Union & Union All| SQL for Absolute Beginners| SQL for Data Analysis and Data Science

In this video we shall be going through data analytics use cases for SQL UNION and UNION ALL (Jump to minute 10:00 if you're only interested in the syntax of UNION and UNION ALL) Client List data - https://docs.google.com/spreadsheets/d/11Hc56MfroYSWD3cRB8rO6m7_F80X08ndi26V3rrZtNs/edit#gid=0 Purchase records data - https://docs.google.com/spreadsheets/d/1LHKPP9oW1oZnviwgPwwOYwiqtt199UCL4_k2wy__Xqg/edit#gid=0 Debits data - https://docs.google.com/spreadsheets/d/1zvnnnydpBXuYuzm6is6NcOQ-FlvGNH9iNR2kW_stJ98/edit#gid=0 How to import an Excel File(CSV) on to MySQL - https://www.youtube.com/watch?v=UOqKx8RGwDU&list=PLq4C_O0UP63JUsPshexBNee9FCYrqjqoj How to load a CSV onto MySQL - https://www.youtube.com/watch?v=UOqKx8RGwDU&t=10s (The video above contains a link to a tutorial that will show you how to download and set up MySQL)