Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Setup a .Net and SQL learning environment at home

Posted on 2013-01-19
6
Medium Priority
?
442 Views
Last Modified: 2016-02-10
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
0
Comment
Question by:tcalbaz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 20

Assisted Solution

by:informaniac
informaniac earned 500 total points
ID: 38796913
Express editions of visual Studio and sql server should help you.
0
 
LVL 6

Accepted Solution

by:
esolve earned 500 total points
ID: 38797392
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
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 500 total points
ID: 38797711
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 500 total points
ID: 38800030
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
 
LVL 1

Assisted Solution

by:tcalbaz
tcalbaz earned 0 total points
ID: 38873298
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
 
LVL 1

Author Closing Comment

by:tcalbaz
ID: 38892423
All of you had good contributing answers. Thank you!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I have a large data set and a SSIS package. How can I load this file in multi threading?
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question