Tags: | Posted by blockwood on 4/29/2010 1:36 AM | Comments (0)

Many of the courses I deliver at Benchmark Learning utilize the Adventure Works database.  It would be nice to be able to take those examples home or to work. 

Here is the link to download the SQL Database for Adventure Works: http://msftdbprodsamples.codeplex.com/releases/view/37109

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags: | Posted by blockwood on 3/8/2010 6:28 AM | Comments (0)

Since posting about jobs, career guiding and the importance of certification many students have asked about what they should do and where they can move too.  Below should provide some assistance as they target .NET specific exams:

 

Download the pdf here - VS2008 Certifications

 

Download the pdf here - VS2010 Certifications

Struggling Providing Reasoning To Your Employer?

Check out the other postings this month on this site.  Or check out Microsoft's website for addition reasoning: click here

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags: | Posted by blockwood on 3/3/2010 4:05 AM | Comments (0)

Kevin and Ted work for a major auto manufacturer. Both were technical support specialists with an eye on getting certified as Microsoft Certified Systems Administrators (MCSA). Kevin was able to get his company to pay for everything associated with the certification program: training, exams, books and study materials. Ted was only able to get the company to pay for classes at the local community college. For all other expenses associated with the process, Ted had to pay out of pocket. Kevin obtained his MCSA certification in only six months. He has since been promoted to systems administrator with a nice pay raise to go along with it. A year since beginning his quest for certification, Ted has yet to pass one exam, and he is still stuck in his old tech-support job.

As the senior education consultant at one of the nation's largest IT training and certification centers, I run across situations like the one described above all the time. Amazingly, two individuals from the same company, going for the same IT certification, using the same company-sponsored education-assistance program, pursue two totally different training programs and achieve two very different results. One is able to get all certification expenses covered. The other is forced to settle for a sub-par education and is left with major out-of-pocket expenses such as exam costs and study materials. Why did the HR department cover all of Kevin's expenses but only some of Ted's? How was Kevin able to finish his program in only six months-all expenses paid-and Ted has barely finished his second class and has yet to pay for his certification exams? As always, the truth lies in the details.

Chances are you already recognize the value of IT certification: increased compensation, faster rate of career advancement, enhanced credibility as an IT professional, improved chances of finding a new career and improved productivity. Now comes the tricky part: how to pay for it.

Budgeting for IT certification involves determining the real cost of everything associated with getting certified, finding a way to pay for it and completing the program in a realistic time frame, before the technology you are getting certified in becomes outdated. In the post-dot-com-crash days of IT budget cuts and outsourcing, you are lucky if your company is willing to share the cost of your certification, let alone pay for the whole program. If you are fortunate enough to work for one of these progressive organizations, I will show you how to maximize the company's education plan to get the most bang for your buck and avoid having to pay the lion's share of your certification program out of pocket. If you are currently out of work, or if your company does not offer education assistance, which is becoming more common these days, there are other public- and private-aid programs out there to help you.

Step One: Determine the Real Cost of Your Certification

When choosing a training program, it is easy to overlook hidden costs. They pop up out of the blue, and sometimes these unexpected expenses can delay your certification process. You can count on incurring the following expenses:

  • Actual exam costs: Test fees will vary based on which certification you pursue, as well as the number of exams involved. Test fees can be as low as $20 per test (Cannon Certifications) to as much as $10,000 (NCR ATM Service Engineer). Both of these examples are extreme. Most IT certification exams will cost between $100 and $300. Some vendors only require passing one exam (Sun Certified Java Programmer at $165 for example). Other vendors require multiple exams. One of the more popular IT certifications, Microsoft's MCSE for example, requires eight exams at $125 a piece. Most IT certification exams are taken on a computer in an authorized testing center, usually either Thompson Prometric or Virtual University Enterprises (VUE). To determine the exact cost of the exam(s) associated with the certification you are considering, visit either of their Web sites at www.prometric.com or www.vue.com.

