As humans we all process information through filters and one of those filters is your current job title / background!
Though your job title may work well for you right now, the moment you try and take on a different role, job title / background / responsibility, you end up running into a brick wall! … it is like people fold their hands and adopt a challenging, prove-it-to-me attitude!
So, in today’s post, I will answer a question submitted by (Jan) who has worked 15+ years for one of the largest IT Corporations “but still feels boxed-in / walled-in” by his current job title!
When it comes to the Information Technology Industry, getting more hands-on experience is one of your most important professional development activities.
In this post, I will explain how information technology workers including business analysts, computer programmers, database developers, data analysts, project managers, software testers and infrastructure / networking professionals can gain extensive, high visibility, career defining hands-on experience!
More Opportunities To Get Hands-on Experience
By far, the number one place to find hands-on project experience in the information technology industry is in web or software development projects!
Learning new Information Technology (IT) skills is typically thought of as painful because the Study Textbooks used in the Information Technology (IT) industry are usually written by geeks for a geeky, hard-core, technical audience.
This is why one of the challenges facing professionals today is how to overcome the difficulty, complexity or high learning curves typically associated with learning new Information Technology (IT) skills.
Keeping in mind that Sql or Database skills are useful in any industry including financial, insurance, banking or information technology sectors, wouldn’t it be really helpful if learning Sql or databases was made easy?
Are you matching your strengths to your opportunities or are you just being ideological … interested only in following your own ideas even when they won’t get you any results?
Here is a situation that illustrates the challenges of being ideological versus being results oriented. It is a situation that illustrates the challenges of learning an enterprise software like Oracle compared to a poor man’s database like Microsoft Access.
Are you wondering about who this situation involves? You are safe my friend because today, I will mainly be talking about me 🙂
While a fair amount of the work that goes into creating, maintaining or optimizing databases is hidden from decision makers, the work that goes into creating reports is immediately visible to management and so, must be given a good deal of attention.
This post is written as a guide for creating SQL based reports. It helps ensure that high quality, valid, reliable reports are created by report writers.
After reading this post, you would have a formal process for creating SQL reports and a step by step guide for reporting on data contained in AS400, Oracle, SQL Server, Microsoft Access or some other database platform.
Database skills are foundational to jobs in the IT Industry.
By that, I mean whether you’re a business analyst, software tester, project manager, software developer or even a web designer, you’ll be using relational database and sql query writing skills at some time in your career.
Database or SQL skills are also important because they position you for multiple careers paths ranging from that of the database developer to the data mining professional.
Career Paths for Database Professionals
Here is a comprehensive list of database career paths and their respective roles, duties, responsibilities and skill sets.
The Microsoft Access Relational Database has been around for a while and it is used in many businesses, Information Technology (IT) Teams and organizations.
Microsoft Access is commonly used in building desktop software applications, data analysis programs and corporate databases where the number of records are as few as 2 billion records or the number of users who access the system at any one time are as few as ten concurrent users.
The ease with which Microsoft access database developers create functional relational databases, add data entry forms, build reports and distribute their database projects to multiple users creates a market for skilled Microsoft Access Relational Database developers.
There is an article on Elance that says that SQL skills are currently the third, most in-demand skill on the Elance job network
Elance for those of you who’ve never heard of it, is one of the top job sites for freelancers or remote workers or offsite consultants
You may not have heard of Elance because you’ve always worked a full-time job and you don’t know much about the freelancing or moonlighting world or perhaps you have worked freelance jobs, but for some reason, have never heard of Elance.
The technical skill most in demand or frequently asked for on business analyst job postings, computer programmer jobs, data analyst positions, report writer job openings or most software development job postings is relational database management skills including SQL programming, database design, database development and SQL querying skills.
Are you surprised or in doubt?
Take a look at the job postings for business analysts, computer programmers, data analysts or database developer jobs and you will see that the technical skills common to all software development professions include: