Starting out in the Information Technology (IT) industry, two of the most popular, marketable and portable skills are Relational Database Design / SQL Query Writing and Computer Programming / Web Software Development.
Considering the demand for each of these skills, a reader wants advice on which skill should be tacked first: computer programming vs. relational database development.
Advice: Which Do You Learn First: Database Design Or Computer Programming?
I will advice you to learn both computer programming and database design at the same time if you can afford the investment of time, effort and money but if you have to start with only one, learn database design + sql query writing first and here is why …
For several personal or professional reasons, “you may be considering non-traditional database career paths” … jobs that allow you to work with databases in some capacity without the trappings of typical, traditional full-time database developer jobs.
In this article I will answer a question posted by “Kimberly Joy from Montreal, Quebec, Canada”. Kimberly has a QA background and wants to get back into the Information Technology (IT) industry as a part-time database developer.
This article is Part 1 of a series on Non-Traditional career opportunities in the IT Industry.
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!
First, discover your passion and work a job you really love.
Second, turn your passion into a set of excellent skills using practice tests or quizzes.
Third, bring your passion to the market using Push (emailing your branded resumes) or PULL Techniques (Social Media Marketing).
Here is a question for you; Do You Really Love Your Job?
In a study of how exceptional, world-class or, successful people are produced, Daniel Coyle in his book “The Talent Code” says that it takes a combination of concentrated, difficult, skill-building practice, motivation or inspiration and master coaching to achieve success.
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 🙂
This post answers a question submitted to [Ask IT Career Coach], a Career Advice Column that offers practical answers, help or solutions for your most challenging career situations.
What Are The Entry Level Requirements For Database Professional Jobs?
A reader from Rockville, Maryland wants to become a database professional and is concerned about age-based preferences, discrimination, educational qualifications and entry level hiring requirements for database professional jobs!
What is your opinion regarding online it degrees? More specifically, Master’s degrees in database technology?
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.
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:
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.
Database careers are a mystery to those on the outside! This is partly because the work done by database professionals is not as visible as that done by professionals like business analysts or project managers.
So, in this series, I will discuss database or SQL careers by answering questions such as:
What do database / SQL jobs involve?
What is the database / SQL industry like?
What are the career options for database or SQL professionals?
What challenges do database or SQL professionals face?
SQL, also known as the Structured Query Language is used to query, retrieve and extract data from relational databases or define and create relational database structures including tables, views etc.
SQL skills are in-demand partly because of it’s portability. A skilled SQL professional can work on a wide variety of relational database platforms including Microsoft SQL Server, IBM’s DB2, Oracle, MySQL, Microsoft Access, Dbase, Foxpro.
What is the Demand for SQL Skills?
SQL skills are useful in a number of careers including database developers, report writers, business analysts, computer programmers, web developers, testers, data analysts, etc.
If you are interested in learning more about SQL Skills or becoming a Database Professional, send inyour questions now and I will answer them for you … right away!
Your questions may be about how to get a database developer job or how to improve your SQL query writing skills or how to become a database developer.
Perhaps your question is about how to get back into the database career track after a period of unemployment or about how to learn the relevant database skills for your job or employer. Whatever they are, go ahead and send in your questions and I will answer them for you.
Our readers have been asking if they can get a payment plan on the Software Developer Boot Camp or the Business Analyst Boot Camp. I am happy to announce that the answer is yes.
In addition the new payment plans include a 50% discount if you sign up right away. This offer expires Midnight, February 2, 2009. So hurry to take advantage of the limited time discount. Click here for more information
How you value knowledge tells me a lot about who you are … because knowledge capital is the most important resource in any organization.
In the digital age, what makes one employee more valuable than the next employee is simply stated … the amount of knowledge, skill, expertise, training and learning they have managed to acquire and put to use.
Now, managers are not interested in employees that know it all … only in employees that constantly put their knowledge capital to work by solving corporate problems or challenges … those employees are the gold mines in any organization.
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: