Master Complex SQL Queries
Many database professionals have a hard time writing complex, complicated or advanced SQL queries for the following reasons.
In a healthcare database project that I consulted on, I had to write fairly complicated and efficient SQL queries for physicians at several practices because of their specialized reporting requirements.
The real problem was not the complexity of the physicians database but it’s poor suitability to the physicians reporting needs.
Based on experience gathered from consulting on several database or data analysis projects, I have observed that writing complex or complicated SQL queries, may prove challenging because of the following:
How To Boost IT Skills Rapidly Or Get Hired Fast
Learning a skill is one thing … knowing how to market, a skill a completely different thing!
That is why for example, some qualified business analysts fail to get a job that other less experienced business analysts succeed in getting.
Don’t assume that because you know a skill through self study, formal education or training, you can just go out and get a job … because there is more to finding a job than that!
Some people are really good at selling themselves … even when they know little about the subject at hand.
Making Things Happen
Scott Berkun, a former Microsoft Program Manager shares his views about becoming a project manager.
His views are startingly similar to the views we have been posting on this website … that getting more handson experience is the best way to jumpstart your career!
Notice Scott does not start with a long list of educational requirements or certifications for aspiring project managers but with something that you have heard me talk a lot about … hands-on experience!
Scott’s Advice for Aspiring Project Managers:
-
WORK ON A PROJECT.
-
Go make something …
We Give Feedback!
One of the challenges of self teaching, self learning, CBT courses or traditional class room training is the lack of personalized, one on one performance review or feedback.
Training courses where both instructors and trainees can post or respond to questions are few and far in between.
This is the case even when you pay thousands of dollars for traditional class room training!
This is because training providers typically have an in-flexible curriculum and a set amount of training time to communicate their message!
Beggars Can't Be Choosers
One of the bigger issues facing IT professionals is: “the challenge of building experience“.
This challenge exists because employers still require experience for hiring, even when you need their jobs to build experience!
It’s the classic Catch-22: “chicken or egg which came first challenge” that may be solved through internships or full-time jobs.
However, internships are getting increasingly competitive (Read More …) and employers are still insisting on handson experience before making job offers.
Why Internships Are Hard To Get
For a while, internships helped provide the missing handson experience to IT professionals learning new skills or transitioning careers.
Jack Reacher
Technology is always changing so IT professionals have to stay ahead of the technology curve or risk losing their jobs or careers!
So you have to constantly update your skills through self study, coaching or training.
This post discusses how you can stay ahead of the technology curve using self study.
Contrary to what you may think, self study requires a considerable investment of time, money and effort.
Jobs for College Graduates
Whether you’re launching your career or trying to change its direction, you can get around the Catch-22 issue (“You can’t get a job without experience, and you can’t get experience without a job.”) with humility.
The solution is to get some humility because today’s shifting job market requires everyone incuding young job seekers and older workers with years of experience to continously reinvent their careers in order to stay marketable in a competitive global economy.
The lesson is that careers, skills and workplace environments will continute to transition and there is nothing we can do about that because what is marketable and in-demand today may not be wanted tomorrow.
Newsletter
Facebook
Twitter
