And how should I prepare for the tests?
You can study the NY State Driver's Manual and take the practice tests.
what do I need to do in the DMV if I want a Standard that is not for federal purposes?
You need to bring your current NY State license as proof of identity.