There are many programs and paths for gaining an advanced degree during a Navy officer’s career. I went to NPS as an O-3, fairly typical. That’s full-time duty.
Some attend civilian grad schools, full-time duty.
Some go to Naval War College, Army War College, National War College, AFIT, etc., full time.
“DUINS” is Duty Under Instruction, the sweetest deal, active duty, and your assignment is going to school full-time.
Some attend Naval War College local classes after regular duty hours in major fleet home ports. Some do the distance course.
Some use Tuition Assistance to do local college or distance after regular duty hours or at sea.
There are other programs.
The majority of officers get their Master’s during that first shore tour as a LT or LCDR. You’re expected to have one by the time you are eligible for promotion to CDR, pay grade O-5.
All the programs involving Navy dime or Navy time will require some years of payback. That can vary with retention needs.
There is also the option of doing it on your own time and dime, and incurring no additional obligated service.
The chosen field has to be on the approved list of Navy-useful subject areas.
Some small percentage of SA and NROTC grads are allowed to go right after commissioning. That will push their entrance into the operational Fleet 1-2 years down the road, and they will have to hit the deck running to catch up with same pay grade officers who are 1-2 years ahead on their professional quals. For those who score Oxford or the like, it’s usually worth it.
Your DS will get plenty of briefs on this, as well as career counseling from senior officers and his detailer (assignment staff). He’ll figure out what path is right.
Tell him to keep his grades up at college. NPS relies on an Academic Profile Code (APC) to set thresholds of eligibility. He will also have to be doing well professionally as documented in his officer fitness reports grades and comments.
Use the Search function - there are many threads on this.