Non-Traditional Database Careers for Men and Women – Part 1

Non-Traditional Database Careers for Men and Women - Part 1
Non-Traditional Database Careers for Men and Women – Part 1

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.

10 Techniques to Keep Ahead of Your Competition

10 Techniques to Keep Ahead of Your Competition
10 Techniques to Keep Ahead of Your Competition

A recent Harvard Business Review (HBR) suggests that the information we need to do our job is doubling every 18 months, and that we are running harder and harder to keep up with the required knowledge for our specialized fields.

In this post, I will present 10 techniques that will help you keep ahead of the competition and / or changes in your industry.

Will Better Database Design Improve Sql Query Performance?

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?

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?

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.

Are you wondering about who this situation involves? You are safe my friend because today, I will mainly be talking about me 🙂

What Personality Types Are DBAs?

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.

In this post, I will describe some of the personality types of database administrators (DBAs).

Your Opinion Counts – What Makes A Good Data Analyst?

Ask a Burning Question
Ask a Burning Question

In reply to a question by a Statistician transitioning to a data analyst career, I posted the article Are Statistics Or SQL Skills Required In Data Analyst Careers?

My reply also included a Skills Gap Analysis for Statisticians or Mathematicians who want to become data analysts.

I got a comment from another Mathematician / Statistician which I have posted below.

Let me know if you have a comment or opinion or feedback on this issue … here is my reader’s comment:

Jonathan’s Opinion:

I just read through the article entitled ARE STATISTICS OR SQL SKILLS REQUIRED IN DATA ANALYST CAREERS?

SQL – Third Most In-Demand Skill

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.

How to Learn SQL or Databases

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?
  • What makes SQL query writers different from other developers?