You'd have to request it, but it would likely be approved. They'll ask you what I'm about to though, why would you drag your family to the middle of nowhere and rent an apartment for a 6-8 week course that requires 100% of your focus?
No offense, it just sounds like you'll be breaking the bank for a huge distraction (failure = no longer a pilot). You're going to be away from home A LOT as a pilot...