Tuesday, February 14, 2006
Databases: What to Know
- every organization has them
- no organization can thrive without them
- the more you know about them, the more valuable you become to the organization
- IBM (DB2)
- Microsoft (SQL Server)
These three competitors combined control 85% of the $15 billion database market . The marketplace provides a snapshot of their relative value. The number of job listings for each of The Big Three when searching by keyword are as follows [Monster.com listings]:
The common language of all databases is Structured Query Language (SQL). So, the more you know about SQL the more you'll be able to manage data regardless of which relational database management system (RDBMS) is being used.
According to a recent BusinessWeek article, Taking On the Database Giants, open-source database products are gaining ground. Of these MySQL appears to have the most momentum.
So, how does one get experience using these products? Here's a two-step plan:
Step #1: Learn SQL
Step #2: Learn one of The Big Three (SQL Server)
- Download SQL Server 2005 Express Edition (FREE)
- Complete one of nine Microsoft E-Learning courses (FREE) 
Why select SQL Server? Quite simply, I have not been able to identify any low-cost alternatives to learning Oracle or IBM DB2. Both products are expensive and so is the training. Microsoft, on the other hand, wants technology professionals to learn its new SQL Server 2005 product so that it can capture market share from its competitors. reference: Taking On the Database Giants
 note: The courses are designed for SQL Server 2005, not the Express Edition, so there my be some aspects of the course that may not apply to the 'lite' version of the product.