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!
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
You always want to make sure that the training programs your attend match your career interests and aspirations, right? … so pay close attention to what I am about to say next.
Effectiveness of Traditional Class Room Training
Late last year I was mentoring, coaching and training a software development team. One of the members of the team had paid more than $6,000 (Six Thousand USD) for a class-room based training & certification program.
To fund the training which required an upfront, full payment, he raided his savings account and took on additional debt.
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 database developer job, data analyst job or report writer job are related job roles that may be performed by the same person depending on how the size of the organization.
In most organizations, the business analyst or software developer starts out performing all three types of jobs. As demand multiplies and the individual begins to feel overwhelmed, the jobs are split … and as time goes … into the three (3) different type of jobs.
For this reason, anyone performing the duties of a business analyst, software developer, database analyst, report writer or database developer needs to have a strong understanding of each of these job responsibilities as well as the areas of overlap.
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:
If you want to excel in an information technology career, you need to make a career plan or plot a career road map that will take you from your current skill level to a professional, highly skilled or expert level.
You will also need to create a plan for maintaining your skills at the level of
top performers or experts in your field when you get there.
Whatever your current career (business analyst, data analyst, software
developer, report writer, database developer, web designer, etc.), you need to
sharpen your skills using one or more of the following training options:
The 2008 database developer training year begins on February 15, 2007.
Sign up now for the specially discounted enrollment fee because by February 15, the database training enrolment fee will be $500 or $750. Click this link to SQL BOOT CAMP to see how much you will save at the current enrollment fee.
Who Does The Database Developer Training Cover?
1. The database training covers everything you need to design and develop enterprise databases.
2. The database training covers SQL programming training or SQL developer training from the beginner to advanced topics as well.
SQL is one of the most popular programming languages. SQL is a programming language used to query or analyze data and develop databases. SQL is as widely successful as it is common in the software development industry. SQL is a language familiar to both geeks and the technically savvy business users or powers users as they are sometimes known.
Why Is SQL So Popular?
SQL is popular because it is the programming language used to manipulate relational databases. Relational databases are employed in practically every major business application, web development project or software application to store information.