Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips













































   Got a SQL tip?
            We want to know!

SQL Server Training On A Budget

MSSQLTips author Marlon Ribunal By:   |   Read Comments (5)   |   Related Tips: More > Professional Development Career
Problem

According to a recent study cited in a Microsoft website, "cumulative data will grow 44 times over the next decade." That surge in data growth can only increase the demand for data professionals. More and more people will be needed to fill that demand. There is no better time to become a SQL Server professional than now.  I have friends that expressed their interest in becoming a SQL Server DBA or Developer, but they don't have the resources to afford formal training in SQL Server. A week of end-to-end introductory courses could cost around $2,000-$3,000. Those that are on tight budget may not be able to afford that.  Check out this tip to learn about training on a budget.

Solution

If you have a good background in IT and have some exposure to tasks or projects that are related to data in some form or another, you could take the self-study route. I would high recommend taking the Microsoft Certification exams on SQL Server to validate your self-study effort. I still recommend formal training, plus real-world experience with SQL Server, as a better way to learn.

Below are few tips for SQL Server training on a budget.

Set Your Goals

You must set some goals. SQL Server is a multifaceted software platform, and it is quite easy to get overwhelmed with it. I suggest you pick a particular SQL Server certification to pursue.

There are two stages of the SQL Server Certification. Your first step is to become a Microsoft Certified Solutions Associate (MCSA). You can advance to the next level by becoming a Microsoft Certified Solutions Expert (MCSE) in which you have two tracks to choose from - MCSE in Data Platform or Business Intelligence.  Decide on which path you want to take in order to focus your self-study effort.

Create Your Study Plans

Once your goals are set, your next task is to build your study plans. Your study plans serve as a concrete outline of how would you work toward your goals. The Microsoft Exam Study Guides are great outlines to use for study. They provide the topics you need to focus on to pass the certification exams.

Your primary resource for studying SQL Server is the Books Online. You might also want to invest in a book from the Microsoft Training Kit Series. Get the book specific to the exam you're going to take. Blogs are also great resources for studying.

Invest In Tools

You need a good computer to run SQL Server. If you have the budget, I recommend a laptop, but not just any laptop. SQL Server requires a computer more powerful than most consumer computers. You might want to buy a laptop with Core i7 Processor and 16GB of memory if you have the budget. Features such as Failover Cluster and AlwaysOn Availability Groups require multiple SQL Servers. You need at least two instances of SQL Server, aside from a separate Windows Server Domain Controller, to setup AlwaysOn Availability Groups.

For the software, you can purchase the Developer edition of SQL Server, which contains all features of the Enterprise edition, but cannot be used in a production environment. Or you can download the trial version. There is no Developer edition for Windows Server, but you can also download the trial version.

Another option for your software needs is a TechNet Subscription, which provides full versions of Microsoft Software - Windows Server and SQL Server included - for use in a non-production environment.

Set Your Training Hours

Find time to study in a distraction-free environment. You need a lot of focus and it is very important to have a schedule to follow. Have "off-limit" hours in the evening (or day) so you can sit down and focus on studying. You might need to sacrifice some other activities that are in conflict with your study hours.

Get Help

Just because you're on a self-study training doesn't mean you're all alone. Once you decided to study SQL Server, the whole SQL Server Community has "got your back". You only need to let them know you need their help. The Professional Association for SQL Server (PASS) is dedicated to helping you advance your SQL Server knowledge in any reasonable way.

The good thing about the SQL Server Community is there are multiple channels with which you can reach SQL Server professionals ready to help you at any time of the day. You can find them on: SQL Saturday events, SQL Server User Groups, forums, and even on Twitter. Use the #sqlhelp hash tag on Twitter to get answers for your SQL Server questions.

Next Steps
  • Read "Starting your SQL Server Career Path", a great tip from MSSQLTips on how to get started with SQL Server.
  • Practice your new SQL Server skills in the real world. If there is no "On the Job Training" opportunity for you now in your current job, talk to your management to see what opportunities may be available.
  • Continuously build upon what you already know and take advantage of any learning opportunities that you might come across.


Last Update: 9/21/2012


About the author
MSSQLTips author Marlon Ribunal
Marlon Ribunal is a data specialist for an aerospace & defense company. He is passionate about SQL Server, data, and BI.

View all my tips
Related Resources


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Comments and Feedback:
Monday, September 24, 2012 - 11:56:06 AM - eddie Read The Tip

This would be good core principles to follow for technical training for more than just SQL also.... SharePoint, SCCM, AD, SCORCH.... and on and on. 

Good info!


Wednesday, March 06, 2013 - 4:59:27 PM - JZ Read The Tip

Good post mate keep it up.


Friday, March 22, 2013 - 8:26:28 AM - Sherlee Read The Tip

 

Nice post. 

But for me time and budget is hard to find specialy if you have a family that needs your time and financial support.

For singles grab that moment where you are carefree!


Monday, June 03, 2013 - 5:53:43 PM - Nick Read The Tip

I can’t tell you how many times I have given this exact advice; but not as well researched or complete as you have outlined in the article. 

 

Never again, from now on I have link to send.

 

Thank you!

 


Monday, August 26, 2013 - 8:47:28 AM - John Read The Tip

Good Advice, but isn't Technet being phased out?



Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email Notify for updates



Comments
Get free SQL tips:

*Enter Code refresh code


 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.