Here's a step-by-step instruction on how to create a number of site collections, content databases and how to combine them.

Creating Lists in Visual Studio required an awful lot of CAML or some awkward work arounds—until SharePoint 2013 and Visual Studio 2012.

Make Visual Studio do the hard work to simplify the creation of external lists that can be used to connect outside data to your SharePoint projects.