It's a digital SLR (DSLR) with interchangeable lenses. You CAN use it on auto, but your best photos come from learning how to use it in manual. I taught myself.
It's cheaper than it used to be, but still pretty high compared to P&S cameras. PM me if you want more info about it and how to search for deals.