Have you considered taking a degree in Civil Engineering, which includes Soil Mechanics on the course? Most of the competent professionals I have met working in the field(s) of Geotechnical Engineering are civil engineers with postgraduate degrees in the geotechnical area. You may find a course on how to perform the tests, but you need to know when (and where) and how often to perform the tests, and you need to be able to interpret the results. You need to be able to understand the tests well enough to understand what to do with results that are not "standard".
You also need to use the results of other tests with the ones you mentioned to understand the behaviour of the soil, both as it is before you carry out any construction and after completion of construction.
I'm not aware of any videos or training software, although I'm sure someone reading this will. If so, I would caution you to use it as refresher training, and not as your only training.