I would recommend this camera if and only if you need the tilt LCD feature. Barring that, the D3100 is almost exactly the same camera (minus some features hidden deep in menus that you will never use) for amateur photography.
The big thing is that in the situations where you're in need of the tilt LCD and live viewfinding, you're likely going to be needing a very fast lens. The cheapest, sharpest, and fastest lenses are all of the AF/AF-D type which Nikon's lowest end of cameras do not support autofocussing on. This camera support AF-I/AF-S, but those lenses due to internal servos are inherently more expensive, as well as being "newer" lenses with "features" such as being gelded (the camera metaphorical equivalent of the equestrian term), tend to be worse lenses than their price equivalent 1980s counterparts.*
So effectively with this body you're stuck with only a small selection of very expensive lenses should you wish to upgrade.
If you're looking to get a body that will help transition from amateur to enthusiast photography, the D90 supports older lenses and is at the exact same price point, and shoots just as well, barring the swivel LCD. The D300 is pretty much the best camera worth buying, unless you're a serious professional looking to go full frame with a D800 or D4 (but in that case you know way more than me and don't need my advice).
So before you pull the trigger on this, determine your personal price/value boundaries, and consider how much the swivel LCD is worth.
*My fixation with old lenses comes from the fact that they can come very cheap at very high quality if you know where to look (garage sales, estate sales).