Newbie Database Question

[user_deleted]

I've been going to a lot of job interview lately, and it seems a lot of the positions I am interviewing for (mid level tech positions) need someone with some database experience. What is a good one to learn? MySQL seems to be the popular one. Can someone recommend a good book?

[user_deleted]

It really depends on what the requirements are for the position you're applying for and your experience. If you're applying for a position where Novell SUSE Linux is used then I've found "SUSE Linux 10 Bible" useful which covers both client and server use. Then there's a long list of books related to Novell and business such as "Novell's Guide To Linux For Small Businesses" and "Suse Linux Enterprise Server 9 Administrator's Handbook". These can be found usually through your local book store or ordered online at places such as chapters.indigo.ca.

As for MySQL knowledge it can provide useful but may not necessarily be required for a low or mid level technician. We can't see what the job requirements are for you that you read so it's difficult to answer this one. Again there are several training books related to this so picking one up and getting familiar will be a useful resource to a prospective employer.

Most companies posting job positions are very specific on what the job requirements are. They may also require either certification on software or at least practical work experience as part of the qualification. You may even be asked to demonstrate your skills with a small internal test whether hands on or written test. Such a test may involve a test system with a corrupted database that they want you to resolve and time you on how long to resolve the issue. Don't get freaked out by this as the tests for experienced persons are usually not that difficult. You may also get something that even a high level tech would have no choice but to resintall the software with a backup.

[marlio]

MySQL is popular in that it tends to be paired frequently with PHP-based web applications. It has a lot of acceptance on the Linux platform but works with Windows also. MySQL.com should have lots more info in that regard.

Some might position MySQL as a mid-to low-end database due to performance and security issues, but I can't argue with the progress the PHP army has made into areas occupied by traditionally high-end apps, like portals, content management apps, and so on. Many databases employ "SEQUEL" and some formats still in use today date back to the 70s http://en.wikipedia.org/wiki/SQL

Since this is highend.com, I thought I'd mention some other less popular but potentially higher-end databases such as IBM DB2, Oracle, Rational, and PostgresSQL. They tend to be used with Java applications. Enterprise IT work is about as exciting as a yellowed chemistry manual but it's good for paying the bills, good luck.