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 🙂
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:
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
It is time for you to send me the toughest or most important questions on
your mind about your career.
You can ask questions about developing your skills, taking phone or technical
interviews, preparing your resume, finding a job, getting training, coaching or
mentoring, getting real-world, hands-on experience, getting ahead or getting
promotions at work, transitioning to a new career, dealing with difficult
relationships at work, beginning your career or advancing your career to a
senior or expert level.
1. You can ask questions about your business analyst career
2. You can ask questions about your data analyst career