Do You Have A Career Development Plan?

Part 20 of 20 in the Series: Career Paths for Database Professionals
Who Is Responsible For My Career?
Who Is Responsible For My Career?

Lurline from Jamaica, feels stuck in her current career and wants to be a database / business intelligence analyst. Here is Lurline’s question

Initially my goal was to become a business / Business Intelligence analyst but I have not gotten the chance to get the hands on that is so necessary.

At age 45 I think it has gotten worse I am thinking of changing career.

How can I get exposure to the top BI software and tools?

Will Better Database Design Improve Sql Query Performance?

Part 19 of 20 in the Series: Career Paths for Database Professionals
will database design improve sql queries performance?
will database design improve sql queries performance?

Well, I get a number of questions on the relationship between learning and practicing better relational database design principles and writing better, faster or more efficient Sql queries.

In this post, I will answer all these questions or the variations of them that focus on the necessity of learning database design when all you want to do is to write sql queries!

Here are some of the variations of this question:

  1. Do I need to master relational database design in other to write better Sql queries?

Is Learning Sql Online So Hard?

Part 17 of 20 in the Series: Career Paths for Database Professionals
Is Learning Sql Online So Hard?
Is Learning Sql Online So Hard?

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?

Oracle Or Microsoft Access, Which Is Better?

Part 16 of 20 in the Series: Career Paths for Database Professionals
Oracle Or Microsoft Access, Which Is Better For Me?
Oracle Or Microsoft Access, Which Is Better For Me?

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.

What Personality Types Are DBAs?

Part 15 of 20 in the Series: Career Paths for Database Professionals
What Personality Types Are DBAs?
What Personality Types Are DBAs?

This post about the personality types of database administrators (DBAs) is in response to Sandra’s question.

Sandra, thank you for taking the time to tweet a number of my posts, I appreciate you 🙂

Personality types like the Jung Myers-Briggs Type are used to describe the psychological characteristics of an individual.

For example, the famous Myers-Briggs has 16 personality types grouped as: Extroversion vs. Introversion, Intuiting vs. Sensing, Thinking vs. Feeling, and Judging vs. Perceiving.

The Entry Level Requirements For Database Jobs

Part 14 of 20 in the Series: Career Paths for Database Professionals
in demand database jobs
in demand database jobs

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?

The Database Administrator (DBA) Job Description

Part 13 of 20 in the Series: Career Paths for Database Professionals
Database Administrator (DBA)'s Job Description
Database Administrator (DBA)'s Job Description

In this issue, I will be answering a question submitted by a reader on “The Roles, Responsibilities or Job Description of Database Administrators (DBAs)“.

You can Ask IT Career Coach your toughest or most pressing questions and I will answer it fully just as I am answering this reader’s question below!

If you enjoy reading this post, please be sure to … Share this Post with Friends

Here is the reader’s question::

About The Database Administrator’s (DBA) Job Description

I am a final year BE student interested in developing a career in DBA

A Step By Step Guide For Creating SQL Reports

Part 11 of 20 in the Series: Career Paths for Database Professionals
A Step by Step Guide
A Step by Step Guide

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.

7 Top Database Careers In High Demand

Part 10 of 20 in the Series: Career Paths for Database Professionals
database careers in demand
database careers in demand

The 7 Top, In-Demand Database Careers

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.

How To Write Complicated Or Complex SQL Queries

Part 9 of 20 in the Series: Career Paths for Database Professionals
Master Complex SQL Queries
Master Complex SQL Queries

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.

Career Spotlight on Microsoft Access Database Developers

Part 8 of 20 in the Series: Career Paths for Database Professionals
Microsoft Access Developer Career
Microsoft Access Developer Career

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.

Career Outlook for Business Intelligence (BI) or Data Warehousing (DW)

Part 7 of 20 in the Series: Career Paths for Database Professionals
Competing on Analytics
Competing on Analytics

Microsoft NET Developers are well compensated IT professionals because the workplace demand for skilled Microsoft.NET programmers outstrips the supply.

On the other hand, being a Microsoft .NET programmer can be tough because of the constant pressure to keep up with new technology!

