Here is a dumb question. I just bought SQL Server 2008 R2 to begin learning it on my home PC. I bought it just to learn it, not to use it as a business. Do I need a server connection to get data for tables? I am not connected to any server.
Is there a way to download data and create tables for practice?
Meaning, do I have to be connected to a business server? or can i just use it and connect to some website that I can download tables/data.
What package did you buy that got you SQL 2008 R2?
If you buy something like SQL 2012 developer edition http://www.amazon.com/SQL-Server-Developer-Edition-2012/dp/B007RFXQAM it comes with a database engine and the developer tools. So you can have a database server on your computer and access it and work with it from your computer. Like djj55 said, if you are going to do any heavy lifting, you will need a beefy box.
Alternatively, if your objective is learning, you can get started without spending any money by downloading Express edition, which is free to use. That also has database engine and client tools (download express with tools or express with advanced services) http://www.microsoft.com/en-us/download/details.aspx?id=29062