Don't make the mistake of assuming you will pass all of the exams on the first try. Even for IT veterans, it is common to fail a few exams along the way to getting certified. When budgeting for your IT certification, allot a few hundred bucks for exam retakes or choose a program that offers a test-pass guarantee.

  • Instructor-led training: This is the most expensive piece of the certification puzzle but definitely one of the best defined ways. Depending on the number of courses involved, costs at certification training centers can be between $1,000 and $25,000, and this cost usually includes everything you will need to get certified: books, exams, practice tests, study guides, etc. Colleges charge by the credit hour, usually between $65 and $400 per credit hour. All supplemental study materials and exam fees will have to be paid for a la carte.
  • Study materials and practice tests: Even the best-quality instructor-led certification program will require you to study outside of class and take plenty of practice exams. Thousands of study guides are available for those seeking certification, as well as hundreds of practice tests. Manual study guides are not too expensive-usually between $10 and $50. Practice tests are available both online and in disk format and tend to be pricier than study guides, averaging $30 to $75 per practice test. There are dozens of free practice tests online, but my experience with these is that they do not map well to the real certification exams. Ask a fellow IT professional who has obtained the same certification you are pursuing to recommend a good study guide or practice test.
  • Living expense money: This is one of the most overlooked expenses when budgeting for your IT certification. If you are a displaced, dislocated or an otherwise unemployed IT professional, you need money to pay the bills while getting your education. Even those who are employed might overlook the impact the certification process will have on their finances. For example, someone working 9 to 5 who enrolls in a six-month evening certification program might need to hire someone to take care of the kids at night. Consider these expenses when putting together your IT certification budget.

Step Two: How to Fund Your IT Certification

OK, you've done your research, and you have put together a rough estimate of what it will cost to fund your IT certification program. Now comes the difficult part: Getting someone else to pay the cost, or at least as much as possible. Many companies offer employees some type of education assistance, but amazingly, less than half of IT workers take advantage of it. How can this be? With the rate at which technology changes, it would seem like IT workers would take advantage of company-sponsored tuition assistance more so than any other department. Updating your skills is not just something you should do. It is something you must do if you plan a long career in IT or want to move up the corporate ladder.

It's not that IT workers do not want to get certified. In fact, most do and many are even willing to self-fund their certification, taking out large student loans to earn the credentials they desire. The problem is that in many companies, the HR department will not pay for certification programs. Why? I have found that there are predominantly two reasons. First, the company is afraid that if they pay for certification, the IT worker will leave the company. Second, the company-sponsored tuition guidelines are antiquated and require that eligible programs result in obtaining a degree or letter grade. Certification programs do not offer grade transcripts or degrees, so the request for assistance to attend these programs is denied. Unfortunately, when faced with one of the aforementioned obstacles, many certification prospects simply give up. Don't! Here are some tips on how to get the company on board with your plan.

Sell Them on the 'Big Picture'

Most IT professionals loathe the role of a salesman, but if you want to save thousands of dollars in potential out-of-pocket certification costs, you will have to make an exception. Meet with the HR person who makes the ultimate decision or at least the person who recommends whether your education plan is approved or not. Explain to them in layman's terms (HR people are not usually technical) why it is absolutely critical that they pay for the certification program. Show them how it will save the company money, how it will boost productivity and most importantly, what will happen if you don't get the certification. "The server might crash!" Create a sense of urgency

For example, Sarah was an Access DBA for a growing mid-size advertising firm. She wanted to get certified as an Oracle DBA. She approached the HR department and explained to them that the company database was running out of storage capacity and that the company needed to migrate to a database product that held more information. Instead of focusing on her own personal career goals, she showed the employer how being trained and certified as an Oracle DBA would prevent a future disaster, such as running out of storage capacity and the possibility of having to pay a SQL consultant $15,000 to recover the lost data.

Agree to Sign a Contract

Many companies won't pay for certification because they fear that once the IT worker earns the certification, it's, "adios, on to bigger and better things." To overcome this objection, be willing to sign a contract agreeing to stay with the company for some predetermined amount of time following certification. Most contracts I have seen stipulate that you must stay with the company between one and two years following certification. Obviously, if the company is making you commit to stay for an unreasonable amount of time-say five or more years-you will need to do some serious soul searching. If you are willing to sign a contract, more and more companies are willing to pay for your certification program.

