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.
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 🙂
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: