Can I get my privote pilot's certificate, instrument rating, etc at Embry Riddle Aeronautical University?

Yes, you can get all your pilot certificates and ratings through Embry-Riddle. You would know that if you had at least researched their website. Obviously you're not really ready to apply if you haven't done proper research into exactly what you're applying for. As for "needing" a BS of Aeronautical Science, the answer is that you don't. If your aspiration is to become an airline pilot, any 4 year degree in any discipline will suffice, even if it is totally unrelated to aviation. I won't talk you out of getting such a degree, but my own experience of getting a BS in Aeronautical Science is that it won't give you a competetive edge when it comes to getting jobs (far from it), and it is pretty useless for obtaining gainful employment outside of flying for a living, and there have been many times (including now) when I have been out of work as a pilot and needed more than a menial job. Based on my experience, a good "backup plan" would be to get a degree in anything but Aeronautical Science. And, ERAU is extraordinarily expensive. Four years of tuition, room and board, and flight training will cost roughly $200,000. If you can afford it, great, but don't expect to be able to borrow even half that much for under-graduate study. ERAU is a good school, but it is not the "best". There is no "best" aviation school or college, there is only the best one that fits your budget and other criteria, such as lifestyle and personal goals. There are dozens of good schools well worth your consideration that are much less expensive. Personally, I'd get the education and training as inexpensively as possible because when you graduate you won't be "airline material" yet. It takes many years working as a pilot at relatively low wages before the major airlines will consider you. Entry-level jobs, even as a regional airline first officer, are in the neighborhood of $20k per year, and pay doesn't rise quickly. Having to pay off a huge educational debt doesn't make much financial sense when you look at the potential income the first 5 years or so after graduation. By the time you have built the required experience (usually 5 to 10 years) to start getting interviews wth a major airline, or a top-level corporate jet outfit, where you learned to fly or what degree you have, or where you went to school is more or less irrelevant. Flight time of the right sort, and having good references and a sterling personal, employment, and flying record is what counts. There's a reason that only 25% of students who enter the ERAU flight program in their freshman year graduate from it 4 years later. That's a statistic that they'll never tell a prospective student, however. ERAU may still be the right choice for you, but it might not. There are many excelent alternatives. "Look before you leap", as they say.

Embry is a good school, it is also VERY EXPENSIVE when compared to other training methods. Many State and local Colleges offer the same training and the dollars you save will be significant. I would tell you to get a degree in Business or Physics or anything other than aeronautical science (unless you want to design aircraft) so that you have a backup plan in case you find yourself unable to fly. Flight training can be done an many many flight schools it doesn't have to be done as part of your college education it can be done parallel to it and you will save thousands. Embry and Delta Connection do have good training but the education you get doesn't compete with degrees from say Princeton, Harvard, Yale, or even Arizona State or U of A, etc. although the cost is about the same! Just a few thoughts, but I just don't see the real advantage to Embry for most people. They can't and won't guarantee you a job flying! A commercial pilot these days will need a degree but that degree can be in just about anything and really is more advantageous to you to be in something other than "Aeronautical Science". A degree in Computer Science or Environmental Science or Airport Management would be more valuable to you these days! In fact - check out ASU (if you like Arizona) http://technology.asu.edu/aviation/