Learning data can be fun if you are doing it while your not under pressure to perform. It’s key to remember that data is just data. If you can handle one set; you can handle any set. One of my most rewarding job functions is working as a data analyst and providing my teams with data that they have never seen tied together.
Data systems that are NOT written together; DO NOT naturally talk.
I can remember learning about joins and being totally confused. I understood that I needed to relate the tables, but I didn’t fully understand that to achieve certain reports; I had to know joins and join types. This video is a simple concept video that will hopefully get you started ahead of the curve with joins and join types.
Get started with understanding Join Types and then you can pursue more information on the inner working of Joins with the different types of tools you may use for the data you work with.
Here is so more light reading for you if you are using Access Databases or SQL Databases.
For SQL related JOINS – https://msdn.microsoft.com/en-us/library/zt8wzxy4.aspx
For Microsoft Access Joins – https://support.office.com/en-us/article/Join-tables-and-queries-3f5838bd-24a0-4832-9bc1-07061a1478f6