So, this post addresses the challenges facing a Microsoft .NET Developer moving to Business Intelligence (BI) / Data Warehousing (DW):

Considering a Career Move from .NET Development to Business Intelligence (BI)?

I am currently working as a .net Developer (for the last 4 years mostly on contracting jobs).

The biggest problem I am facing is not being able to keep up with new .net components coming out everyday.

Database Careers – Why Learn SQL Or RDBMS?

Part 6 of 20 in the Series: Career Paths for Database Professionals
Learn the Right Way!
Learn the Right Way!

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 Is The Job Of A Report Writer?

Part 4 of 20 in the Series: Career Paths for Database Professionals
Ask IT Career Coach
Ask IT Career Coach

Can one make a career or earn a living out of just writing SQL Reports?

Considering that there’s more to the SQL Report Writer’s job than just writing reports, the answer is yes!

The following question was posted by a report writer who is trying to get a handle on the duties, roles, responsibilities or functions of a SQL Report Writer.

Can I Make A Career Out Of SQL Report Writing?

Can one make a career out of just writing SQL Reports?

How To Become A SQL Report Writer

Part 3 of 20 in the Series: Career Paths for Database Professionals

jobs-employment-recession

The report writer as a key member of the database, sql or data analytics team is responsible for creating, validating, distributing and documenting the reports required by an organization.

Report Writers work with various types of relational databases, sql query writing and report writing tools because they need to retrieve, aggregate and present data from different databases including Oracle, SQL Server or ODBC Compliant Databases.

Since it is not practical or feasible for Report Writers to learn or master all the available database reporting tools, they specialize in a few and then learn any additional reporting tool come along on the job!

Learn SQL Online – The Easy Way!

Part 1 of 20 in the Series: Career Paths for Database Professionals
Learn Sql Online - The Easy Way!
Learn Sql Online - The Easy Way!

SQL Boot Camp is the hands-on, beginner to advanced level guide to learning SQL online.

You are shown, instructed or coached on how to write best-practice SQL code in an instructor-led, convenient and interactive web-based SQL course.

You gain mastery of SQL query writing, database design or database development by practicing as you learn from sql instructors using multiple videos, quizzes and hands-on database projects.

Why Learn SQL Online?

Databases are everywhere and virtually every firm or organization has multiple databases.

How To Become a Database Developer

Part 2 of 20 in the Series: Career Paths for Database Professionals

Top Paying Skills in High Demand
Top Paying Skills in High Demand
Employment Prospects for Database Developers

Database Developers are in-demand in the healthcare, telecommunications, financial, manufacturing industries or in firms where data needs to be stored, retrieved or maintained.

  • Database developers work with data analysts while importing data from legacy systems into new database structures.

  • Database developers work with report developers in designing and reporting on data and business trends.

  • Database developers work with system architects or software developers in defining data storage, retrieval or archival systems for business software application needs.

SQL – Third Most In-Demand Skill

Part 18 of 20 in the Series: Career Paths for Database Professionals

jobs-employment-recession

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.

Beginner To Advanced SQL Skills In Hot Demand

Part 12 of 20 in the Series: Career Paths for Database Professionals
California Gold Rush Of 1949
California Gold Rush Of 1949

Beginner to Advanced SQL Skills are among the top-paying, hottest, in-demand tech skills.

The demand for SQL skills is strongest across the breadth of Information Technology careers that includes the business analyst, web developer, data analyst, report writer, computer programmer or IT manager.

This article explains the reason why IT professionals at different stages in their careers (beginners, intermediate or senior) experience a consistently high demand for beginner to advanced SQL Query Writing skills.

How to Learn SQL or Databases

Part 5 of 20 in the Series: Career Paths for Database Professionals
How To Learn SQL or Databases Online
How To Learn SQL or Databases Online

The demand for SQL query writing or database skills is tied to the high demand for web, intranet and internet application development skills

Organizations invest in web projects because they need to automate their business operations as it grows in complexity, expands in size or becomes more profitable.

This post addresses the following questions:

  • Why is SQL query writing skills needed?
  • What do SQL query writers do?
  • How can you become a SQL query writer?