Setup a .Net and SQL learning environment at home

Hello,

I know these questions are a little broad but I've learned if you don't ask you don't learn.

For fun and learning I would like to setup a recommended way of creating a SQL / .Net testing/learning environment at home to practice what I learn here on EE.

Here are the technologies I hope to learn more about:

ASP.Net, VB.Net, C#.Net, MVC, SQL Server with Enterprise Manager or similar, SSRS, SSIS, JSON, JQUERY

Since I'm on a budget it would be great if there's a low cost way of achieving this.

best regards,

Ted
LVL 1
tcalbazAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
esolveConnect With a Mentor Commented:
I think its best if you decide on a language. Either C# or VB.NET and stick with it. C# is the most popular and widely used in the industry so I will suggest that. However you can use both with Visual Studio. Also its best if you use the latest editions of Studio because it contains all the latest technologies.

Then again either start with ASP.NET or MVC. I will suggest to start with ASP.NET first before attempting MVC for the main reason that MVC is a relative new technology.

Not sure is the express edition of SQL server supports SSIS and SSRS. Might be a limitation unfortunately. You want to learn T-SQL and database design and normalisation which is enough to start with. You wont be needing SSIS and SSRS that much initially.

Visual Studio 2012 also provides some awesome new debugging features for jscript and jquery. Its honestly a breeze to work with. Also your IE, Chrome and Firefox browsers has more than enough debugging tools for this. Same with JSON.

You can find the express editions here.

Visual Studio 2012 Express
http://www.microsoft.com/visualstudio/eng/products/visual-studio-express-products

SQL Server 2012 Express
http://www.microsoft.com/en-za/download/details.aspx?id=29062

Have fun
0
 
informaniacConnect With a Mentor Commented:
Express editions of visual Studio and sql server should help you.
0
 
David ToddConnect With a Mentor Senior DBACommented:
Hi,

For SSIS and SSRS look at the Developers Edition of SQL.

Suggest maybe an action pack or other MS subscription for software.

Also check our Microsoft Virtual Academy (MVA)
http://www.microsoftvirtualacademy.com/Home.aspx

HTH
  David
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
ValentinoVConnect With a Mentor BI ConsultantCommented:
SSRS is possible for free if you download the SQL Server 2012 Express Edition with Advanced Services installation package (search for "SQLEXPRADV").  But SSIS is not available freely.  As dtodd mentioned, your best option to get that is Developer Edition.

However, if you also require operating systems and possibly Office, you may want to look into getting a Technet subscription for a year.  Have a look at what software you can get with each type of subscription, compare the price with the normal prices you'd pay if you had to buy each product separately.  Then decide if it's interesting for you to go down that path.
0
 
tcalbazConnect With a Mentor Author Commented:
Hi all,
I'm going with  the SQL Server 2012 Express Edition since it has SSRS. I'll hold off on MVC right now.  All of you had valuable information so I feel compelled to give credit to all.

Thank you!
0
 
tcalbazAuthor Commented:
All of you had good contributing answers. Thank you!
0
All Courses

From novice to tech pro — start learning today.