Be Sneaky

OK, so you have explained to HR that the universe is going to collapse into a black hole if they don't pay for that Citrix certification, and you have even agreed to sign a contract, but your HR manager is harder to convince than the warden in "The Shawshank Redemption." Here is how to take advantage of the loophole in most company-sponsored tuition-assistance programs. As mentioned earlier, most of these policies were intentionally designed to exclude certification by requiring that you receive a letter grade or degree from an "eligible institution." Because the only schools that give out grades and transcripts are colleges and universities, you're stuck with a college instead of a private IT certification program. College, however, is not always the best option for obtaining certification because if you are like most IT workers, you already have a degree, degree programs are often too long, college courses and curriculum do not map well to certification exams, and college courses do not include certification exam fees, practice tests and study materials. So what is someone to do who desires certification but whose company will only pay for college?

The Solution

More and more private certification schools have developed relationships with accredited colleges and universities, where the college will give college credit, letter grades and even a transcript to those taking classes at a certification school. Call around to various IT certification centers and ask if they can provide college credit. Purchase the classes from the college or university, but attend the classes at the certification school. These classes usually include everything you will need to actually get certified in a reasonable time frame: classes, books, study guides, practice tests, exam vouchers and a test-pass guarantee. At the end of the class, the accredited college will administer a short exam so they can assign you a letter grade. The college then bills your company. It's that simple. This plan allows you the best of both worlds: You get the certification training you want and to HR it appears as though you went to college, and most importantly, they pay for it!

Remember our friends Kevin and Ted? Both were attempting to get their MCSA certification paid for by their company. Kevin succeeded in getting everything covered and was able to obtain his certification in only six months. Ted, on the other hand, was only able to get the company to cover his tuition and books and has not even taken an exam yet. In order to qualify for company reimbursement, Kevin and Ted were required to produce a letter grade of C or better from an accredited college. Ted made the mistake of assuming that because he needed to produce a grade transcript from a college or university, he actually had to attend his classes at the college. He enrolled in the local community college, which created two major problems. First, each of the six classes he needed to prepare for the MCSA certification were offered over the course of an entire semester-meeting for only an hour on Tuesday and Thursday evenings. Because the classes had to be completed in order, he could not take multiple classes during the same semester. Therefore, he could only take one class per semester. At this rate, it would have taken him three years to complete the six MCSA classes. Second, the college courses were designed for a degree candidate, not a certification candidate, and therefore, there were no practice tests, study guides or certification exams included in the tuition. Ted was forced to pay for these critical and expensive supplemental materials out of his own pocket. The result: one year after beginning his quest for his MCSA, Ted has completed only two classes and has yet to take one exam.

Kevin, on the other hand, took advantage of the loophole in the company's tuition reimbursement program. To produce a grade transcript from an accredited college, Kevin called around and found a private Microsoft Certification Learning Solutions Partner that had a relationship with a local university. The private training center offered all six MCSA courses in a condensed time frame. The six courses were each taught in eight evenings, four hours per night. At the end of each evening class, Kevin took a short exam. His scores on these exams were used to assign Kevin letter grades. After six months, Kevin was able to complete his entire MCSA certification and was reimbursed the total cost of all six classes, exams, study guides and practice tests. All costs associated with the certification were approved for funding because they had been bundled together into tuition costs by the private certification training center and an accredited college had provided a grade transcript to the company. Voila!

What if My Company Doesn't Offer Tuition Assistance?

