My soon-to be-sophomore daughter usually flies out of Sacto and changes in Chicago or some such. You'll get used to changing planes and I'm sure leaving from SFO or OAK will give you lots of options, and better prices..
For transportation between RDU and Duke, check this thread
Airport to/from Duke?