After Access and SQL Server, need I learn others still?

[dee-u]

I already know Access and SQL Server, is it necessary for me to learn other database systems also to boost my resume? Maybe MySQL, Oracle, Sybase, etc?

[DeadEyes]

The more the better.

[Hack]

Oracle for sure and SyBase wouldn't hurt.

If you are positioning yourself to become a developer in either a commerical software company, or a mainstream corporation, I'm not sure how much MySQL is going to help. I've never encountered its use in a large company.

[RobDog888]

I think Hack is right, Oracle and MS SQL are the two big names. So if you know those that should cover most of the desired skills.

[capsulecorpjx]

I think Hack is right, Oracle and MS SQL are the two big names. So if you know those that should cover most of the desired skills.

Teradata is very popular.

I suggest: MS SQL Server, Teradata, and Oracle.
MySQL is good as a starter in being a DBA (software is free).

But really nobody cares if you say you know a technology in your resume, they only care if you have working experience.

Try to get a job, where a database system is secondary as your job function, and then you can put that on your resume.

[DirtyHowi]

former dba, currently .net developer, mssql, and oracle...

unless you want to either make people think your old, or only work in niche areas.

if your going into medical field, cache.

we use cache, i translate it into sql server then make reports out of it...

fwiw

[dee-u]

Teradata is very popular.

Only heard it first time in this thread.

But really nobody cares if you say you know a technology in your resume, they only care if you have working experience.

Try to get a job, where a database system is secondary as your job function, and then you can put that on your resume.

Well, I am a programmer now, we are currently using Access but will be planning to migrate our database to SQL Server once we finish our system (it is our IT Manages decision); and I have made one app which uses SQL Server as its back-end.

What interest me with MySQL is that whenever I stumbled into freelance programming sites most of the projects posted needs MySQL, is it because it is web-based?

[capsulecorpjx]

No Database is "web-based" or web-specialized. The basic function a database has is to store, process and return data based on SQL queries.

If you want a "web-based" function, you need to set up a web server to connect to that database.

It pretty much works like MS SQL Server in that its a database RDBMS.

MySQL works mostly on Unix/Linux, and from my experience, its mostly administered and controlled via commandline.

There is also a version of MySQL on Windows I think, but I haven't worked with it.

Anyway the primary reason MySQL is popular is because it is FREE.

Many small to medium sized companies use it, especially for web applications:

Here is a web server setup where the software is completely FREE:

OS: Linux
Web Server: Apache Web
Database RDBMS: MySQL

Only heard it first time in this thread.



Well, I am a programmer now, we are currently using Access but will be planning to migrate our database to SQL Server once we finish our system (it is our IT Manages decision); and I have made one app which uses SQL Server as its back-end.

What interest me with MySQL is that whenever I stumbled into freelance programming sites most of the projects posted needs MySQL, is it because it is web-based?

[szlamany]

Anyway the primary reason MySQL is popular is because it is FREE.

But when it's used for commercial purposes it does cost money - right?

[capsulecorpjx]

But when it's used for commercial purposes it does cost money - right?

Nope, its open source software, just like LINUX.
Costs nothing, and is actually quite good even for medium companies.

But if your business is large, you usally use Oracle or DB2.

Teradata is used for storing huge amounts of data. It is specialized in Data Warehousing. Oracle and DB2 I think store a fair amount of data, but is used more for transactions (update to the data, etc.)

Here is a demo CD for Teradata you can order, if you want to learn.
Its fully functionaly, just limited to 1 GB of data.

http://www.teradata.com/t/go.aspx/index.html?id=44749

[szlamany]

Nope, its open source software, just like LINUX.
Costs nothing, and is actually quite good even for medium companies.

That seems to be a common misperception.

It does cost money...

http://www.mysql.com/company/legal/licensing/

It's only free if you make your own software free!

We don't do that here - we use MS SQL Server and promote it greatly to our customers and anyone else who will listen!

[capsulecorpjx]

lol
Then a small company I used to work for is breaking that license.
I think they have that misconception also.
Cause I know their web app over the MySQL database is not open source.

That seems to be a common misperception.

It does cost money...

http://www.mysql.com/company/legal/licensing/

It's only free if you make your own software free!

We don't do that here - we use MS SQL Server and promote it greatly to our customers and anyone else who will listen!

[vincentg]

I dont know if you agree, much better if you learn the bigger database application. Like Oracle's business app, financing, inventory, etc, etc.
& SAP just like bigger company used.