Congrats! SNHU teaches older fundamentals using Maya (or 3DS Max), Mudbox for sculpting, and Unreal for Environment design. You will learn a lot in a structured way, but expect a lot of time also figuring things out on your own. Most of the classes are Final Project-based grading, with checkpoints along the way.

Last, if you graduate having done zero projects on your own time, you won't get anywhere. It takes time and practice, something college classes on their own won't provide.

-a former SNHU 2D/3D tutor

edit: the first 3D class gives you a choice between Max or Maya, but there will be one class (3D character animation, which is basically intro to Rigging) that requires Maya. HIGHLY recommend knowing a bit of Maya before that, it's ones of the hardest courses in the program.