If your company does not offer any type of educational assistance, do not just assume that you will have to self-fund your education. Call around to local colleges, universities and private certification centers and ask them about grants. Many grants cover all expenses, including supplemental study materials, practice tests and certification exams. Others cover only tuition and books, but every little bit helps. The following are four government grants that will cover the cost of all or part of your certification program, if you qualify:

  • Veterans Administration (VA): Offers grants to both active duty and reserve military and sometimes family. Most popular program is the Montgomery GI Bill. However, they offer other grants as well.
  • Workforce Investment Act (WIA): Designed for those who are unemployed or "under-employed," WIA offers between $3,000 and $15,000 in retraining dollars that may usually be used for certification or degrees. Funds are distributed by each state. Contact your local unemployment office and ask them where the nearest "One Stop Center" is to apply.
  • Vocational Rehabilitation (VR): Designed for those who have a physical or mental impairment, VR grants are usually very generous and often cover the entire cost of approved certification programs.
  • Pell Grants: Many workers assume that because they are employed, they will not qualify. Although Pell Grants are need-based, you might qualify based on your income level.

Student Loan Options

OK, if your company won't pay for it, you don't qualify for any grant money and you didn't just win a million bucks on "Deal or No Deal," you will probably have no choice but to take out a student loan. As far as loans go, student loans probably are the best of breed. They have the best terms of any type of loan: payments are usually deferred for at least one year from when you start your program; interest rates on government subsidized loans are usually very low (2 percent to 4 percent); there are usually no pre-payment penalties, so you can pay off the loan early if you like; and the interest you pay is usually tax deductible. Loans at colleges and universities are usually subsidized by the government and, therefore, nearly all applicants are approved unless you have defaulted on a student loan in the past or dealt drugs in a school zone (believe it or not). Loans at private certification schools are usually unsubsidized, which means approval is based on your ability to repay (credit score) and the interest rate is higher-between 8 percent and 18 percent.

Although nobody likes to incur debt, it has been my experience that certification candidates who have to self-fund their education seem to finish their program and pass their tests faster than those whose training is being paid for by their company or a grant. When you have to pay for something with your own money, it tends to take on a higher priority.

Perhaps the most difficult part of budgeting for IT certification involves no money at all: budgeting for time. Your ultimate success will be determined by how well you can balance your time between work, family and studies. If you can manage your time effectively, one thing is certain: It is all downhill from there. Are you up for the challenge?

Original article can be found here:  http://www.globalknowledge.com/training/generic.asp?pageid=1991&country=United+States
By: Matt McGrath

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags: | Posted by blockwood on 3/3/2010 3:30 AM | Comments (0)
Benchmark Learning - Adult education destination

 

KNOW YOUR EMPLOYER

Before approaching your boss, it is of paramount importance to understand the state of your company.  Are economic times lean?  Is a massive reorganization underway?  These could be hindrances or they could help you structure a solid case.  The key is to have an idea of what is happening internally at the organization and use it to strengthen your argument.

A great way for your organization to stay with the pack or excel in an industry is to staff an educated workforce.  If you can specifically spell out ways your degree will help the organization, you will have laid the groundwork of your case.  Be as specific as possible.

Also, is an advanced degree or certificate officially required or encouraged for the position you have your eye on?  While it is true that the greater your education, the greater the number of doors you create for yourself, some positions simply do not call for it.  Make sure the work and expense are necessary.  Look for trends in people's education who currently or have previously held the position(s) you are interested in.  Glean information by asking your co-workers or approaching the individual about their academic past in a friendly way.
 
KNOW YOURSELF

You also need to be clear on what you want to study and why.  Cause let's be honest, improving your company's talent poll is a secondary goal at best.  Raising your stock as a potential job candidate, and as a person, is first.

Make sure you choose a subject that you have genuine interest in and can help you get ahead - or transition into something you want to do.

It's important to be honest with yourself on how long you plan to stay with the organization you are pitching.  Many employers will have you sign an agreement stating that you will stay employed with them for X number of years. Should you leave early, you will likely be responsible for a portion (or all) of the money the company spent on your education.

If you already have one foot out the door, the last thing you need is added pressure to stay in a bad marriage,  As with most career moves, you need to know yourself before you make a move.  

KNOW THE SCHOOL

While online degrees have certainly become more mainstream, they are certainly not on par with their brick and mortar counterparts. Adult learning facilities can play a key role such as Benchmark Learning, who offers Remote Learning, eLearning, Personal Mentoring and Mentored Learning modalities in addition to instructor led. 

