DSPs? What does that stand for?
In this case:
Back in the 1990's, they had a similar status as GPUs currently enjoy. They packed a lot of compute horsepower into a cheaper, embeddable package than your typical CPU of the era (i.e. it was pretty self-contained and didn't need a bunch of other chips around it). The ones we used were somewhat unusual, in that they had 6 link ports that you could use for intercommunication. We connected them in a 2D toroidal topology (think of it like if you drew a grid on the skin of a doughnut) and then used the other two ports for broadcast. They had a special mode where a "master" node could broadcast instructions to all the others, which is how SIMD actually worked. Each node had just 256 kB of SRAM.
I know what AVX stands for, but I have no idea what the MMX or SSE is in this context. I know they are instruction sets, but that’s all I know.
They're all vector instruction set extensions to x86. MMX (Multi-Media eXtensions) was the first on the block and was just 64 bits. It operated exclusively on integers and launched on a later iteration of Pentium CPUs, back in 1997. MMX registers were the same as the x87 floating point registers, which caused issues when switching back and forth between MMX instructions and FPU instructions (you had to do an expensive state reset).
SSE was a massive leap ahead and came on the Pentium 3, in 1999. It introduced a new set of registers, supported floating-point arithmetic, and operated at 128-bits. That's how wide the registers were, but we didn't have CPUs (from Intel, at least) that processed the full 128 bits at a time until Core 2.
An interesting fact about AVX is that it was rumored to have been spurred on by Apple. Steve Jobs was said to have flipped out, when he heard that XBox 360 had a 3-core PowerPC CPU, running at like 3.2 GHz. That was way faster than what Macs had, at the time. Meanwhile, Mac CPU performance was falling behind Intel CPUs like Core 2 Duo. However, PowerPC had an advantage in that its AltiVec instructions were superior to SSE. So, AVX supposedly became a negotiating point between Jobs and Intel. I don't know how much of that might've been mere speculation.
I am incredibly passionate about computers and technology in general, which means that learning it is very easy. It’s funny, I know a decent amount about pc hardware despite never having built one myself. The main reason I haven’t is because currently, I don’t want to potentially mess up and get stuck. If only I had the opportunity to have a pc building class where I wouldn’t be risking my own money if I broke something.
My first job was actually fixing PCs, after school. It didn't last terribly long (mostly due to a management change), but gave me some useful hands-on experience. There was a brief period, at my first professional job, where I felt a bit overwhelmed and I toyed with the idea of quitting software development and going back to just fixing PCs. I'm glad I didn't, though.
Anyway, maybe you could find some cheap, older hardware to play with on ebay or at a local flea market. The first PC I built myself was mostly from parts I bought at a computer fair. Good times!
Another idea, if you have lots of time on your hands, would be to see about getting involved in a charity that refurbishes PCs for education and low-income folks. I know charities like that exist, so you could search around for something like that in your area and see if they could use any help.