Register now or log in to join your professional community.
I am interested in database. I am having knowledge about oracle database administration and development. I am planning to learn any other data base. can any one help me which database is very much needed in now a days market
The most common databases are Oracle, Microsoft SQL Server, MySQL, PostgreSQL and SQLite. Once you have a good grasp of the basic SQL concepts, then it is not too difficult to learn the specifics of these other databases.
Most Reliable and Costly: Oracle
Free and widely used: MySql
These days the most commonly used type in databases
SQL server
there is some tool for that as
xampp, wampp
You can start learining MySql, Its very easy to learn and has the below advantages :
MySQL is a free, open-source database management system (DBMS for short). A DBMS is a system that manages databases and connects them to software. For example, a MySQL database can be used to run a website, to run the database of an ERP or any other software.MySQL is a powerful, free open-source database management system that has been around for years. It is very stable and has a big community that helps maintain, debug and upgrade it.MySQL might not be as popular for larger systems that will mostly run on Microsoft SQL Server or Oracle. These proprietary DBMS are more scalable, have more resources available on the market and have more advanced features that MySQL.
Rank DBMS Database Model Score Changes
1.Oracle Relational DBMS 1485.12 -15.80
2.MySQL Relational DBMS 1295.78 -13.77
3.Microsoft SQL ServerRelational DBMS 1246.60 +22.81
4.PostgreSQL Relational DBMS 239.46 -0.53
5.MongoDB Document store 238.78 +7.33
6.DB2 Relational DBMS 202.01 +3.98
7.Microsoft Access Relational DBMS 144.62 +2.26
8.SQLite Relational DBMS 91.16 +1.97
9.Sybase ASE Relational DBMS 83.72 +3.03
10.Cassandra Wide column store 81.58 -0.26
Dear VIGNESH
The basic concepts of all databases are almost same, first of all you need analysis ask question yourself that why you need to learn database
Like
1. Are you already employed somewhere and want to use your skill for better data management
2. Are you looking for database related job
3. What is your current knowledge in computer science and databases?
4. Are you looking database development side or data administration side?
5. How much time you have for this learning?
So after this answer I can able to guide you and give you career oriented answer ..Meanwhile you can read and guied book that i wrote for database learners who wanted to start their careers in database or database experts who want to start there new database projects and confuse between different database software ,in this guide book I compare basic futures like there data storage capacity ,cost availability
http://www.scribd.com/doc//Comparison-of-the-Common-diffrent-Database-Systems-by-Shahzad-Asghar
If you need more support please drop me few lines
Oracle, Mysql, Sql Server
I think......
Are you in the market as a developer who writes programs accessing a database ? Well, in that case, you may start with learning SQL and PL/SQL if you want to get into Oracle Applications Developer positions.
I am an Oracle Applications Database Administrator and it is common knowledge that Oracle is the number 1 datbase product in the market. A DBA manages and adminsters Datbases only. An Oracle Applications DBA also administers Oracle Applications along with it. Oracle Applications is known as Oracle E-Business suite.
SQL Server is needed in Mediium to Large enterprises. Also NoSQL is evloving.
database systems provide a number of other properties that make them exceptionally useful and convenient: reliability, efficiency, scalability, concurrency control, data abstractions, and high-level query languages.
The most common databases are Oracle, Microsoft SQL Server, MySQL, PostgreSQL and SQLite. Once you have a good grasp of the basic SQL concepts, RDMS, In addition to persistence, database systems provide a number of other properties that make them exceptionally useful and convenient: reliability, efficiency, scalability, concurrency control, data abstractions, and high-level query languages. Then it is not too difficult to learn the specifics of these other databases.
So far the administration point of view you should learn about microsoft technologies in database like SQL Server. In other perspective the technology in database is going towards NO SQL means non RDBMS. you should learn about the technologies dealing with Big Data like Hadoop. if you get command on it, Data Scientist is your destination.
If you want to grab big corporate opportunity get certified in DB2, Terradata etc.
Thanks