There's a good chance you'll have to "defend" the school to your employer, especially if it's one without a physical building.

This is the real world.

Your goal is to be as prepared as possible and make the strongest case you can.  How long has the school been in business?  How many students do they have?  Do they have any affiliation with nationally-recognized organizations?  These are the types of queries you should be able to answers to all question-askers.

KNOW YOUR BOSS'S CONCERNS

As I mentioned earlier, your primary purpose in continuing your education is self-improvement.  Any boss worth his or her salt will recognize this.  Your job is to disarm them as best as possible, assuring them that this will likely be the last stop on your career train.

Since I'm a tremendous fan of truth and honesty, I think it's OK to be upfront that this endeavor is about you AND the company (not necessarily in that order).  Anything else is ridiculously transparent.

There's another hurdle.  It's something that's on your boss's mind constantly: money.  You are going to have to justify that the money the organization spends on your classes will come back to them two-fold.  Get some projected numbers to back up your claims.

KNOW YOUR POSITION

You'll have a much better chance of getting your tuition approved if the education relates directly to your current job.  If it's not an exact match, you better be able to explain how it fits into your career track - and more importantly - the company's goals.

If you want to take classes that clearly fit within a department other than your own, you need to be able to explain why it's worth their time to cough up the cash.

KNOW YOUR FINANCES

Every company has a different policy when it comes to who will initially pay for your classes.  Years back, I made the case to take a specialized course.  The company agreed to pay.  The only catch was that I had to pay and they would reimburse me 6 - 8 weeks after the course was completed.  At the time I simply didn't have the expendable cash.  I also didn't want to put the expense on a credit card and be stuck with several months of interest.  Be sure you have an idea of what you're willing and capable of doing from a financial standpoint before you make your pitch.

WAYS TO LOBBY FOR EDUCATION

  • Outline how the training will benefit the company in your current role (and where you may end up). At the very least, this will put your ambitions within the organization on the table.
  • Reinforce your commitment to the employer. Share examples of how this increased training will help you stay on top of the latest trends.
  • Show how the competition has employees with this level of education and how it offers a reimbursement benefit. In this day and age—when you can find anyone on the Web—getting this information is not as difficult as it sounds.
  • Have your paperwork in order, and do your research on the program so you are ready to answer any and all questions. Make it easy for your employer to say "Yes," difficult to say "No."
  • If you get the runaround or are rejected, ask when you can broach the subject again. Show that you are committed and that you won't simply go away. (So many bosses I've run across just want to "send you away" as quickly as possible.)
  • Don't circumvent your boss, but do have conversations with HR and upper management about your desire to further your education. These can be casual in nature and could lay the groundwork for when your boss approaches them on your behalf.
MORE INFO

Especially with recruiters and talent managers becoming ever more mindful of a perceived talent shortage. Developing internal talent streams is an important topic.

That said, the questions listed in Know the School are only the beginning, and not the most crucial.

1. Is the school accredited? If so, by what organization? In the U.S. regional accreditation is king, nothing else matters. As mentioned above, accreditation/affiliation/approval by a national professional organization is also good, but apply on program-by-program.

2. What is the rigor of the program? What is the quality of the curriculum? If a school is not going to work you and push you, it is not worth your time and will not add any real value to you as an employee or job candidate. There is a very real difference between convenient and easy.

3. What student services are offered, who provides them, and how are they delivered? Prospective students should look for schools that are helpful and supportive beyond enrollment. Possibly ones that help define and build your career?

4. If online, what is the platform and delivery model? Here is where you want ease-of-use, plus access to tools that suit and support your learning style. Also know the difference between synchronous and asynchronous.

5. You want good instructors, well trained (especially in online teaching models and practices).

Continuing education is great and necessary. Mistakes can be very costly in time and money, so go in as well-informed as possible.

Reference: http://www.jobacle.com/blog/2008/1/30/get-your-employer-to-pay-for-an-online-degree.html
Reference: http://www.usnews.com/money/blogs/outside-voices-careers/2009/01/05/how-to-get-your-company-to-pay-for-college

 

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5